Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 00:27:44 +0000



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

[2014-10-05 16:50:43]
Bedhog - Posts: 179
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