Login Page - Create Account

Support Board


Date/Time: Tue, 18 Mar 2025 03:43:31 +0000



Post From: number bar study in spreadsheet formula

[2022-09-12 15:15:03]
John - SC Support - Posts: 38735
Your formula would look like the following:
=IF(VAP(L, 0) < x, VAP(L, 0), (IF(VAP(L+TICKSIZE*1, 0) < x, VAP(L+TICKSIZE*1, 0), (IF(VAP(L+TICKSIZE*2, 0) < x, VAP(L+TICKSIZE*2, 0), ...))))


Keep in mind the ... above is for you to continue to write out the IF formulas to cover the entire height of the bars. You may also need to put in a special check against 0 values, such as:

IF(AND(VAP(L, 0) < x, VAP(L, 0) > 0), VAP(L, 0), IF(AND...

It can get quite complicated.

Also, as noted above, since you are dealing with Total Volume and not individual Bid/Ask volumes, you could use the Spreadsheet Study instead.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing