Login Page - Create Account

Support Board

Date/Time: Fri, 03 Feb 2023 23:32:43 +0000

adding an offset to the exchange price data

View Count: 84

[2022-11-23 12:10:11]
amirN - Posts: 158
Hi, I am trying to use SC as a charting package to my CFD order entry platform. However, the prices on the CFD platform are at a fixed offset compared to the index future prices. Is there an option in SC to add an offset to the real-time/historical price so as my charts, levels and indicators can be used without a lot of mental gymnastics on the CFD platform?
[2022-11-23 15:56:58]
John - SC Support - Posts: 21946
The best way to do this would be to use the Spreadsheet Formula (Bar) study as this will allow you to shift the entire bar by the amount you want. If it is a consistent offset then you would just need to enter the information for each item - Open, High, Low, and Close and use the shortcut terms for these which are O, H, L, and C respectively.

For example, if the price difference is 15.45 then you would enter the following for the Open:
=O + 15.45

and then do the same for the rest of the items. Refer to the following for information on the Spreadsheet Formula studies:
Spreadsheet Formula

If you want this to then be your main graph, enable the option on the Spreadsheet Formula (Bar) study for Display as Main Price Graph. Refer to the following for information on this setting:
Chart Studies: Settings and Inputs Tab >> Display As Main Price Graph
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 Page - Create Account