Login Page - Create Account

Support Board


Date/Time: Sun, 28 Apr 2024 08:43:53 +0000



Data into Excel

View Count: 2603

[2014-07-15 17:10:58]
User62351 - Posts: 3
I need to have live data for a symbol go into an excel sheet. I need this in an external excel sheet using EXCEL not the built in sheets in Sierra. How do I do this? Usually in other programs there is a DDE link.

Thanks.
[2014-07-15 18:21:42]
Sierra Chart Engineering - Posts: 104368
This can be done using the Spreadsheet study:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html

You need to use the Use Excel input:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#UseExcel
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: 2014-07-15 18:22:25
[2014-07-16 17:43:52]
User62351 - Posts: 3
There is no option on the Global settings>Spreadsheet settings to use excel.
as this link describes.


imageexcel sierra.png / V - Attached On 2014-07-16 17:43:17 UTC - Size: 21.02 KB - 441 views
[2014-07-16 17:46:41]
Sierra Chart Engineering - Posts: 104368
Use Excel is a study input. For instructions to access study inputs, refer to:
https://www.sierrachart.com/index.php?page=doc/doc_ChartStudies.html#AddingModifyingStudies
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
[2014-07-16 18:15:40]
User62351 - Posts: 3
I added the current price line study to a chart and I don't see the "Use Excel" study input. Its not there.

Can you please explain how to get the current price for an instrument to go into Excel. This should be a simple thing and not some complicated process. I cant use the built in excel sheet in sierra because I need this data for a large custom excel sheet I have built. All I need is to get current close data to go into excel. simple.
imageexcel sierra1.png / V - Attached On 2014-07-16 18:15:17 UTC - Size: 33.46 KB - 440 views
imageexcel sierra2.png / V - Attached On 2014-07-16 18:15:26 UTC - Size: 59.12 KB - 397 views
[2014-07-16 19:23:42]
Sierra Chart Engineering - Posts: 104368
The way in which this works is through the Spreadsheet study. Here is the documentation for the Spreadsheet study:
https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html

It is the Spreadsheet Study that has the Use Excel input.
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
[2020-02-12 08:58:21]
User719206 - Posts: 92
i spend my morning to try to find the way to open a study in excell but it was a fail , where is this excell input ?? Impossible to find him

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

Login

Login Page - Create Account