Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Google Sheets
#1
Sad 
Well the "ImportData" function at Google Sheets is toast.  Reading various theories as to why.  Some clearing house company not permitting Yahoo data to be imported.

So other than Stock Rover any other solutions?

My issue is the thought process I use to track everything.  First, our shares are in numerous accounts between Fidelity and Vanguard and then between, IRA's, rollovers, 401K's, etc.   Second, I track them as to whether they are "Dividend" or "Growth" and "International"...plus some other breakdowns.  So the Google Sheets and Importing from Yahoo when Google didn't provide the date (dividends, yield, dates, etc) was the perfect solution.  In fact the spreadsheet was humming along perfectly until just the other day.

Mac's don't handle web queries well if at all.  I believe there is harvesting function in Excel (probably calling that wrong).  Something where a cell on one page will search a second page for a value (Stock ID) and return a value for another cell on that second page.  Anyone using this? 

All of this wouldn't be a problem if the "Great and Powerful Google" would add dividend data to Google Finance....
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
#2
I use Yahoo Finance for all of my data and my spreadsheet has been borked for the last week.  I've seen similar, flaky behavior before; so I was hoping this was a temporary issue, but it sounds like that might not be the case.

Is the issue with the ImportData function itself, or just ImportData from Yahoo Finance?  Basically, can we get data from another source? Google Finance is not an option, since its data is incomplete and often times just plain wrong.
Reply
#3
(04-03-2016, 09:01 AM)Caversham Wrote: I use Yahoo Finance for all of my data and my spreadsheet has been borked for the last week.  I've seen similar, flaky behavior before; so I was hoping this was a temporary issue, but it sounds like that might not be the case.

Is the issue with the ImportData function itself, or just ImportData from Yahoo Finance?  Basically, can we get data from another source?  Google Finance is not an option, since its data is incomplete and often times just plain wrong.

Think it's "Big"....

Some clues here:

http://forums.hardwarezone.com.sg/stocks-shares-indices-92/tracking-investments-google-spreadsheet-4275653-7.html

and here:

http://www.investmentmoats.com/money-man...o-tracker/

Puts me waaaaay behind the power curve monitoring our portfolio.
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
#4
Here is thread at Google about this:

https://productforums.google.com/forum/#...ce=starred

(Hope the link works for you)
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
#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
#6
And for what it's worth, the New Stock Rover is an "aggregator" so you can link your brokerage and it will keep your shares and transactions updated automatically.  I also just found an export function (under the START) button that exports as a csv file whatever tab you are viewing.  So pending the Google issue I might just revert back to Excel and use an INDEX Match function to get what I need.

Cheers,

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
#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
#8
Happy to report the Google Sheets (using Caversham's tip above) is functioning at 99% power ....all is well with the world...
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
#9
Sad 
.....aaaaaaaannnnnddd it's back Sad.

For some reason the dividend data import failure from Yahoo into Google is back....
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
#10
(05-11-2016, 01:20 PM)Robandcindy2 Wrote: .....aaaaaaaannnnnddd it's back Sad.

For some reason the dividend data import failure from Yahoo into Google is back....

And actually, in this spreadsheet there are three pages that collect dividend info.  On one it works perfectly, one partly and the other not at all...

Weird...
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
#11
(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ʺ))

Is your sheet still working?  Mine have stopped for almost two weeks now.   About had it with the Almighty Google.  I keep filling trouble reports asking them to just add Yield and Dividend to the available Google Finance Stock Attributes ... Oye!
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
#12
(05-19-2016, 06:29 AM)Robandcindy2 Wrote:
(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ʺ))

Is your sheet still working?  Mine have stopped for almost two weeks now.   About had it with the Almighty Google.  I keep filling trouble reports asking them to just add Yield and Dividend to the available Google Finance Stock Attributes ... Oye!


My spreadsheets are still working for the most part.  The only issue I'm having is that the Ex-Dividend and Dividend Pay Dates are wrong.  Everything else like price, yield, dividend per share, etc seem to be working fine for me.
Reply




Users browsing this thread: 2 Guest(s)