Google Sheets

[Robandcindy2]

(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ʺ))

Caversham,
Are you using the iferror function in each cell?

Anyway, I've got the messed up cells (y, D, r1) working again but it's still locked up in places and s---l---o---w.......

I'll keep plugging away.   Thanks!
Rob