Dividend Growth Forum › Dividend Growth Investing › Dividend Growth Investing v
Spreadsheets

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Spreadsheets
rayray Offline
Founding Member
*****
Posts: 1,002
Threads: 85
Joined: Apr 2015
Reputation: 16
#5
08-09-2015, 02:05 PM (This post was last modified: 08-09-2015, 02:06 PM by rayray.)
(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.
Find
Reply


Messages In This Thread
Spreadsheets - by rayray - 08-09-2015, 10:14 AM
RE: Spreadsheets - by cannew - 08-09-2015, 10:35 AM
RE: Spreadsheets - by EricL - 08-09-2015, 11:41 AM
RE: Spreadsheets - by earthtodan - 08-09-2015, 12:39 PM
RE: Spreadsheets - by rayray - 08-09-2015, 02:05 PM
RE: Spreadsheets - by Caversham - 08-09-2015, 02:56 PM
RE: Spreadsheets - by earthtodan - 08-09-2015, 02:17 PM
RE: Spreadsheets - by rayray - 08-09-2015, 05:15 PM
RE: Spreadsheets - by earthtodan - 08-09-2015, 06:16 PM
RE: Spreadsheets - by rayray - 08-09-2015, 06:35 PM
RE: Spreadsheets - by Roadmap2Retire - 08-09-2015, 09:03 PM
RE: Spreadsheets - by Rasec - 08-10-2015, 11:00 AM
RE: Spreadsheets - by rapidacid - 08-10-2015, 12:19 PM
RE: Spreadsheets - by Rasec - 08-10-2015, 04:59 PM
RE: Spreadsheets - by earthtodan - 08-10-2015, 04:57 PM



Users browsing this thread: 2 Guest(s)