Login Page - Create Account

Support Board


Date/Time: Thu, 28 Nov 2024 08:32:07 +0000



a spreadsheet for a list of stocks

View Count: 475

[2023-05-13 18:24:37]
User409050 - Posts: 22
Hi SC,

I want to create a spreadsheet to track a list of stocks that I am monitoring. The spreadsheet should include columns for daily, weekly, and monthly performance, as well as volatility, in the future, I plan to add additional statistics such as 52-week high and low and some other statistics. After reviewing the documentation, I see that I have two options:

Open multiple charts and add a spreadsheet study to each, although this is not recommended by SC.
Open one chart and add an "additional symbol info" study for each of the stocks, although this process can be cumbersome and slow.
Are there any other ways to create this spreadsheet that would be more efficient?
[2023-05-14 06:23:06]
User800326 - Posts: 2
Hello, new user here. I am looking to find the same answer. I hope some guru of this forum will help us.
[2023-05-15 14:41:16]
John - SC Support - Posts: 36350
Take a look at the Quote Spreadsheet and see if this will do what you want:
Getting Quotes: Quotes on Spreadsheets
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-05-15 18:30:30]
User800326 - Posts: 2
Thanks for the reply. I think that OP and myself are trying to use Quote on Spreadsheet with additional data (eg. 52-week high) with respect to the standard fields.

OP says

After reviewing the documentation, I see that I have two options:

Open multiple charts and add a spreadsheet study to each, although this is not recommended by SC.
Open one chart and add an "additional symbol info" study for each of the stocks, although this process can be cumbersome and slow.
Are there any other ways to create this spreadsheet that would be more efficient?

I agree with OP not having myself found any way to add studies' values to multiple symbols in the Quote on Spreadsheet (or, alternatively, in a Spreadsheet) in a flexible and simple way.
[2023-05-16 09:37:30]
Sierra_Chart Engineering - Posts: 17200
Also have a look at the Study Summary:
Study Summary Window
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

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

Login Page - Create Account