Support Board
Date/Time: Tue, 04 Nov 2025 08:44:37 +0000
project/extend previous days 15min opening range to current day
View Count: 854
| [2021-08-07 19:50:19] |
| User811622 - Posts: 38 |
|
I'm using "High/Low for Time Period - Extended" to draw current day's 15min Open Range. This works great. I would like project or extend previous day's 15min Opening Range to current day. What are my options to do this? Thanks |
| [2021-08-09 14:24:49] |
| John - SC Support - Posts: 42737 |
|
You would need to use the Spreadsheet Study and then setup a column with the data from the previous day listed for the current day. Refer to the information for the Spreadsheet Study here: Spreadsheet Systems, Alerts and Automated Trading For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-08-13 11:17:52] |
| User811622 - Posts: 38 |
|
Which section in spreadsheet study should I be looking at to do this?
|
| [2021-08-15 02:45:33] |
| User811622 - Posts: 38 |
|
I tried using spreadsheet formula indicator to plot previous day's 15min Opening Range onto current day, but doesn't seem to work. I have attached picture of my settings. My the setup, I use High/Low for time period extended indicator. 15min Opening Range is ID1 with high being ID1.SG1 and ID1.SG2 as low. For previous day's level, I added in two spreadsheet formula indicator. The first spreadsheet formula I entered in ID1.SG1[-1] for previous day 15min OR high. The 2nd spreadsheet formula I entered in ID1.SG2[-1] for previous day 15min OR low. This plot but it plots on the current day's 15min OR. Please advice. |
 previousDay-15min-OR issue.PNG / V - Attached On 2021-08-15 02:45:12 UTC - Size: 257.28 KB - 279 views |
| [2021-08-16 15:56:00] |
| John - SC Support - Posts: 42737 |
|
You can do it the way you are, but you need to set the offset to a value that moves you into the previous day. Since you are using 1 minute bars, this would mean that the number between the square brackets should be at least -1440. So your formula would be ID1.SG1[-1440]. 1440 is the number of minutes in one day. As long as you are not showing the Developing High/Low, then you should be fine using this number even though there may not be a full 24 hours of trading information. We are not really sure where the 15 minutes comes into play, as you are using 1 minute bars, but if this were a 15 minute chart then the offset would be -96 (24 * 4). 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: