Home >> Support Board

Support Board

Date/Time: Tue, 26 Nov 2024 17:34:10 +0000

How to Post a Message for Support

[User Discussion] - Get Value of Overlay SingleLine in Spreadsheet

View Count: 389

[2023-10-16 11:39:32] #1 [Go To First Post]
Bartezz - Posts: 18
Hi Team, how can i get value from overlayed SingleLine in Spreadsheet (see Screenshot) Regards


corr.png / V - Attached On 2023-10-16 11:39:14 UTC - Size: 12.52 KB - 94 views

[2023-10-16 15:55:03] #2 [Go To First Post]
John - SC Support - Posts: 36300
In general, study results are displayed in the Spreadsheet Study starting at column AA. Refer to the following: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2023-10-17 07:07:13] #3 [Go To First Post]
Bartezz - Posts: 18
Yes thats right, but on Spredsheet Study I can see only the Price of this Instrument (See Attachment) and not the Price of Chart


corre-study.png / V - Attached On 2023-10-17 07:07:03 UTC - Size: 18.8 KB - 83 views

[2023-10-17 17:38:41] #4 [Go To First Post]
John - SC Support - Posts: 36300
If you are wanting to see the full OHLC values, then you would have to overlay them from another chart to this chart, or use the "Add Additional Symbol" study. Right now, it sounds like you are overlaying just the Last price from another chart, which is why you only have the 1 price in the Spreadsheet study. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2023-10-18 10:01:23] #5 [Go To First Post]
Bartezz - Posts: 18
Hi John, no I don't want to see all OHLC Values, i woul like to Compare SingleLines of different Instruments. For Example: ( SingleLine ES is closed greather then SingleLine NQ). Have you an Idea how I can solve this? Regards

[2023-10-18 15:01:32] #6 [Go To First Post]
John - SC Support - Posts: 36300
We are really not understanding your issue. If you are wanting to compare the information for the single lines, then you have this data in the spreadsheet study. Please give us more information on exactly what you want to accomplish. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2023-10-27 16:57:26] #7 [Go To First Post]
Bartezz - Posts: 18
I would like to compare which line is higher or lower then ES Line (Green), but in Spreadsheet i can see only current Instrument-Price, so i cannot compare ES- 4059 Price with NQ 13576 Price, for comparation i need the line-Prices from chart. As you can see in Attachment YM (yellow) is about 4501, NQ(Ping) is about 4495,75 and RUS and ES (Green and orange) is about 4482.75. But i can see it only on chart and not in spreadsheet.


corr-question.png / V - Attached On 2023-10-27 16:57:14 UTC - Size: 53.19 KB - 79 views

[2023-10-27 17:25:02] #8 [Go To First Post]
John - SC Support - Posts: 36300
The prices you are viewing on the chart are not the prices of those instruments. The yellow line (YM), for example, does not have a price around 4501.00. The instruments on that chart that are not the main one (ES) are independent scaling. What is shown in the Spreadsheet is the correct value for those instruments. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2023-10-27 17:28:52] #9 [Go To First Post]
Bartezz - Posts: 18
I know, but it is possible to get this prices from the chart or did you know another way to compare which line is higher or lower from another line?

[2023-10-27 18:18:39] #10 [Go To First Post]
John - SC Support - Posts: 36300
There is not a way to do this unless you specifically tie the data together at some point by actually adjusting it. Refer to the Arithmetic studies at the following link: Using the Basic Arithmetic Studies For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing

[2023-10-27 19:23:19] #11 [Go To First Post]
Sawtooth - Posts: 4120
i can see it only on chart and not in spreadsheet. The Overlay (Single Line) study defaults to Scale >> Independent, so its line will not appear on the chart at the price of the destination chart. But it's price in the spreadsheet output will be accurate. This study is intended to be used in a Chart Region other than Region 1. If you put it in Region 1 with Independent scaling, you can make no comparisons between it and the price of other symbols.

[2023-11-05 16:58:21] #12 [Go To First Post]
Bartezz - Posts: 18
Is there maybe a way to solve it with ACSIL Code?

[2023-11-05 18:57:52] #13 [Go To First Post]
Sawtooth - Posts: 4120
Is there maybe a way to solve it with ACSIL Code? You cannot put more than one symbol in the same Chart Region and then expect to be able to compare whether one closed higher than another. To even be able to place them in the same region you must choose the Independent scale, which then removes any correlation between them. If you want to compare their percentage change since the Open, then those lines would be in the same region, but this is not a comparison of prices.

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