Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Google Sheets
#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
#13
(05-19-2016, 08:58 PM)Caversham Wrote:
(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.

So my first reaction was WTF!!!!!!   Then I wondered what I had done so I copied and pasted one line of my sheet to a new google sheet and it worked fine.  So I don't know where the road block is.  Too many import data's?  Did they put a limit on that?    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
#14
Well I threw in the towel.

Added a "sheet" to my GoogleSheet portfolio which I export from Stock Rover with just the dividend info I can't get from Google or YahooFinance (IMPORTDATA).

Then in those dividend related cells I do an INDEX import:

=INDEX(StockRover!D$2 : D$260,MATCH($F5,StockRover!A$2:A$260,0))

Extra work to import the sheet once a month or so but hopefully Google will get their act together and add "dividend", "yield", etc. to their GoogleFinance import functions for equities.

Have a good weekend everyone!

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
#15
(06-03-2016, 03:41 PM)Robandcindy2 Wrote: Well I threw in the towel.

Added a "sheet" to my GoogleSheet portfolio which I export from Stock Rover with just the dividend info I can't get from Google or YahooFinance (IMPORTDATA).

Then in those dividend related cells I do an INDEX import:

=INDEX(StockRover!D$2 : D$260,MATCH($F5,StockRover!A$2:A$260,0))

Extra work to import the sheet once a month or so but hopefully Google will get their act together and add "dividend", "yield", etc. to their GoogleFinance import functions for equities.

Have a good weekend everyone!

Rob


If you  just need current dividend info try this   =IFERROR(index(split(ImportXML("http://finance.google.com/finance?q="&C2, "//td[@data-snapfield='latest_dividend-dividend_yield']/following-sibling::*"),"/"),1,1),"--")

Just change c2 to whatever cell you have your company tickers. Jason
Reply




Users browsing this thread: 1 Guest(s)