Support Board
Date/Time: Tue, 04 Mar 2025 07:28:41 +0000
[Programming Help] - Cumulative Delta Bar Range Ratio
View Count: 918
| [2021-11-19 16:27:48] |
| ssangha84 - Posts: 126 |
|
Hello, are there any studies similar to the "volume bar range ratio" but for the cumulative delta bars? So basically a study that shows the cumulative delta bars size compared to the size of the corresponding price bar.
|
| [2021-11-19 17:13:40] |
| John - SC Support - Posts: 38341 |
|
There is not a study that does this, but you can use the Spreadsheet Formula to do this. You would just use the following formula: =(H - L)/(ID1.SG2 - ID1.SG3) Where ID1 is the ID of the Cumulative Delta Bars study and SG2 and SG3 are the High and Low (respectively) of the Cumulative Delta Bars Study. Refer to the following for the Spreadsheet Formula: Spreadsheet Formula For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-11-19 23:12:38] |
| ssangha84 - Posts: 126 |
|
OK... not sure what I am doing wrong, but I put that formula in and it just gives me a value of 1.0 throughout the whole study. I can't seem to find what I am doing wrong in the link you sent either. Am I missing something?
|
| [2021-11-23 14:38:22] |
| ssangha84 - Posts: 126 |
|
Not sure if anyone saw my most recent post, but wanted to know what I was doing wrong with the Spreadsheet Formula study.
|
| [2021-11-23 14:46:56] |
| Sawtooth - Posts: 4179 |
|
It works for me, if I edit the formula to reference the correct ID# of my Cumulative Delta Bars study. What is the ID# of your Cumulative Delta Bars study? |
| [2021-11-23 16:44:41] |
| ssangha84 - Posts: 126 |
|
By ID# do you mean what chart # it is? If so, the delta bar chart is #7. So I changed my formula to: =(H - L)/(ID7.SG2 - ID7.SG3) The chart I am attaching is how it is showing up. It changed all of the spreadsheet formula values to "0.00" now. |
 DeltaChart.jpg / V - Attached On 2021-11-23 16:43:16 UTC - Size: 116.43 KB - 153 views Attachment Deleted. |
| [2021-11-23 17:11:30] |
| Sawtooth - Posts: 4179 |
|
The ID# is not the Chart# The ID# is the study's ID# that was assigned to it when it was added to the chart. In the pic, the Cumulative Delta Bar - Volume study is ID2, because it was the second study added to the chart. So the formula must reference the study's ID# to return the correct value. |
| Capture.PNG / V - Attached On 2021-11-23 17:09:24 UTC - Size: 33.56 KB - 146 views |
| [2021-11-23 18:37:50] |
| ssangha84 - Posts: 126 |
|
Ok, so it looks like when I get rid of the (H-L) in the formula, the study actually populates with actual bars. So is that potentially happening because I don't have a price chart on this actual window? Right now when the formula is just the following, it seems to be working the way its supposed to: =(ID1.SG2 -ID1.SG3) Would there be a way to incorporate the High/Low with the corresponding price bar without actually putting the price chart in this window? |
| DeltaChart2.jpg / V - Attached On 2021-11-23 18:37:31 UTC - Size: 151.53 KB - 146 views Attachment Deleted. |
| [2021-11-23 19:43:39] |
| Sawtooth - Posts: 4179 |
|
Would there be a way to incorporate the High/Low with the corresponding price bar without actually putting the price chart in this window?
You would need to have another chart of the price bars, then overlay them to the chart with the Cumulative Delta Bars - Volume as main price graph, so that you can compare the two.Use the Overlay (Bar) study on the Cumulative Delta Bars - Volume as main price graph chart. Set the Chart Number to Overlay to the price bar chart#. You can Hide this study if you want. Then use the Spreadsheet Formula study on the Cumulative Delta Bars - Volume as main price graph chart, with a formula like this: =(ID2.SG2 - ID2.SG3)/(ID1.SG2 - ID1.SG3) where ID1 is the Cumulative Delta Bars study where ID2 is the Overlay (Bar) study Edit the formula as needed so that the correct study ID# is referenced. |
| [2021-11-23 20:35:17] |
| ssangha84 - Posts: 126 |
|
Great, that looks like it worked. Thank you very much for all your help!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: