Friday, April 18, 2014

U.S. Champions

U.S. Champions greated by David Fish is a list of companies that have increased their dividends every year for at least 25 years.
Data Source: Google Finance and CCC list


Quotes may be delayed up to 20 minutes. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.

4 comments:

  1. Hi DH

    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?



    Regards
    Dividend Freedom

    ReplyDelete
    Replies
    1. 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 :(
      here is one:
      =split(ImportXML(concatenate("http://finance.google.com/finance?q=",B2), "//td[@data-snapfield='latest_dividend-dividend_yield']/following-sibling::*"),"/")
      This will pick up dividend and yield for company, which ticker is in cell B2 and put dividend and yield to two different cell.
      Full list of Google finance atributes you will found for ex. at https://support.google.com/docs/answer/3093281?hl=en.
      YahooFinance have more alternatives, but for some reason it also stopped work for me.
      You can use this: =ImportData("http://finance.yahoo.com/d/quotes.csv?s=TIKKERI&f=PARAMETRIT")to get info from Yahoo.
      Change TIKKERI for ex. CVX and PARAMETRI for d you should have dividend for Chevron.
      =ImportData("http://finance.yahoo.com/d/quotes.csv?s=CVX&f=d")
      Here is one list of Yahoo parameters (http://www.taloudellinenriippumattomuus.com/2010/09/automatisoi-sijoitustesi-seuranta.html) sorry finnish language!

      I hope those tips will help you to create your own list.

      Thanks for stopping by!
      DH

      Delete
  2. 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..

    ReplyDelete
    Replies
    1. 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.

      Thanks for visiting!
      DH

      Delete