Dividend spreadsheet


21 comments:

  1. Hi, anyway you can make this pop out? Scrolling back and forth to match the quarters with the dividends with the symbols is frustrating.

    ReplyDelete
    Replies
    1. Anonymous,

      My I.T. skills are very limited so at this time the answer is no. However if anyone can walk me through the process with Blogger I would be happy to try it out.

      The good news is that in five weeks we will be back to January! :-)

      MDP

      Delete
    2. What works for me:
      Click on "Design" and then "Pages". Click on "edit" for the "Page" you want to edit. At the top left hand corner, you have the option of selecting "Compose" or "HTML". Click on "HTML" and increase the number between quotation marks for height and width.

      I don't know how to make it "pop out" though.

      Delete
    3. Thanks ADY. That helped. It's not exactly centered at least you can see every month!

      Delete
    4. MDP,

      This looks like a really nice dividend machine you have built for yourself. I like that you are tracking your portfolio weight, you are ensuring diversification, and also using timesaving tools like google docs.

      Good luck in your dividend investing journey!

      Dividend Growth Investor

      Delete
    5. Another easy thing is to add the tickers again in the final column on the right side of your spreadsheet, this is easy to do and particularly useful when looking at the second half of the year.

      Delete
  2. Much, much better. Thank you!

    ReplyDelete
  3. Hello SIr,
    i am from Germany and i can not found the shares in your first column for example AHITX. It is possible to write in a extra colum the isin number to identify this shares on my financial sites? Or do you have a extra overview about that?
    Thank you very much in advance.
    Brgds
    Sky

    ReplyDelete
    Replies
    1. Sky,

      Sorry about that. I had the share count in 2014 and just forgot to add it to 2015.

      MDP

      Delete
  4. No Problem. I think i used the wrong words. I would say that i can not understand the company´s behind your short term. For Example AHITX. I would like find this company but i can not find it because my search engine dont know it.

    ReplyDelete
  5. Replies
    1. Sky,

      No problem. CAIBX and AHITX are mutual funds. CAIBX is comprised mostly of dividend stocks with some bond holdings and AHITX is a high yield (junk bond) fund that makes monthly interest payments.

      I hope that helps.

      MDP

      Delete
  6. Great looking spreadsheet there. I should probably do something more along those lines so I know exactly what months the companies I own usually pay in. We have a bunch of the same companies so at least I've got a head start!

    Thanks

    ReplyDelete
  7. Great Looking portfolio, I hope one day to get there!

    ReplyDelete
  8. I am currently in Australia, in AU, the dividend tax can be paid off by the enterprise, when they enterprises start the announcement of dividend payment, they will have a frank value in percentage, which means the ratio of dividend tax the company will pay for investors. Not sure if America has this?

    ReplyDelete
  9. Great sheet! This does provide 100% insight in your status. Do you make any graphics with that for yourself? Cheers and keep up the good work!

    ReplyDelete
  10. And you're invited at https://thedutchlakehouse.blogspot.nl/ ;)

    ReplyDelete
  11. Walter,

    No graphs. They are beyond both my capability and my patience levels. :-)

    MDP

    ReplyDelete
  12. I like your Dividend spreadsheet, I'me going to try the same in my blog. I'm learning about you and all comunity.

    ReplyDelete
  13. How do you calculate your YOY row? Thanks.

    ReplyDelete
    Replies
    1. Simply the NEW year amount minus the PREVIOUS year amount (on the same month).
      For ex. =SUM(D103-D104)

      Delete