Login Page - Create Account

Support Board


Date/Time: Thu, 16 Jan 2025 05:43:54 +0000



Settlement

View Count: 1809

[2017-06-16 18:11:50]
User956467 - Posts: 30
How can I chart yesterday's settlement on an intraday chart? I am using CQG FIX Trading. Thanks!
[2017-06-16 18:18:44]
Sierra Chart Engineering - Posts: 104368
The way to do this is to use the Daily OHLC study:
http://www.sierrachart.com/index.php?page=doc/StudiesReference.php&ID=137#Daily_OHLC

And then have it reference a Historical Daily chart.

The documentation explains how to do that.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-11-07 16:50:00]
lservin29 - Posts: 46
what if you want to limit the line or stepped to only show this "settlement price" CLOSE of DLY OHLC at the close of cash session for ES and NQ, at 15:59 only, instead of it being a line that shows and moves with price action all day long? I am overlaying it on to my dly TPO and image are results
attachmentsettlement.pdf - Attached On 2024-11-07 16:49:46 UTC - Size: 22.73 KB - 39 views
[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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account