Support Board
Date/Time: Tue, 18 Mar 2025 06:43:35 +0000
Post From: number bar study in spreadsheet formula
| [2022-09-09 14:25:53] |
| John - SC Support - Posts: 38735 |
|
1. The Bid Volume and Ask Volume data is not directly available. The best way to access that information is by creating a custom study. It can kind of be done using the Spreadsheet Formula, since there are special functions for referencing that data for an alert. Refer to the following: Study/Chart Alerts And Scanning: Special Functions The tough part is that if you want to have access to all the numbers, you would have to add a Spreadsheet Formula study for each price level that the bar covers, not to mention one set of studies for the Bid and another for the Ask. If you are just wanting to see if a value is above a certain level, then you could use an IF statement and something like the following: =IF(BVAP(L, 0) > x, BVAP(L, 0), (IF(BVAP(L+TICKSIZE*1, 0) > x, BVAP(L+TICKSIZE*1, 0), (IF(BVAP(L+TICKSIZE*2, 0) > x, BVAP(L+TICKSIZE*2, 0), ...)))) 2. It depends on what you want to do with the data and whether you want to use the actual number or the modified number. We really can not say what you need to do, as it depends on what you are doing and how you want to view the information. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |