Login Page - Create Account

Support Board


Date/Time: Thu, 21 Nov 2024 21:09:41 +0000



Post From: Composite Symbols Same Origin Point

[2023-05-16 15:31:38]
John - SC Support - Posts: 36198
You would have to adjust those other items by the amount of the value at that point in the chart. To get that first data point, you would need to use the Spreadsheet Study and the Bar Numbering study.

Then in K3 of the Spreadsheet Study you would enter the following:
=IF(ID1.SG1@3 = 1, ID0.SG1@3, 0)

Where ID1 is the Bar Numbering Study and ID0 is the Main Price Graph - so the particular Subgraph from the main Price you want would need to be used for the SG1 (SG1 is the Open).

You would also have to ensure that the Spreadsheet Study has enough rows to cover the entire chart.

Then in cell L3 you would enter the following:
=MOSTRECENTNONZEROVALUE(K3:K2000)

Where K2000 would need to be changed to be large enough to cover the entire range of the data. This will then give you the value you want in all the cells in column L. You can then use this to adjust the values, or find, the other values you need to adjust the other lines.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing