Support Board
Date/Time: Wed, 05 Mar 2025 19:43:58 +0000
[Programming Help] - Trying to reference cum' delta bars - volume study returns NAV error
View Count: 552
| [2022-01-19 12:04:17] |
| VolTrader73 - Posts: 136 |
|
Hello. Am trying to have a horizontal line plotted on the Cumulative Delta Bar - Volume study, using SpreadSheet formula study. This works perfectly when using it in region 1 and referencing the main price chart, =IF(C > H[-1], L, IF(C < L[-1], H,ID1.SG1[-1])) The CDB study is in region 2 of my chart plotted as a candle stick and its ID is 3. Its O,H,L,C SG's are 1,2,3,4. Using the spreadsheet formula study (ID1) in region 2 =IF(ID3.SG4 > ID3.SG2[-1], ID3.SG3, IF(ID3.SG4 < ID3.SG3[-1], ID3.SG2,ID1.SG1[-1])) This returns and NAV error and region 2 becomes empty. What am I doing wrong ? Also, how do I reference the highest high of the last 5 bars for ID3 using the spreadsheet formula study. =Highest(H,5) ?? Please advise. Date Time Of Last Edit: 2022-01-20 09:47:18
|
| [2022-01-21 06:47:34] |
| VolTrader73 - Posts: 136 |
|
Hello. Any advise on this ? Thank you |
| [2022-01-21 18:29:03] |
| Sawtooth - Posts: 4179 |
|
=IF(ID3.SG4 > ID3.SG2[-1], ID3.SG3, IF(ID3.SG4 < ID3.SG3[-1], ID3.SG2,ID1.SG1[-1]))
This works for me, so I'm not sure what is wrong.This returns and NAV error and region 2 becomes empty. What am I doing wrong ? how do I reference the highest high of the last 5 bars for ID3 using the spreadsheet formula study.
Try this:=MAX(ID3.SG2[0:-5]) Study/Chart Alerts And Scanning: Referencing A Range of Data |
| [2022-01-24 12:59:09] |
| VolTrader73 - Posts: 136 |
|
Thank you TOM!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: