Support Board

Date/Time: Tue, 24 Jun 2025 21:01:32 +0000

Post From: Trying to reference cum' delta bars - volume study returns NAV error

[2022-01-21 18:29:03] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4229
=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 ? This works for me, so I'm not sure what is 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