Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Google Sheets
#5
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ʺ))
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: 5 Guest(s)