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!

Subscribe For Latest Updates

Sign up to best of business news, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.


Check NEW site on stock forex and ETF analysis and automation

Scroll to Top