Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 22:17:07 +0000



Post From: Study Name for Value # bars ago ?

[2014-04-22 14:26:32]
Sawtooth - Posts: 3993
Add the Spreadsheet Study study
-set the Chart Region to 1
-give it a name in the Spreadsheet Name field
-set the Draw Style of (K)SG1 to Value On High
-set the Draw Style of (L)SG2 to Value On Low
Use these formulas:
cell K3:
=IF(ROW()=3,INDIRECT(ADDRESS($K$1+3,3)),0)
cell L3:
=IF(ROW()=3,INDIRECT(ADDRESS($K$1+3,4)),0)
cell K1:
# of bars ago