Support Board
Date/Time: Fri, 06 Mar 2026 00:15:42 +0000
Post From: RTH OPEN
| [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 |