Login Page - Create Account

Support Board


Date/Time: Thu, 16 Jan 2025 06:00:40 +0000



Post From: Settlement

[2024-11-07 20:07:11]
John - SC Support - Posts: 37270
You would need to use a Spreadsheet Study and enter a formula like the following in order to only show the Close at a certain time (i.e. the last 1 minute bar):
=IF(FRACTIME(A3) = TIME(15, 00, 00), ID1.SG4@3, 0)

Where ID1 is the ID of the Daily OHLC study, SG4 is the Close Subgraph of the Daily OHLC study, the @3 says to use row 3 of the spreadsheet for that study and subgraph. Refer to the following:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#FRACTIME_Function

https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TIME_Function

Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study

You can then hide the Daily OHLC study and use the Spreadsheet to display what you want.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing