stream live option price and volume to excel

[Dcai88]

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

 

[Option-Guru]

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]

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!

 

[Option-Guru]

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

I use TOS too - isn't the feature you are talking about static data?

 

[HowardCohodas]

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.

 

[Marcia5435]

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.