This article was first published in 2018. Our software does not use the deprecated Yahoo Finance API.
History Of The Yahoo Finance API
Yahoo! Finance provides financial news and historical data including stock quotes, press releases and financial reports.
As of November 2nd 2017, the Yahoo! Finance API has been disabled by Verizon, its parent company. Stock information can no longer be pulled by VBA into Excel spreadsheets using the popular Yahoo URL that allowed direct querying for quote data, as was the case for the last 12 years. You can read the official announcement here.
As of November 2nd 2017, the Yahoo! Finance API has been disabled by Verizon, its parent company. Stock information can no longer be pulled by VBA into Excel spreadsheets using the popular Yahoo URL that allowed direct querying for quote data, as was the case for the last 12 years. You can read the official announcement here.
Stock Quotes Using IEX
Luckily, IEX Trading offers a free API, which is built on a proven, high-performance system and drives many of the applications used within IEX.
Like Yahoo's, IEX's API is open (no authentication required) and is URL encoded, but the similarities end here. Most IEX HTTP requests return data in JSON, a format which cannot be readily parsed with VBA.
Like Yahoo's, IEX's API is open (no authentication required) and is URL encoded, but the similarities end here. Most IEX HTTP requests return data in JSON, a format which cannot be readily parsed with VBA.
Download
This data file is updated on a daily basis. The file does not contain macros and is saved in compressed binary OpenXML format. To learn more about binary XLSB files, please click here.
We plan to release more information about each stock e.g. key statistics and summary financial data, so please bookmark this page. We may also release the mathlayer code used to obtain the data sets, once the program is stable.
We plan to release more information about each stock e.g. key statistics and summary financial data, so please bookmark this page. We may also release the mathlayer code used to obtain the data sets, once the program is stable.
For Excel 2007 or later
I want to hear from you. I love hearing feedback and getting ideas for future updates. I look forward to reading your thoughts in the comment section below :)
