Support Board
Date/Time: Thu, 21 Nov 2024 20:46:00 +0000
[Programming Help] - Composite Symbols Same Origin Point
View Count: 423
[2023-05-15 11:39:30] |
user_xyz - Posts: 416 |
How can I get the same origin starting point for multiple symbols on a chart? I've tried, all symbols with Line on Close/Open along with percent since open overlay and testing every scale option. I can get 'close' but surely there is something I'm missing. |
[2023-05-15 15:20:23] |
John - SC Support - Posts: 36198 |
We are not sure exactly what you are wanting to do, or what is not working, but if you use the "Add Additional Symbol" study for the other symbols, then they all should have the same starting point. Just keep in mind with the "Add Additional Symbol" that these symbols do not support the "Continuous Futures Contract" so you can not go back further than the current contract for your main symbol.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2023-05-15 22:12:12] |
user_xyz - Posts: 416 |
See attached. The origin of all added symbols have a different starting location on the Y axis. As mentioned above they are 'close' but how can I get everything to precisely start at 0, same origin.
|
Private File |
[2023-05-16 13:53:06] |
John - SC Support - Posts: 36198 |
What study are you using to get those percentages?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2023-05-16 14:01:06] |
user_xyz - Posts: 416 |
Percent change since open per other SC threads. But this also applies to other symbols not using percent change. Surely there has to be a way to chart/compare multiple symbols from a single pinpoint origin.
|
[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 |
[2023-05-27 18:08:46] |
user_xyz - Posts: 416 |
John - thanks I spent a few hours on this and honestly seems way over complicated for what I'm trying to do. The real issue comes when I want to change the origin DATE I will need to adjust the starting point calculations in the spreadsheet every time for every symbol. Has to be an easier way... Forget the percent change for the moment. I want a chart to compare x number of symbols eg., aapl, msft, nvda, amzn, xlk from an adjustable date, YTD, MTD, Past 5 Years etc all from a single point of origin. I can't get the single point of origin adjusting the scale settings. |
[2023-05-30 13:58:07] |
John - SC Support - Posts: 36198 |
These all have different prices, so you would have to go through the same concept as what we gave previously.
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: