Support Board
Date/Time: Tue, 18 Mar 2025 09:54:01 +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 |