tag:blogger.com,1999:blog-427910661735246223.post2082739908730947070..comments2024-03-27T10:42:40.841+02:00Comments on Dividend Hawk: U.S. ChampionsDividendHawkhttp://www.blogger.com/profile/18442876937263496120noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-427910661735246223.post-73244958866879634122016-11-21T16:55:43.899+02:002016-11-21T16:55:43.899+02:00Hi DD, Unfortunately, I do not, but look at this p...Hi DD, Unfortunately, I do not, but look at this page, http://dividendlife.com/uk-dividend-champions-home/ , there can be found a few lists of Europeans dividend growers.<br /><br />Thanks for visiting!<br />DHDividendHawkhttps://www.blogger.com/profile/18442876937263496120noreply@blogger.comtag:blogger.com,1999:blog-427910661735246223.post-87574095767271362072016-11-20T20:22:45.374+02:002016-11-20T20:22:45.374+02:00Hi Dividend Hawk, I was wondering if you have a si...Hi Dividend Hawk, I was wondering if you have a similar list for European dividend growth stocks as well? Or if you know where I could find it.. I've been searching but havn't been able to find them..Dividend Dolphinhttps://www.blogger.com/profile/04881245912001878127noreply@blogger.comtag:blogger.com,1999:blog-427910661735246223.post-4587596255324511212016-04-30T10:33:01.293+03:002016-04-30T10:33:01.293+03:00Hi DF, Glad to hear that you like my spreadsheets....Hi DF, Glad to hear that you like my spreadsheets. For this sheet I only calculate the payout ratio, pick up dividend is a bit complicated from Google Finance and that's why I have only copied it from David Fish's Excel Spreadsheet. Internet is full of adviced how to pick dividend from Google Finance, some of those has worked for me, but only short time :( <br />here is one: <br />=split(ImportXML(concatenate("http://finance.google.com/finance?q=",B2), "//td[@data-snapfield='latest_dividend-dividend_yield']/following-sibling::*"),"/")<br />This will pick up dividend and yield for company, which ticker is in cell B2 and put dividend and yield to two different cell. <br />Full list of Google finance atributes you will found for ex. at https://support.google.com/docs/answer/3093281?hl=en. <br />YahooFinance have more alternatives, but for some reason it also stopped work for me.<br />You can use this: =ImportData("http://finance.yahoo.com/d/quotes.csv?s=TIKKERI&f=PARAMETRIT")to get info from Yahoo. <br />Change TIKKERI for ex. CVX and PARAMETRI for d you should have dividend for Chevron. <br />=ImportData("http://finance.yahoo.com/d/quotes.csv?s=CVX&f=d")<br />Here is one list of Yahoo parameters (http://www.taloudellinenriippumattomuus.com/2010/09/automatisoi-sijoitustesi-seuranta.html) sorry finnish language!<br /><br />I hope those tips will help you to create your own list.<br /><br />Thanks for stopping by!<br />DH<br /> <br />DividendHawkhttps://www.blogger.com/profile/18442876937263496120noreply@blogger.comtag:blogger.com,1999:blog-427910661735246223.post-45677415491985016772016-04-29T16:31:45.279+03:002016-04-29T16:31:45.279+03:00Hi DH
I love your spreedsheets :) I am about to c...Hi DH<br /><br />I love your spreedsheets :) I am about to create my own watch list. Can you explain how you are pulling payout ratio and dividend amounts into your sheet? <br /><br /><br /><br />Regards<br />Dividend FreedomDividend Freedomhttp://www.dividendfreedom.comnoreply@blogger.com