Support Board

Date/Time: Thu, 06 Mar 2025 04:12:54 +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: 4179
=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