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:
- KB: How to Load Option Chains from Yahoo Finance to Microsoft Excel
- KB: How to Load Option Chains from MSN Money to Microsoft Excel
Disclaimer
Google Finance is a logo and registered trademark of Google Inc.
Microsoft Excel is a logo and registered trademark of Microsoft Corporation.