Load all options data of a stock into Excel

[nonprophet]

Quote from markg_ny:

To get the bulk data http://www.historicaloptiondata.com – did not try but unbeatable prices.

Unbeatable? They charge $745 for five years historical, stricknet charges $147 for that.

If you don’t mind missing some data then at tbsp download it all @ $65 ($25 registration + 1 month @ $40).

$65 or $147 instead of $745. What-are-they-thinking?

Edit: strick lacks index options, has to be said.

 

[markg_ny]

Too late to edit my post.
I am a ‘free stuff’ type of amateur options trader/analyst and <b>I should not post a comment “unbeatable prices” with a link to a site</b>
(I mentioned I do not use) that is less expensive than some other sites but clearly not with the “unbeatable prices”.
Should limit myself to comment about what I know and used in practice.

 

[Euler]

One word of warning on historical options data: beware misstated options contract specifications. Even the OCC itself often seems to disseminate incorrect data, especially with respect to strikes.

 

[dmo]

The Hoadley software makes it quite easy to stream quotes into Excel, and works with some brokerages such as IB to grab real-time data if you have an account with them. I don't know if it's possible to get historical data though.