My Dividend Radar

Just as Air Traffic Controller tracks every incoming and outgoing airplane in his airspace or airport, I track my dividends as they come in for a landing into my account.

I have built a Dividend Payment Radar that helps me track every single payment from the moment it shows up on the radar (via company dividend announcement) till the time it lands into my account.

My Dividend Radar showing high dividend traffic in September

All these dividends are on auto-pilot, in other words I don't have to do anything to land them in my account. Once they are declared by a company, they show up on my radar at the right date and then all I have to do is watch them land as cold hard cash in my account.

As the dividends land, they eventually disappear from the radar and get replaced with new dividends on the horizon.

In September alone, I have 29 dividends coming in for a landing, half of them have already landed and half have yet to land. That's almost one dividend payment a day.

I get especially excited when my high flying dividends show up on the radar. They pay the most cash. I don't mind the low flying ones either, sometimes they come in a bunch, like a flock of birds.

That's the beauty of dividends. Most of the work is upfront, and then you just watch them come and land into your account as cold hard cash.

Though, I do track them very closely to make sure they don't get reduced in size or worse, just disappear (never happened to me as I watch them like a hawk).

I don't mess around when it comes to investing, meaning I don't speculate.

I do lots of work up front to make sure my investment thesis is solid and I'm only investing in stocks with high quality dividends that will continue to fly higher and higher in years to come with the least amount of risk of getting reduced or lost.

My dividend radar is hooked into my spreadsheet with numerous parameters that I can adjust to look at various financial metrics for all the companies that I own the stock in. I have flags setup that light-up when any of the metrics get out of the normal range and warn me of any impending danger.

I have a separate radar for watch list, which tells me when a prospective stock or dividend is getting close to my valuation and dividend targets. I'm a very patient investor, I will wait as long as it takes to get the stock at the right target price. Sometimes, I may have to wait for a very long time, but it is okay as I got plenty of time and there is no hurry to invest.

As you can probably guess, I have too much free time in my hands. Well, that's the beauty of retiring early, you can do whatever you want with your time in retirement. I choose to spend most of my time tweaking and building different investment tools and strategies while making an investing lot of fun for myself. After all, investing is now my full time job and my new passion.

How does your dividend radar look like? Or do you even have one?


  1. That's just excellent Mr. ATM. I wish I was smart enough to do something like that, so I don't have a dividend radar. It's great when you can make a review of your investments fun and exciting.

    1. Thanks DP, well I'm sure you are smart enough or you wouldn't be investing :)

  2. That's a super cool idea and a nice way to visualize the cash that is coming your way in the future. I assume it required a bit of legwork in the beginning to get it set up? How do you update the dividend totals when dividends grow and shares change, is it all manual?

    1. Thanks, yes there is legwork involved but not much more than what I had already done with my spreadsheet. When I was using Yahoo Finance, I could update dividend info automatically. However, with the Google Finance, the dividend info is missing, so I have to update the div/sh manually when I get an alert (I use SeekingAlpha alert system) and then the Radar gets updated automatically.

      Once it's setup right, it's not a lot of work as most companies change dividends once a year and payment dates are about the same yoy.

  3. A dividend radar, how awesome! Very creative. September is shaping up to be a really good month for my dividends too. Have a few more to go. Not much better than seeing those babies roll in. Thanks for sharing!

    1. Thanks DS. Glad to hear your September is shaping well as well.

      Take care

  4. I'd buy a dividend radar app. More income for you and your work.

    1. I will think about it. Thanks for the interest!

    2. Yup - I'd pay for this spreadsheet too.

    3. Thanks, I blog for fun and anything I share on it is to inspire others to invest, and especially see the power of dividend investing. Investing doesn't have to be boring.

      It seems there is quite a bit of interest in my spreadsheet and radar as I also got some emails regarding it. So, I will look into it, to see how I can make it available for others to use.


  5. Very pretty.

    My dividend radar is something to be desired. I have one column in excel stating what month or date (if monthly) it should be paid. Another column lets me know what the annual total should be. I don't have any records for what I should receive in any given month except if I compare it to the corresponding previous month/quarter. It's been changing regularly for the past two years as I transition our accounts into "retirment mode" so that they maximize our dividend income. I have a large emergency fund (one year) so I'm really just interested in my annual totals. I worry that if I tracked every single payment at all times, I'd be even more obsessed and I'm already way too obsessed as it is. And so, I will live vicariously through you and your lovely radar graphic.

    Thanks for sharing.

    1. Thanks, I use my dividend radar to project my dividend income for current and next month. My spreadsheet also tracks yearly income both current and projected (based on div increases), though radar is still more fun and a good motivation tool.

  6. Daaamn, I want one of those. Really creative! I´ll make one too soon. Good stuff man!

  7. I spend way too much time anticipating incoming dividends, and I don't have that many yet, so I deliberately chose not to have a radar for now or I'd be glued to it :) Instead, for now, my job is to make smart purchases to create those dividends and when it frees me up enough to retire, I can enjoy putting together a radar. I'd love to see some portions of yours to see what you include if you wanted to share.

    1. Hi,

      I understand :) I'm assuming you want to see my portfolio? If so, you can see the link on the side bar of this blog.


  8. I really like the radar. I have been spending a lot of time trying to research and come up with some visualizations. I do it for work so why not attempt it here too right? But the problem comes in with the data sync. There is no way that I have found to sync up live market data to the visualization software. So the closest I can get is the delayed google docs. Do you manually have to enter the dividend dates into your spreadsheets to make the radar? Great concept though. I'm a nerd myself and love making new tracking tools or analytics.

    1. Hi DD,

      GoogleFinance function in Googlesheet lacks dividend related information which is a big problem for DGIs like us who like to track dividend related metrics.

      However, there is a way to get around this limitation by using importxml function, though not perfect, it gets the job done most of the time.

      I automatically get the Div related information such as Div/Sh, Ex-Div, and Div-date into my spreadsheet using the above method.

      However, there are times when I may have to update it manually as the automatic method gets stuck on 'Loading...' data.

      The importxml allows you to scrape or import data from essentially any website by parsing through the html tags and then importing specific data attached to those tags.

      This method works well for small number of queries. Google has a limit on how many importxml queries you can perform within a sheet in a given 24hrs and they do throttle it down if they see too many queries.

      Give the above method a try and see if it works for you.


Post a Comment

Popular posts from this blog

Micro Blog #26: My Dividend Glide Slope

Building A City Of Dividend Stocks

How To Speed Read An Earnings Report In 60 Seconds Or Less

Micro Blog #28: My April Stock Buys

Micro Blog Post #30: Taking Advantage of High Yielding Dividend Stocks to Pay for Healthcare

Speed Reading Earnings Report: Beyond The First 60 Seconds