Support Board
Date/Time: Wed, 27 Nov 2024 00:24:51 +0000
Post From: Foot print chart - Sum of consecutive zero lines
| [2023-10-10 18:51:29] |
| John - SC Support - Posts: 36309 |
|
You would have to use the Spreadsheet Formula and create a fairly lengthy set of nested IF statements to do this. To get you started, here is what testing the lowest 2 levels for the Ask would look like: =IF(AVAP(L + TICKSIZE * 1, 0) = 0, 2, IF(AVAP(L, 0) = 0, 1, 0)) AVAP is the Ask Volume At Price - refer to the following for this: Study/Chart Alerts And Scanning: Special Functions So you would need to expand out from what we show above to the number of levels you want to test. This will then return the number of levels that match the condition at each bar. You can then use that in a Spreadsheet or other study. Also refer to the following for the Spreadsheet Formula study: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |