Login Page - Create Account

Support Board


Date/Time: Sat, 18 May 2024 12:03:33 +0000



Data connection to Tableau or excel

View Count: 639

[2021-09-08 18:53:03]
DayTraderEsad - Posts: 116
Is it possible to connect a excel spreadsheet or any third party service such as Tableau to Sierra Charts. Looking to download the trades data from the activity log live vs having to pull them daily?
[2021-09-09 16:13:06]
John - SC Support - Posts: 31704
There is not a built-in way to do this. And since you are looking for the Trade data, there is not any automated method to output the data to a file.

You can always create a program to do it using ACSIL, if you want. Refer to the following:
Advanced Custom Study Interface and Language (ACSIL): Introduction
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-10-22 02:53:44]
DayTraderEsad - Posts: 116
Would you by any chance have some documentation or examples on how to connected to the TradeAccountData to I can pull it to a CSV file? I have been searching online for weeks and can't find anything besides documentation for building studies.
[2021-10-22 15:28:52]
John - SC Support - Posts: 31704
Refer to the following for information on the ACSIL functions for accessing trades:
Automated Trading From an Advanced Custom Study: sc.GetTradeListEntry()

Be sure to look through the rest of the information on that page for other items that may be useful to you.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-10-22 15:41:03]
DayTraderEsad - Posts: 116
That is to pull per chart, is there a way to pull per account. Since I have 10 accounts, is it possible to pull it someone per each account all at one, no matter the chart?
[2021-10-22 21:45:56]
Sierra_Chart Engineering - Posts: 14423
No, this is not supported using ACSIL.
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