Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 14:40:35 +0000



Post From: WTI CL 321 Crack spread,custom symbol creation

[2023-08-31 19:27:08]
John - SC Support - Posts: 36287
Based on how your "Crack spread 3:2:1" is setup we are not sure how you got anything to display. In fact, you should not have, as you had the "Study Subgraph Divide" set to be the Main Price Graph, and since the "Based On" was set to "Main Price Graph", you had it dividing itself.

Also, the Study Subgraph Divide only gives you a single value - the Last. If you want to see bars then you have to do this a different way.

Since you are wanting to view the spread using the Continuous Data, you would have to have a total of 4 charts. 3 are the standard charts for RV, HO, and CL, and the 4th can be any symbol - you just need this fourth to bring in the data from the other 3. In the 4th chart use 3 copies of the Study/Price Overlay to bring in the data from the other 3 charts.

Then you would use the "Spreadsheet Formula - Bar" to display the spread by entering in a formula for each item - Open/High/Low/Close. The Formula would look like the following for the Open:
=(-3 * ID1.SG1 + 84 * ID2.SG1 + 42 * ID3.SG1)/3

Where ID1 is the overlay for the CL, ID2 is the overlay for the RB and ID3 is the overlay for the HO.

Where the ID of each study would stay the same, but the SG numbers will change for each item - Open/High/Low/Close.

You could then set the Spreadsheet Formula - Bar to be the Main Price Graph.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing