Yahoo Finance no longer working in Excel!
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!
Disclaimer
This is not financial advice. Our content is intended to be used and must be used for information and education purposes only. Please read our disclaimer and terms and conditions to understand our obligations.
3 comments
Yes, I had the same problem but I'm now up and running using an alternative. See the discussion here: https://www.lemonfool.co.uk/vi...
All the best, Si
That's very useful Si as I, too, suffered over the weekend from Yahoo abruptly terminating their service. As as stop-gap I knocked up a scraper to aggregate share prices from shareprices.com but being able to pick up an add-in is great news.
Damian
Fantastic, many thanks
I will take a look