Support Board
Date/Time: Wed, 27 Nov 2024 00:27:00 +0000
[User Discussion] - Foot print chart - Sum of consecutive zero lines
View Count: 272
| [2023-10-10 17:29:42] |
| User347921 - Posts: 39 |
|
Hello, I'd like to sum up the opposite side of consecutive zeros at the extreme of a bar, but could n't find any study which provides this level of details and which can be imported in a spreadsheet (Alert or Trading). Anyone has an idea how to do this please? Thanks!
|
 2023-10-10 Zero Trades NQ.png / V - Attached On 2023-10-10 17:28:47 UTC - Size: 114.73 KB - 68 views |
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: