Best streaming bid/ask price for streaming into excel

A

alphahunter

Not sure the best area to ask this questions. I am looking to stream bid/asks in real time directly into excel cells (without having to refresh them manually) mostly for stocks and etfs, but futures would be handy too.

What is the best/reasonable setup to do this without programming, I do currently already pay for many of these feeds through IB, but haven't attempted to set this up through the API yet, but I though it required manually refreshes? any other suggestions?
 
I think that that's what IB Excel example included with IB's API is designed to do, so just open their Excel and use it. I didn't see any programming needed, just opened their Excel file and it updates quotes real-time.
You may also be able to create some formula to update different Excel file, or additional worksheets, etc.

https://interactivebrokers.github.io/tws-api/dde_realtime_tutorial.html
upload_2020-1-23_19-40-47.png
 
If you have windows based machine and a TOS (TDA) account... You can use RTD to stream at whatever rate you desire (unattended and without programming). There is no fee, and the qty of references is practically unbounded (begin to tax excel, and TOS once you try more than 20,000 or so at a time)! Some countries in Europe, and down under may not be allowed by TDA.
 

Attachments

Easy
We show how to do with R Trader by Rithmic
 
You must log in or register to reply here.
Back
Top