Yahoo terminated the finance service API - Stock Quote Add-In not working
November 2, 2017
Stock Quote Add-In, Excel, Office Development
The Stock Quote add-in is using the Yahoo Finance service API to retrieve the stock quotes. The service seems to be terminated by Yahoo without any notice on 11/01/2017. I will try to find an alternative solution as soon as possible, but I’m not sure how long it will take. You may check out this blog or the GitHub project site from time to time for a new version to download.