Google Sheets

[Jason]

(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