Support Board
Date/Time: Thu, 18 Sep 2025 00:39:52 +0000
FORMULA
View Count: 43
| [2025-09-11 17:23:20] |
| User220939 - Posts: 56 |
|
Hi, In a "spreadsheet formula" study, I put the following formula: =AND(AVAP(H-TICKSIZE*1)/AVAP(H-TICKSIZE)). With this calculation, I want to see the ratio between the second digit and the first in a footprint bar. But it doesn't work and I can't find where I'm making the mistake. |
| [2025-09-11 17:47:39] |
| John - SC Support - Posts: 41880 |
|
"TICKSIZE*1" is equal to TICKSIZE. So you should get a value of 1 every time. Also, you are missing the offset parameter for the AVAP. And the use of the "AND()" is not required, as you only have a single condition being tested. If you want to divide the Ask volume at the second highest price level by the Ask volume at the highest price level, then the formula would be the following: = AVAP(H - TICKSIZE, 0) / AVAP(H, 0) 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: