Support Board

Date/Time: Fri, 03 May 2024 01:22:02 +0000

Post From: how to get 30 sec opening range for Sunday globex

[2023-05-16 21:58:09] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 31334
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