Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Google Sheets
#7
(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
There are people who use up their entire lives making money so they can enjoy the lives they have entirely used up
Frederick Buechner
Reply


Messages In This Thread
Google Sheets - by Robandcindy2 - 04-02-2016, 12:59 PM
RE: Google Sheets - by Caversham - 04-03-2016, 09:01 AM
RE: Google Sheets - by Robandcindy2 - 04-03-2016, 09:20 AM
RE: Google Sheets - by Robandcindy2 - 04-03-2016, 09:22 AM
RE: Google Sheets - by Caversham - 04-03-2016, 09:56 AM
RE: Google Sheets - by Robandcindy2 - 04-04-2016, 12:06 PM
RE: Google Sheets - by Robandcindy2 - 05-19-2016, 06:29 AM
RE: Google Sheets - by Caversham - 05-19-2016, 08:58 PM
RE: Google Sheets - by Robandcindy2 - 05-24-2016, 07:04 AM
RE: Google Sheets - by Robandcindy2 - 04-04-2016, 10:35 AM
RE: Google Sheets - by Robandcindy2 - 04-20-2016, 10:46 AM
RE: Google Sheets - by Robandcindy2 - 05-11-2016, 01:20 PM
RE: Google Sheets - by Robandcindy2 - 05-13-2016, 12:02 PM
RE: Google Sheets - by Robandcindy2 - 06-03-2016, 03:41 PM
RE: Google Sheets - by Jason - 06-12-2016, 05:48 PM



Users browsing this thread: 1 Guest(s)