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

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 can use Yahoo Finance or MSN Money data providers instead.

See:

Disclaimer

Google Finance is a logo and registered trademark of Google Inc.

Microsoft Excel is a logo and registered trademark of Microsoft Corporation.