Excel VBA script for option chain data from CBOE

(Last Updated On: April 2, 2015)

Excel VBA script for option chain data from CBOE

It seems the Yahoo Finance Chain Data scripts from Matlab no longer work as in the last few months. Most option data can be downloaded from CBOE so I am hoping this Excel VBA still works.


Also read the description in the video for proper links

(This appears to not work with some subscript out of range error)

Here is the latest update for Yahoo Finance after their change: http://www.reddit.com/r/algotrading/comments/2kq0qz/has_anyone_here_used_yql_to_download_yahoos/

Join my FREE newsletter to see what still works 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
share this recipe:

Still hungry? Here’s more

Are you interested in:


FREE 2 Hour Video! 


As you know with the crazy restrictive emergency laws being introduced in the last week, many moving their savings out of FIAT banks into cryptocurrency trading.

Here are some questions to get your started:

  • Create your own ‘bank’ anonymously with crypto
  • In the future, draw off your crypto saving with a Visa debit card
  • Trade using a European de-central exchange to trade perpetual contracts and other high performing coins
(All your info is kept private nor released!  Don’t forget to check to click your promo or spam inbox after the confirmation email is sent) 

Create your own  PRIVATE Bank