Support Board
Date/Time: Sun, 24 Nov 2024 23:53:23 +0000
Volume in upper third of bar
View Count: 183
| [2024-04-22 19:38:02] |
| User664207 - Posts: 9 |
|
Curious how to capture the volume in upper third of a bar’s range. (H-(H-L)*.70). Can it be done with a spreadsheet formula? Or if using numbers bars and grabbing ask volume data for the edge of the bar only? Thanks!!
|
| [2024-04-22 19:54:33] |
| John - SC Support - Posts: 36238 |
|
There is not an easy way to do this using the built-in functions. It would be much easier to create a custom study. But, the way to approach the problem using the available tools would be to start with a Spreadsheet Study. You need this to get the starting price that is at the 70% value of the bar range. The Spreadsheet Study is needed in particular to round the value to the nearest Tick, so you are starting with a valid price point. Once you have that price established in the Spreadsheet Study, then you would use the Spreadsheet Formula to add up the data. The Spreadsheet Formula, despite its name, uses the Alert syntax, and within the alerts you can get the Total Volume, Bid Volume, or Ask Volume at each price level. Therefore, you would end up with a formula that looks like the following to add up the Ask Volumes from the price established in the Spreadsheet Study (in this example we are only adding up 3 levels - you would have to add as many as would be necessary to cover the range of the prices you want): =AVAP(ID1.SG1, 0) + AVAP(ID1.SG1 + TICKSIZE, 0) + AVAP(ID1.SG1 + TICKSIZE * 2, 0) Where ID1 is the ID of the Spreadsheet Study and SG1 is the spreadsheet column that has the starting price for each bar. Refer to the following: Using the Spreadsheet Study Using the Spreadsheet Study: Rounding of Values to Tick Size Study/Chart Alerts And Scanning: Special Functions 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: