Support Board

Date/Time: Mon, 17 Mar 2025 11:05:43 +0000

Post From: Overnight High Low Lines on Next Day session

[2022-09-05 22:25:01] Link To Thread - Link To Post [Go To First Post]
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.