NexusFi: Find Your Edge


Home Menu

 





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


Discussion in Sierra Chart

Updated
    1. trending_up 1,972 views
    2. thumb_up 2 thanks given
    3. group 2 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 ClutchAce 
Cookeville, TN
 
Experience: Advanced
Platform: Sierra Chart, IB, Python
Trading: NQ, DAX, TOPIX
Frequency: Daily
Duration: Hours
Posts: 71 since Oct 2011
Thanks Given: 18
Thanks Received: 21

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.


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
CME Launches Bitcoin Volatility Futures June 1 -- First …
Cryptocurrency
Kalshi Sets $4.13B All-Time Weekly Record as Polymarket …
Prediction Markets & Event Contracts
More Than Capable: Hegseths War Warning Validates $114M …
Prediction Markets & Event Contracts
The June 15 Resolution Trap: Irans Agreed Text Still Pri …
Prediction Markets & Event Contracts
Trump Truth Social Fires Hormuz From 10% to 59% -- Arsen …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
15 thanks
Darmok and Jalad at Tanagra
3 thanks
Big Mike in Ecuador
1 thanks
30 Sessions
1 thanks
  #2 (permalink)
ludvig
russia kaliningrad
 
Posts: 19 since Jan 2011
Thanks Given: 0
Thanks Received: 21

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.


Reply With Quote
Thanked by:
  #3 (permalink)
 ClutchAce 
Cookeville, TN
 
Experience: Advanced
Platform: Sierra Chart, IB, Python
Trading: NQ, DAX, TOPIX
Frequency: Daily
Duration: Hours
Posts: 71 since Oct 2011
Thanks Given: 18
Thanks Received: 21



ludvig View Post

Thank you, ludvig!


Started this thread Reply With Quote




Last Updated on October 4, 2017


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts