stream live option price and volume to excel

This is a discussion on stream live option price and volume to excel within the Futures & Options forums, part of the Markets category; does anyone know how to stream live option price and volume to excel? Do I need to buy a software ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Oct 2, 2010, 10:18pm   #1
 
1 Posts
Joined Oct 2010
stream live option price and volume to excel

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
Dcai88 is offline   Reply With Quote
Old Oct 26, 2010, 1:43am   #2
 
3 Posts
Joined Oct 2010
Re: stream live option price and volume to excel

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
Option-Guru is offline   Reply With Quote
Old Oct 26, 2010, 4:17am   #3
 
HowardCohodas's Avatar
Joined Sep 2010
Re: stream live option price and volume to excel

Quote:
Originally Posted by Dcai88 View Post
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 is offline Other (Please email T2W with details)   Reply With Quote
Old Oct 27, 2010, 1:53am   #4
 
3 Posts
Joined Oct 2010
Re: stream live option price and volume to excel

Quote:
Originally Posted by HowardCohodas View Post
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?
Option-Guru is offline   Reply With Quote
Old Oct 27, 2010, 2:41am   #5
 
HowardCohodas's Avatar
Joined Sep 2010
Re: stream live option price and volume to excel

Quote:
Originally Posted by Option-Guru View Post
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.
HowardCohodas is offline Other (Please email T2W with details)   Reply With Quote
Old Dec 10, 2017, 11:20pm   #6
 
1 Posts
Joined Dec 2017
stream live option price and volume to excel

Quote:
Originally Posted by Dcai88 View Post
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.
Marcia5435 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
excel spreadsheet that use macros to download stock price hanhao Trading Software 3 Jan 4, 2009 4:18pm
Price vs Time & Price vs Volume Charts Jaydee Technical Analysis 6 Oct 8, 2008 9:00pm
Option volume as an indicator n6394p Technical Analysis 3 Jan 22, 2006 7:59pm
live price in excel cell rdstagg Techies Corner 17 Aug 2, 2004 8:12am

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)