Support Board
Date/Time: Mon, 12 May 2025 06:55:00 +0000
Post From: hourly opening range
| [2015-09-23 13:19:28] |
| Sawtooth - Posts: 4214 |
|
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) |