05-19-2016, 06:29 AM
(04-03-2016, 09:56 AM)Caversham Wrote: Thanks for the links Robandcindy2. From those links and little searching I managed to get my Yahoo Finance ImportData functions working again.
I just changed the Yahoo finance URL:
http://finance.yahoo.com… CHANGE TO THIS ... http://download.finance.yahoo.com
For example, to retrieve price:
OLD:
=iferror(ImportData(ʺhttp://finance.yahoo.com/d/quotes.csv?s=ʺ&B4&ʺ&f=pʺ))
NEW:
=iferror(ImportData(ʺhttp://download.finance.yahoo.com/d/quotes.csv?s=ʺ&B4&ʺ&f=pʺ))
Is your sheet still working? Mine have stopped for almost two weeks now. About had it with the Almighty Google. I keep filling trouble reports asking them to just add Yield and Dividend to the available Google Finance Stock Attributes ... Oye!
There are people who use up their entire lives making money so they can enjoy the lives they have entirely used up
Frederick Buechner
Frederick Buechner