I have been using Yahoo Finance to extract live stock prices and other data into excel.
E.g. using this type of function:
=WEBSERVICE("http://uk.finance.yahoo.com/d/quotes.csv?s="&$B5&"&f=b")

A couple of days ago the service suddenly stopped working. I understand this is due to it being used in violation of the Yahoo Terms of Service:
https://forums.yahoo.net/t5/Known-issues-and-updates/Known-Issue-Finance-download-errors/td-p/387511

Has anyone else experienced the same problem? If so, do you have a work around?

Any help much appreciated!

Unlock the rest of this article with a 14 day trial

Already have an account?
Login here