Login Page - Create Account

Support Board


Date/Time: Sun, 22 Feb 2026 15:54:34 +0000



Post From: feature request - cumulative delta while a position is open

[2014-10-05 16:50:43]
Bedhog - Posts: 184
Thank you tomgilb,

I'm seeing #REF! in H1. These are 'new spreadsheets' and circular references are not allowed. Is that the issue?

I'm also not certain about the reference in O3 regarding A2 as the value of A2 will always show the string 'Date Time'. Same issue - new spreadsheets?



H1:
=INDEX(AD3:AD1002,MATCH(TRUE,O3:O1002,0),1)

AD:
[ID2.SG4] Cumulative Delta Bars - Volume - Close

O3:
=AND($J$42>A3,$J$42<A2)





Date Time Of Last Edit: 2014-10-05 16:51:23