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,889 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?
CFTC Requests Tag 50 Trader Identity Data From CME and I …
Traders Hideout
Iran Fired a Missile at Israel Last Night. The $8M June …
Prediction Markets & Event Contracts
Six Days to Kickoff: World Cup Prediction Markets Hit $1 …
Prediction Markets & Event Contracts
Saylors 41-Month HODL Breaks: Strategy Sells 32 BTC as $ …
Prediction Markets & Event Contracts
Trump Lands in Beijing on CPI Day: Iran Peace Expires To …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Big Mike in Ecuador
205 thanks
Sober Journey With S&P
21 thanks
30 Sessions
20 thanks
Volume Indicators
8 thanks
Thanks Mike. Godspeed.
7 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