How to Build a Dividend Tracker Spreadsheet – Video Tutorial

Welcome to DividendMeter.com!  The blog’s original first post, “How to Create a Dividend Meter“, is now it’s own permanent website page.   Open this article to view a video tutorial version of how you can build your own dividend tracking spreadsheet in Google Sheets…





5 Comments

  1. Data Lore

    Meter Man,

    I just want to say that this particular post and tutorial really helped me to create my own blog. I followed the tutorial exactly and now I have my very own dividend meter. I’ve been looking for something like this for a while now, but somehow, the meter made something inside click. It’s so simple, but yet displays the dividends in such an elegant manner.

    For anyone going through the tutorial, I did have a couple of difficulties making some of the formulas work. In the video, Meter Man copied and pasted formulas from the website into the spreadsheet. I tried that and it didn’t work. It was also weird too because I had the formulas EXACTLY as indicated. What I eventually realize was that when you copy from the website, the way the quotes look (ie these things: “”) appear different when pasted in the spreadsheet.

    So, if you’re having difficulty after you’ve copied a formula, DON’T copy and paste. WRITE out the formula yourself in google spreadsheets and then it will work.

    Also, does anyone know the use of the “$” in the formulas. For example, lets say I want to calculate yield. The formula might be =$G2/$E2. But, I would get the same result if I ignored the “$” and just have in the formula box: =G2/E2. I’m not sure what the purpose of the $ is.

    Anyway, I just want to say a big THANK YOU to Meter Man and DividendMeter.com for helping me create my own blog and getting started with my own portfolio. My blog site is http://www.dividendportfolio.com. As you can see, my own dividend meter is all over that blog.

    Reply
  2. John Wyatt

    The $ in excel is used to denote an absolute. For example if you copy a formula down from cell to cell, it will adjust the cells based on location. If you use the $ the cell will not change when copied down.

    Reply
  3. Darren

    Looks great, just when you try to do it it does not work. Dunno if Google has changed something but the Yield column formula does not seem to work. Actually after getting the current price field working the spreadhsheet puts an “N/A in all fields of the remaining columns. After that if you try to input the Yield formula it messes up the current price field.

    Reply
    1. Meter ManMeter Man (Post author)

      Don’t even bother trying to import Yield – just calculate it. If you can import the current stock price and dividend, then just divide the dividend by stock price and you have a “real-time” dividend yield figure.

      Reply
  4. Märt

    Thanks for this! Ive used it for a long time but Yahoo has stopped their service and I cant find another way to import annual dividend

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *