Support Board

Date/Time: Thu, 25 Apr 2024 12:09:29 +0000

Post From: hourly opening range

[2015-09-24 14:35:43] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
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