Login Page - Create Account

Support Board


Date/Time: Thu, 20 Jun 2024 18:22:57 +0000



Highlighting opening range for weekly and monthly

View Count: 276

[2023-09-18 21:05:30]
User274507 - Posts: 37
Hi,

So I have 120min bar chart with weekly VP and a 4hr bar chart with monthly VP. I want to highlight and extend the high and low of the first bar on each new week for the weekly VP until the next end of the week/start of next week. Would like to do similar for the 4hr bar chart: highlight the first 4hr bar for each new mothly VP in same way.

So kinda like an opening range but for higher time frame. I can't seem to use the IB or high/low studies for this as they are for daily. Are you able to recommend a study which could do this?

thanks,
Nick
[2023-09-19 21:17:52]
John - SC Support - Posts: 32495
We would recommend using the "High/Low for Time Period" in order to get the High and Low values for the particular time period you are wanting depending on the chart.

Then you would need to use the Spreadsheet Study to get the specific bar values you want and then duplicate that data across the time period you want. This gets a bit complex, so it's not something we can help directly with, but it can be done.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-09-22 04:10:43]
User61168 - Posts: 368
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!

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account