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



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


Discussion in Sierra Chart

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




Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

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

(login for full post details)
  #1 (permalink)
ClutchAce
Cookeville, TN
 
 
Posts: 58 since Oct 2011
Thanks: 15 given, 17 received

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.

Reply With Quote

Journal Challenge April 2021 results (now extended!):
Competing for $1800 in prizes from Jigsaw
looks_oneMaking a Living with the Microsby sstheo
(82 thanks from 10 posts)
looks_twoDeetee’s DAX Trading Journal (time based)by Deetee
(25 thanks from 9 posts)
looks_3Salao's Journalby Salao
(23 thanks from 6 posts)
looks_4Learning to Profit - A journey in algorithms and optionsby Syntax
(12 thanks from 7 posts)
looks_5Maybe a little bit different journalby Malykubo
(5 thanks from 2 posts)
 
Best Threads (Most Thanked)
in the last 7 days on futures io
futures io site changelog and issues/problem reporting
73 thanks
The Crude Dude Oil Trading System
73 thanks
Would You Sell Your System?
71 thanks
FIO Journal Challenge - April 2021 w/Jigsaw Trading
32 thanks
Big Mike in Ecuador
25 thanks
 
(login for full post details)
  #2 (permalink)
ludvig
russia kaliningrad
 
 
Posts: 19 since Jan 2011
Thanks: 0 given, 21 received

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
The following 2 users say Thank You to ludvig for this post:
 
(login for full post details)
  #3 (permalink)
ClutchAce
Cookeville, TN
 
 
Posts: 58 since Oct 2011
Thanks: 15 given, 17 received



ludvig View Post

Thank you, ludvig!

Reply With Quote


futures io Trading Community Platforms and Indicators Sierra Chart > Can SC spreadsheets be linked to external ones or language scripts via COM, RTD?


Last Updated on October 4, 2017


Upcoming Webinars and Events
 

NinjaTrader Indicator Challenge!

Ongoing
 

Journal Challenge w/$1,800 in prizes!

April
 

Seven Trading Mistakes Solved With Smart Trading Tools w/Brannigan Barrett

Elite only
     



Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts