08-09-2015, 12:39 PM
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.
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.