Support Board

Date/Time: Wed, 27 Nov 2024 06:29:08 +0000

Post From: Highlighting opening range for weekly and monthly

[2023-09-22 04:10:43] Link To Thread - Link To Post [Go To First Post]
User61168 - Posts: 403
User274507 - You could use the fabulous Spreadsheet formula study to do just about anything. Learn about this study and it will open the door to all kinds of possibilities. Use this formula =IF(H>ID34.SG1[-1],H,ID34.SG1[-1]) with stairstep drawstyle to draw the Higher Highs from first bar on your chart to the last bar. ID34 is the spreadsheet formula study. Create a similar study for Lows to simulate "High/Low for Time Period" study You could also use date and time criteria to achieve the desired outcome. This one could give you the current month of september Highs for the Monday-Friday NYSE session as an example... =IF(AND(BARDATE>=DATEVALUE("09/18/2023"),OR(WEEKDAY(BARDATE)=2,WEEKDAY(BARDATE)=3,WEEKDAY(BARDATE)=4,WEEKDAY(BARDATE)=5,WEEKDAY(BARDATE)=6) ,BARTIME>=TIMEVALUE("09:30:00"),BARTIME<=TIMEVALUE("16:59:59"),H>ID34.SG1[-1]),H,ID34.SG1[-1]) Happy coding!