Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 08:02:04 +0000



how to get 30 sec opening range for Sunday globex

View Count: 412

[2023-05-16 20:43:10]
User449884 - Posts: 155
what are the settings to see it from the opening 30 secs range on Sunday on ES?
[2023-05-16 21:05:01]
John - SC Support - Posts: 36350
If we are understanding your question, you would just need a chart set for 30 second bars and then the first bar on the Sunday open is the opening range.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-05-16 21:19:09]
User449884 - Posts: 155
is there a way to have it for Sunday only ? because globex on sunday opens at 7pm est but its 6pm est on weekdays i think
[2023-05-16 21:58:09]
John - SC Support - Posts: 36350
For what it is worth, the opening is the same time on Sunday as the rest of the week - which is 6:00pm Central US time.

But, if you need the data just from Sunday, then you would want to use the Spreadsheet Study to specify the time and day of the week to get the particular data. For example, if you want to get the Open from the bar on Sunday with a start time of 6:00pm, then you would enter the following in cell K3:
= IF(AND(WEEKDAY(A3) = 1, HOUR(A3) = 18, MINUTE(A3) = 0), ID0.SG1@3, 0)

You can then get that particular data point replicated up to the current bar using the MOSTRECENTNONZEROVALUE() on the range of the data in K3.

You can adapt the above to get your Bar Range by referencing the Bar Range study in your IF statement.

You will find the information on these spreadsheet functions at the following link:
Spreadsheet Functions
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-05-19 00:58:54]
User449884 - Posts: 155
Thanks for rectifying this. I will venture into the spreadsheet study

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

Login

Login Page - Create Account