Can SC spreadsheets be linked to external ones or language scripts via COM, RTD?

September 7th, 2017, 11:54 AM

Hello fellas, 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?

This way, hopefully, I can connect Rithmic to SC and just worry about the strategies, reporting, portfolio scripts, instead of all the plumbing and core infrastructure where getting from C++ to Python would be concerned.

September 21st, 2017, 05:39 AM

Hi,
Sierra can interacts with exel directly: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html.
SC not uses COM or RTD, but i think a better way: https://www.codeproject.com/Articles/13852/BasicExcel-A-Class-to-Read-and-Write-to-Microsoft, imho.

October 4th, 2017, 01:49 PM

ludvig

Hi,
Sierra can interacts with exel directly: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html.
SC not uses COM or RTD, but i think a better way: https://www.codeproject.com/Articles/13852/BasicExcel-A-Class-to-Read-and-Write-to-Microsoft, imho.

Thank you, ludvig!

Can SC spreadsheets be linked to external ones or language scripts via COM, RTD?

Discussion in Sierra Chart

Can SC spreadsheets be linked to external ones or language scripts via COM, RTD?