04-03-2016, 09:56 AM
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ʺ))
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ʺ))