Login Page - Create Account

Support Board


Date/Time: Wed, 15 Jan 2025 16:17:07 +0000



Chart from Spreadsheet

View Count: 768

[2017-07-11 19:32:00]
User103861 - Posts: 42
I have some custom data that I would like to chart from a spreadsheet I have set up in SC. I basically have a few months of data that include columns for "Date" and "Last". I have been unable to find documentation on how to chart this data in SC, ideally turning them into indicators. Please point me to the appropriate documentation to do this. Thanks in advance.
[2017-07-11 20:01:18]
Sierra Chart Engineering - Posts: 104368
There are two methods to do this.

You could use the Spreadsheet Study:
Using the Spreadsheet Study

If so, you would need to use this method explained here:
Spreadsheet Studies Special Tasks: Using Different Formulas or Data at Each Row of the Formula Columns (K-Z)

Or you could just simply open that data as a text file. Refer to:

Text/CSV Data Format
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2017-07-11 20:01:29
[2017-07-12 01:07:24]
User103861 - Posts: 42
Thank you. If I use a CSV file in your second simpler suggestion, can I have multiple sheets for different studies, or would it have to be done in multiple CSV files?
[2017-07-12 02:31:57]
Sierra Chart Engineering - Posts: 104368
Not sure what you mean by "multiple sheets for different studies"?

There is no association between a Spreadsheet Sheet and a text chart data file.
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, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2017-07-12 02:32:05

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

Login

Login Page - Create Account