Download Finance Yahoo Com Api

And Google both unofficially provide a free way to download stock quotes using an API. Finance Financial data can be downloaded in a CSV, imported into an existing Excel Spreadsheet, or downloaded in XML / JSON formatted data to display on a website using the Yahoo! Query Language (YQL) API. Google Finance.

Requesting data from Yahoo Finance seems to have changed or is now blocked. The request below for commodity data no longer works as of May 2017. Does anyone know if there is a new way to make this request?

homebasehomebase

3 Answers

First, the old Yahoo finance iChart download is gone for good. In one of the forum posts, a Yahoo employee has confirmed that the free EOD data has been terminated, and will not be reintroduced. Check out this thread and look for reply from Nixon. Yahoo is recently acquired by Verizon, and it must be the new direction.

Download

However, if you check the Yahoo financial page, the CSV download link works, though differently now. It is through a new API that uses an authentication token 'crumb' that is linked to a cookie when you access the page.

So there is a work-around to get the same CSV download as before through this new API. I have put together some quick Python3 code. Please check out GitHub for source code yahoo_quote_download.

c0redumbc0redumb

As Ashley Davis mentioned in the comments section of the question above, the new way to go is through Alpha Vantage, at least when one is looking for free historical data. Their web service is very well documented and straight forward.

For those of you who are looking to import the data into Excel, I have written an api that I make available for free. Here is the Excel spreadsheet

Addendum as of Aug 2018: Current version of Deriscope supports retrieval of both historical data and live feeds from YF.

YannisYannis

Yahoo Finance Rest Api

For Australian investors, here is an alternative to yahoo finance api:

www.biglion.com.au

Chan AustinChan Austin
Yahoo finance api documentation

Yahoo Finance Api Excel

protected by CommunityJun 6 '17 at 18:40

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Download Finance Yahoo Quotes

Not the answer you're looking for? Browse other questions tagged yahoo-finance or ask your own question.