Unveiling the RPC Simple Portfolio Tracker, version 1!

One of my main goals with my reboot of RPC last month was to provide more resources and more tips to help novice DIY investors up their skill level. Here, then, is a super easy-to-use Portfolio Tracker, complete with a narrated screencast showing you how it works and how you can personalize it!

Note to my readers: this is definitely a "basics" post, so if you've already got your own system for tracking your portfolio, then this is maybe not for you. Would love it if it could be shared with any novice investors you know, though!

Give a person a fish, and feed them for a day; teach them how to fish and they can feed themselves for a lifetime. Better yet: give people a portfolio, provide guidance for a moment; show someone how to track their own portfolio using Google Sheets and help them be a better DIY investor!

In that spirit, I present Version One of The RPC Simple Portfolio Tracker!

 As I was creating it, I kept three goals in mind for the tracker. It had to be:

  1. Helpful - it will help you get organized with all of your assets.
  2. Fast and Easy to Use - yes, it may take some time to set up, but is pretty automated after that.
  3. Informative without being cluttered - it tells the user what their current allocations are and how far off they are from a target, but doesn’t get too far into the weeds.

Hopefully, that's what comes across!

Click here to make a copy:

Once you make a copy, but before you dive into it, I might suggest having a few things handy:

  1. You'll need to know what your assets are
  2. You'll need to know what asset classes those are in (can be multiple, you just need to know)
  3. What portfolio you want to track.

As for how it works, if you prefer to have something written, the spreadsheet I used in the video is here, and you can look at slides 8 through 15 from the steps.

If you want me to walk you through it, here is a 20-minute YouTube tutorial:

In case you are reading this far, and you'd like a portfolio tracker that is a little more advanced and helps more with rebalancing, you might like two posts from the summer of 2022 where I present a portfolio rebalancing tool:

Simple Portfolio Rebalancing Spreadsheet
Investors who try to maintain any given asset allocation in a portfolio will soon find that asset price ups and downs have taken that portfolio “out of whack.” Here’s a quick explanation of rebalancing - getting that portfolio back in line - with a helpful tool to make the process easier.

then made a few tweaks to add a cash allocation, and that version is here:

Version 1.1 of the Simple Portfolio Rebalancing Spreadsheet
Released version 1.0 of the Simple Portfolio Rebalancing Spreadsheet back in May, but that one was missing a way to track cash withdrawals. Not a major change, but here’s a new version that makes that process pretty straight forward.

As always, feedback and questions are welcomed! 

Questions and suggestions welcomed!