06-03-2016, 03:41 PM
(This post was last modified: 06-03-2016, 03:42 PM by Robandcindy2.)
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
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
Frederick Buechner