Google Sheets

Hello There, Guest! Register

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Google Sheets

Caversham Offline

Offline

Member

Posts: 89
Threads: 5
Joined: Apr 2015
Reputation: 2

#5

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

Find

Reply

« Next Oldest | Next Newest »

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: 2 Guest(s)