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!
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:
- Helpful - it will help you get organized with all of your assets.
- Fast and Easy to Use - yes, it may take some time to set up, but is pretty automated after that.
- 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:
- You'll need to know what your assets are
- You'll need to know what asset classes those are in (can be multiple, you just need to know)
- 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:
then made a few tweaks to add a cash allocation, and that version is here:
As always, feedback and questions are welcomed!