Menu
Can anyone provide how to get historical options data with strikes by Google Finance API? Mbe Yahoo API can do it? Thx.
208
Historical Prices at Google Finance You can open https://www.google.com/finance/, search a ticker like GOOGL, and click the 'Historical prices' link on the left panel. You can use URLs like https://www.google.com/finance//historical?q=GOOGL to open pages with historical prices directly.
To reiterate, the Google Finance API is no longer supported by Google so it's undocumented and unreliable. Therefore, this API is best for private toy applications. Public resources, such as RapidAPI, are a good place to learn about well maintained and available APIs.
Use the GOOGLEFINANCE function A ticker symbol in quotation marks. (Optional) The attribute you want to show, such as price, in quotation marks. (Optional) A start and an end date preceded by DATE and followed with the numerical date in parenthesis. (Optional) Daily or weekly frequency in quotation marks.
(Indeed the IPO was in 1999.) However, Google Finance only goes back to Jan. 17.
AFAIK, there's no free API that lets you query for historical option prices easily.
Your best shot may be to collect it daily for the stocks you're interested in: http://www.google.com/finance/option_chain?q=AAPL&output=json
94
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
