Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 21:50:16 +0000



Reading values from Excel into Sierra Charts

View Count: 1491

[2013-12-29 07:35:39]
Nestor Dominguez - Posts: 2
Hello,
I was wondering if you could help me do the following:

I have some calculated values stored in Excel (for example VAH, POC, and VAL - as well as others) and I would like to have the ability to retrieve the specified values from my excel spreadsheet and plot each of them on a chart as a continuous horizontal line. Can this be done by using your Spreadsheet tool? If not, is there a way to accomplish this task without creating a customized '3rd-party" indicator?

Your response will be deeply appreciated.

thanks
Nestor

[2013-12-29 07:40:32]
Sierra Chart Engineering - Posts: 104368
Yes this can be done by using the Spreadsheet Study and setting it to Use Excel. Refer to Spreadsheets in the documentation:
http://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudy.html

However, it is strongly preferred that you read this data from the built-in Sierra Chart spreadsheets, for reliability. So if you are able to enter this data or calculate this data using Sierra Chart spreadsheets that would be better.
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: 2013-12-29 07:40:56

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

Login

Login Page - Create Account