Support Board
Date/Time: Sat, 18 Jan 2025 10:47:16 +0000
excel connect
View Count: 1615
| [2018-02-05 11:27:04] |
| User00111 - Posts: 111 |
|
I'd like to know if I can connect my excel application to data through Sierra ? Is it necessary to write an application(bridge)through visual studio ? |
| [2018-02-05 18:26:09] |
| |
|
Did you want to access chart bar data or just the real-time data, in Excel?
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 |
| [2018-02-05 20:01:58] |
| User00111 - Posts: 111 |
|
No real-time. I try to explain... In my excel application I dowload historical data(Open/High/Low/Close/Volume) I do not care real time. How to connect an excel macro so that historical data can be acquired automatically. I would like to create a bridge between the two systems. I have confidence with C ++ and Visual Studio, but I do not know where to start |
Excel.png| [2018-02-07 14:44:27] |
| User00111 - Posts: 111 |
|
No real-time. I try to explain... In my excel application I dowload historical data(Open/High/Low/Close/Volume) I do not care real time. How to connect an excel macro so that historical data can be acquired automatically. I would like to create a bridge between the two systems. I have confidence with C ++ and Visual Studio, but I do not know where to start |
| [2018-02-07 18:31:55] |
| |
|
It would be best that you use ACSIL to access this data and determine a way to use it in Excel. Refer to: Advanced Custom Study Interface and Language (ACSIL) Sierra Chart does have the ability to send directly to Excel but we do not recommend using that: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#UseExcel You are going to be better off developing your own custom interface to accomplish just what you need. 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 |
| [2018-02-07 18:46:27] |
| |
|
The other possibility is you can use this particular study: Write Bar Data to File And open the file in Excel and have Excel periodically read from it. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: