08-09-2015, 02:56 PM
(08-09-2015, 02:05 PM)rayray Wrote:(08-09-2015, 12:39 PM)earthtodan Wrote: 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.
Dan,
Thank you but for some reason it's not working for me. I either get #NAME? or #N/A in the cell.
I use the exact same formula in my spreadsheet. I have found that sometimes copy+pasting formulas into Google Spreadsheet does not work. You can either try typing the formula manually, or sometimes I've found that just deleting and retyping the double quotes (") works.
If you want a pre-built spreadsheet, I really like the ones here:
http://www.twoinvesting.com/2013/08/inve...eadsheets/