Login Page - Create Account

Support Board


Date/Time: Mon, 17 Mar 2025 11:56:44 +0000



Post From: Overnight High Low Lines on Next Day session

[2022-09-05 22:25:01]
Sawtooth - Posts: 4185
Try this:

1. Add the High/Low for Time Period study.
-Set the Start Time to the start of the overnight period.
-Set the End Time to the end of the overnight period.
-Hide the study.

2. Add the Spreadsheet Formula study.
-Set the Chart Region to 1.
-Set 'Draw Zero Values' to No.
-Use a formula like this in the Formula field:
=IF(AND(ID1.SG1[-1]>0,ID1.SG1=0),ID1.SG1[-1],IF(AND(ID1.SG1[-1]=0,ID1.SG1>0),0,ID2.SG1[-1]))
where ID1.SG1 is the High/Low for Time Period study's High, and ID2 is this Spreadsheet Formula study.
-Set the DrawStyle to Dash.
This will extend the ONH into the RTH.

3. Duplicate the above Spreadsheet Formula study.
-Edit the formula in the Formula field like this:
=IF(AND(ID1.SG2[-1]>0,ID1.SG2=0),ID1.SG2[-1],IF(AND(ID1.SG2[-1]=0,ID1.SG2>0),0,ID3.SG1[-1]))
where ID1.SG2 is the High/Low for Time Period study's Low, and ID3 is this Spreadsheet Formula study.
This will extend the ONL into the RTH.