Support Board
Date/Time: Wed, 15 Jan 2025 19:54:08 +0000
Can SC spreadsheets be linked to Excel or language scripts via COM, RTD?
View Count: 2483
| [2017-09-07 15:52:07] |
| ChadB - Posts: 2 |
|
Hello, I am considering purchase of SC and would like to know if, for sake of extending options for automation of trading, the spreadsheet component within SC can be linked to Excel, or better yet, directly to a programming language like Python? I have read that SC uses the DTC protocol and this is where all roads lead in searching so far. But, here's an example workflow which I have going: With Rithmic's R|Trader Pro, the user can both stream market data into, and send orders from, Excel via a COM interface (faster/more stable than RTD). Using the 'xlwings' or 'xlrtd' package, I can interact with the Excel workbook connected to R|T Pro, with Python scripts...so, I am looking for a similar angle to this, in SC. Possible? |
| [2017-09-07 18:05:21] |
| |
|
the spreadsheet component within SC can be linked to Excel, or better yet, directly to a programming language like Python? No, this is not supported in this way.We recommend using the DTC protocol server which supports Python through Google protocol buffers: Data and Trading Communications (DTC) Protocol Server Or using the Sierra Chart built-in spreadsheet functionality: Spreadsheet Systems, Alerts and Automated Trading Or using ACSIL: Advanced Custom Study Interface and Language (ACSIL) All of these alternatives are a very very solid solution and recommended. 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-09-07 18:05:37
|
| [2017-09-07 18:51:44] |
| ChadB - Posts: 2 |
|
Ok, thank you for this detail. On a tangential matter, is this the full list of available functions that can be used in an automated strategy from the built-in spreadsheets? Spreadsheet Functions: Available Functions So if I wanted to do some fancy try at machine learning, it would have to be broken down into constituent operators, hopefully all being found among this list of available functions? |
| [2017-09-07 19:26:31] |
| |
|
Yes, and you really should not need more functions than that since all of the basic functionality is provided. But if there is a particular basic function you need which is not already provided, we will see about adding 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: