Support Board

Date/Time: Sat, 20 Apr 2024 11:18:53 +0000

Post From: hourly opening range

[2015-09-23 13:19:28] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
You could do this easily with the Spreadsheet Study study: 1) Add the High/low For Time Period-Extended study -Move this study to the top of the Studies to Graph list -Set the Start Time and End Time to your Opening Range requirements, e.g. 09:30:00 / 09:34:59 -Check 'Hide Study' 2) Add the Spreadsheet Study study a) Settings and Inputs tab: -Set the Chart Region to 1 -Check 'Draw Study Underneath Main Price Graph' -Give it a name in the Spreadsheet Name field b) Subgraphs tab: -Set the Draw Style of SG2 to Fill Top and choose color -Set the Draw Style of SG3 to Fill Bottom -Set the Draw Style of all other subgraphs to Ignore c) On the spreadsheet: cell K1: =M1*60/J36 cell L1: OR display minutes -> cell M1: this is the duration of the displayed band, in minutes (60, per your example). cell K3: =IF(AND(AA4=0,AA3>0),1,K4+1) cell L3: =IF(AND(K3>=1,K3<=$K$1),AA3,0) cell M3: =IF(AND(K3>=1,K3<=$K$1),AB3,0)