Knowledge Base | How to Load Option Chains from Google Finance to Excel

Overview

Google Finance publishes US stock option chains at their website and has no download links.

However, Google Finance has an undocumented web service that returns option chains in JSON using URLs like these:

https://www.google.com/finance/option_chain?q=GOOGL&output=json

https://www.google.com/finance/option_chain?q=GOOGL&output=json&expd=19&expm=01&expy=2018

Last time Google Finance has a strange set of expiration dates.

So, we have removed option data providers for Google Finance in our products.

You may use Yahoo Finance or MSN Money data providers instead.

See: