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…





2 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

Leave a Comment

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