Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 00:36:51 +0000



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

[2014-10-03 14:33:49]
Sawtooth - Posts: 4120
You can do this with the Spreadsheet System for Trading study, and the Text Display for Study study.

1) Add the Spreadsheet System for Trading study, give it a name in the Spreadsheet Name field.
Use these formulas:
H1:
=INDEX(AD3:AD1002,MATCH(TRUE,O3:O1002,0),1)
(This assumes the cumulative delta close value is in column AD.)
O3:
=AND($J$42>A3,$J$42<A2)
P3:
=IF($J$8<>0,$H$1,0)
J28:
=TRUE
DO NOT put any formulas in K3,L3,M3,N3.

2) Add the Text Display for Study study
-Set the Study and Subgraph to Display to the spreadsheet study and SG6.