Login Page - Create Account

Support Board


Date/Time: Thu, 31 Oct 2024 23:58:25 +0000



Calculating a different VOLD ratio

View Count: 423

[2024-04-08 17:53:31]
rkg - Posts: 11
I want to calculate the NYSE volume up to volume down and plot it as a ratio that can be positive or negative.

If buy volume = 10, sell volume = 5, I would like to see a ratio of 2

If buy volume = 5, sell volume = 10, I would like to see a ratio of -2

UDVR-NYSE calculation only fits the criteria when buy volume > sell volume as UDVR will never be negative.


Any suggestions on how I can make this work? I have tried messing around with UVOL / DVOL and the ratio study but I cannot figure out a solution.
[2024-04-08 19:11:46]
John - SC Support - Posts: 35678
You could use the "Spreadsheet Formula - Bar" to create bars that are the way you want, you would just have to decide on which item (Open/High/Low/Close) you would actually make the switch. For example, to change the bar High when the Close is less than 1, you would have the following formula:
=IF(C < 1, -1/H, H)

You can work out the rest from this.
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:

Login

Login Page - Create Account