Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 09:20:55 +0000



Post From: Study Name for Value # bars ago ?

[2014-04-22 19:35:57]
Sawtooth - Posts: 4120
That requires different formulas. Try this:

K3:
=INDEX(C$3:INDIRECT("C"&$J$30+2),O3,1)
L3:
=INDEX(D$3:INDIRECT("D"&$J$30+2),O3,1)
O3:
=IF(ROW()=3,RIGHT(ADDRESS($K$1+1,1,3)),O2+1)
K1:
# of bars ago