Posts: 970
Threads: 85
Joined: Apr 2015
Reputation:
14
I'm not a spreadsheet person, never actually did a spreadsheet that I can recall? I've always just used the data/info from my Fidelity or Vanguard accounts and when I had mostly mutual funds with a couple of individual stocks that was good enough for my needs. However, since I've been moving mostly out of mutual funds and into DGI's I realized that I actually need a spreadsheet in order to be more organized and see my progress easier then what the brokerages offer.
So I decided to try out Google's spreadsheet and so far I like what I'm able to do; however, I'm trying to import the dividend/yield info from Google Finance and well I can't seem to do it.
Does anyone know how to import the dividend or yield of a stock?
Thanks in advance!
Posts: 273
Threads: 37
Joined: Sep 2013
Reputation:
6
08-09-2015, 10:35 AM
(This post was last modified: 08-09-2015, 10:35 AM by cannew.)
Don't think it's possible. You can copy a block of data in Finance with Ctrl C, then paste it into a worksheet with Crl V. Once the info is in a worksheet and have the data you want in the order you want, block the just data you want with Ctrl C and then copy it into your actual worksheet with Ctrl V
Posts: 2,398
Threads: 54
Joined: Jul 2013
Reputation:
35
I haven't found a way to import the dividend data either. I have resorted to manually typing in the annual dividend rate in one column and then just have another column show the yield by dividing by the share price.
Posts: 312
Threads: 25
Joined: Mar 2014
Reputation:
12
It can be done.
1. Type a ticker symbol into cell A2
2. Paste this string into the cell where you want to show the yield:
=index(split(ImportXML("http://finance.google.com/finance?q="&A2, "//td[@data-snapfield='latest_dividend-dividend_yield']/following-sibling::*"),"/"),1,2)/100
I have a Google Doc that streams yields for about 40 companies. Once in a while they don't load properly, but for the most part it works great.
Posts: 312
Threads: 25
Joined: Mar 2014
Reputation:
12
Make sure the cell referenced in the middle of the string (A2 in the example) has the ticker symbol. Other than that, I'm not sure, I just took the formula from someone else.
Posts: 312
Threads: 25
Joined: Mar 2014
Reputation:
12
One more thing, just as a last ditch try. Change the cell format to %.