stream live option price and volume to excel

Oct 2, 2010
1
0
#1
does anyone know how to stream live option price and volume to excel?
Do I need to buy a software or does any broker provide this service?

Thanks,

David
 
Oct 25, 2010
3
0
#2
I know for sure that Interactive Brokers has an API for Excel. Although I haven't checked, I believe that Think or Swim does too.

I made a video on using the IB Excel adapter:

Jeff
 

HowardCohodas

Experienced member
Sep 29, 2010
1,868
97
#3
does anyone know how to stream live option price and volume to excel?
Do I need to buy a software or does any broker provide this service?

Thanks,

David
I use the ThinkOrSwim desktop platform. They have an "export to Excell" menu item. Click it and paste it into Excell and Wallah!
 

HowardCohodas

Experienced member
Sep 29, 2010
1,868
97
#5
I use TOS too - isn't the feature you are talking about static data?
It's dynamic as long as the TOS platform and your spreadsheet is active. It's a wonderful asset as I created a custom "Decision Support Dashboard" in Excel. The Dashboard contains all the data and analysis and alarms required to make decisions all in one small panel.

When you reload your spreadsheet, you must manually choose to reactivate the link. After that you are good to go.
 
Dec 10, 2017
1
0
#6
does anyone know how to stream live option price and volume to excel?
Do I need to buy a software or does any broker provide this service?

Thanks,

David
I recommend MarketXLS.
It cost a little but it will save you time.
They also have costumer support and regular updates to help you. :)