Support Board
Date/Time: Thu, 05 Mar 2026 22:41:38 +0000
RTH OPEN
View Count: 27
| [2026-03-05 19:46:13] |
| User411320 - Posts: 371 |
|
Hello, I'm trying to reference the open of RTH in spreadsheet. I tried using the DAILY OHLC study but that is not the open price I'm looking for. just the NYSE 9:30 am EST open |
| [2026-03-05 21:09:56] |
| John - SC Support - Posts: 44966 |
|
We are not understanding what exactly you are trying to do and what you are wanting to do with it. Please tell us what it is you are wanting to accomplish. Do not give us methodologies - we just need to know what you are wanting to do, we can then point you to the best way to accomplish this. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-03-05 21:48:54] |
| User411320 - Posts: 371 |
|
I want to use the 9:30 AM EST open price in a spreadsheet formula.
|
| [2026-03-05 22:11:55] |
| John - SC Support - Posts: 44966 |
|
You would need to use another copy of the "Spreadsheet Formula" to get that value and then be able to use it in another Spreadsheet Formula. If you are using a time-based chart and 09:30 is a valid time where a bar will open, then to get the value, use the following formula: =IF(BARTIME = TIME(09, 30, 00), O, ID1.SG1[-1]) Where "O" is an "oh" as in "Open", ID1 is the ID of that Spreadsheet Formula where you are entering this formula, ID1 is the subgraph of that spreadsheet formula, and [-1] says to reference the previous bars information. Then you can use that spreadsheet study ID and subgraph (i.e. ID1.SG1) in your other Spreadsheet Formula. Refer to the following: Study/Chart Alerts And Scanning: Available Main Price Graph Identifiers/Variables https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TIME_Function 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: