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

Automated Bots: Your Key to Stock Trading Success

Automated bots are rapidly gaining ground in the stock market, and if you’re still trading manually, the box will outrun you. Yes, you heard it right! These powerful bots are set to become the new norm, and those who embrace them will have a significant advantage over those who don’t.

Read More

Are you interested in: