Login Page - Create Account

Support Board


Date/Time: Tue, 07 Jul 2020 18:58:01 +0000



Post From: hourly opening range

[2015-09-24 14:35:43]
tomgilb - Posts: 2586 | Ending Date: 2020-12-03
With the Number of Formula Columns set to 16, Formula Columns are K-Z. With the Number of Formula Columns set to 60, Formula Columns are K-BR. Or anything in between.

With the Number of Formula Columns set to 16, and with the High/low For Time Period-Extended study at the top of the Studies to Graphs list, the High/low For Time Period-Extended study outputs to columns AA and AB. Another instance of the High/low For Time Period-Extended study that is second from the top of the Studies to Graph list will output to columns AD and AE:
cell N3:
=IF(AND(AD4=0,AD3>0),1,N4+1)
cell O3:
=IF(AND(N3>=1,N3<=$K$1),AD3,0)
cell P3:
=IF(AND(N3>=1,N3<=$K$1),AE3,0)

The above applies if the Number of Formula Columns is 16. If you change this setting, the High/low For Time Period-Extended study's output will move to columns to the right. 16 columns would only give you enough Formula Columns for 5 range bands.

As an example, if the Number of Formula Columns is set to the max of 60, the High/low For Time Period-Extended study at the top of the Studies to Graph list will output to columns BS and BT:
cell K3:
=IF(AND(BS4=0,BS3>0),1,K4+1)
cell L3:
=IF(AND(K3>=1,K3<=$K$1),BS3,0)
cell M3:
=IF(AND(K3>=1,K3<=$K$1),BT3,0)

The band display duration for all range bands is still set in M1.
Date Time Of Last Edit: 2015-09-24 15:14:44