Support Board
Date/Time: Sat, 30 Nov 2024 06:48:20 +0000
Opening 30min range for every month
View Count: 737
| [2022-06-15 22:33:32] |
| User843179 - Posts: 7 |
|
I would like to highlight the 30min opening range for the first trading day of each month. Is it possible to do this using the 'High-Low for time period - extended' study? It appears that the study is preset to apply to all days within the dataset, and cannot be specified to apply to a subset of days only. Failing that, is there any other way to achieve what I am trying to do? Thankyou :) |
| [2022-06-16 15:32:34] |
| John - SC Support - Posts: 36350 |
|
The only way that we can think to do this would be to use the High/Low for Time Period along with the Spreadsheet Study. In the Spreadsheet Study you would have to find the first day of the month and then use the spreadsheet function for "EARLIESTNONZEROVALUE()" to fill in the data from the first day of the month. Refer to the information for EARLIESTNONZEROVALUE() here: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#EARLIESTNONZEROVALUE_Function For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-06-22 23:14:06] |
| User843179 - Posts: 7 |
|
Hi John, Thanks for your response. This is my first time using spreadsheet studies, so I may have a few questions to run through how precisely to achieve what you described. 1. When you say 'find the first day of the month' - do you mean I would manually find the first day of the month, or is there some lookup function to use? After I find it, what should I do with it? eg enter that row / range into the "EARLIESTNONZEROVALUE()" formula? 2. My understanding is the EARLIESTNONZEROVALUE formula will capture the last nonzerovalue within a specified spreadsheet range. If I manually identify the date for first trading day of the month, and specify the 9.30-10.00am row of that day as the range for EARLIESTNONZEROVALUE formula, what to do next? eg will the formula collect the high and low data from that row for me? If it does collect the H-L data, how to transform that into a graphical output on the chart? Thankyou, I am looking forward to hear from you. |
| [2022-06-23 14:59:38] |
| John - SC Support - Posts: 36350 |
|
In trying to put together an example for you, we found that the amount of data that is needed is too much for the spreadsheet, as you would have to have at least 15 minute bars. So we can not think of a way to do this without creating a custom study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-06-24 02:53:45] |
| Sawtooth - Posts: 4123 |
|
Try this: 1. Add a chart to your chartbook with these settings: Session Times: 09:30:00 to 09:59:59 Bar Period: 0-30-0 Data Limiting: Days to Load: 100, more if using continuous contract. This assumes your opening time is 09:30 2. Add the Spreadsheet Study study. - Set the Chart Region to 1. - Give it a name in the Spreadsheet Name field. - Set the Draw Styles : SG1: Ignore SG2: Dash SG3: Dash SG4: Ignore - Formulas on the spreadsheet: K3: =EOMONTH(A3,-1)+1 L3: =IF(K3>K4,C3,L4) M3: =IF(K3>K4,D3,M4) 3. On the chart where you want the Opening Range: - Add the Study/Price Overlay study. - Set the Study to Overlay to the spreadsheet study on the other chart. - Set the 'Bar Time Matching Method' to Containing Match Date Time Of Last Edit: 2022-06-27 16:23:28
|
| [2022-06-24 13:19:06] |
| John - SC Support - Posts: 36350 |
|
Thank you Tom. You always come up with the best solutions.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: