Support Board
Date/Time: Mon, 21 Apr 2025 17:49:49 +0000
Referencing volume by price
View Count: 103
| [2025-02-17 18:25:39] |
| User827002 - Posts: 38 |
|
In a spreadsheet study, I need to write a formula that tells me if any price in the upper 33% of the days range has traded at least 75% of the volume traded at VPOC. The problem is that I can't find any study that will show the volume traded at each price for me to reference. Using the VBP study I can visually see the exact volume traded at each price on my chart but I can't reference it in a spreadsheet. Do you have any idea how I can do this?
|
| [2025-02-17 18:55:57] |
| John - SC Support - Posts: 39380 |
|
Refer to the following: Spreadsheet Study Inputs: Output Volume at Price Data If the above does not give you what you want, then you might be able work out what you want using the Spreadsheet Formula since the Alert syntax that the Spreadsheet Formula uses can access per price volume data. Refer to the following: Spreadsheet Formula Study/Chart Alerts And Scanning: Special Functions If none of the above get you what you want, then you would need to create a Custom Study to get what you want. Refer to the following: ACSIL Programming Concepts: Accessing Volume at Price Data Per Bar https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php 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: