Login Page - Create Account

Support Board


Date/Time: Mon, 13 Jul 2020 08:21:46 +0000



Post From: hourly opening range

[2015-09-23 13:19:28]
tomgilb - Posts: 2602 | Ending Date: 2020-12-03
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)