Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 09:51:53 +0000



Post From: Study Name for Value # bars ago ?

[2014-04-22 14:26:32]
Sawtooth - Posts: 4120
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