Support Board
Date/Time: Thu, 06 Mar 2025 03:58:32 +0000
Post From: Trying to reference cum' delta bars - volume study returns NAV error
| [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
|