Investing towards a typical American retirement is as complex as you make it. For many the idea of buying, holding and re-balancing index funds is a daunting prospect. There is certainly no shame in meeting with a financial planner, so long as you understand their fees. For others however, tracking and fine tuning their retirement portfolio is necessary. Having a good investment tracking spreadsheet can help even the most unsophisticated investor make sound financial decisions.
In my search for tools to fine tune my retirement portfolio I couldn’t find anything that displays all of the relevant information that I need in one place. Though brokerage websites do provide this data its not available in a easy to review format, making cross-referencing a nightmare.
So I decided to create a series of investment tracking spreadsheets using Google Drive. I am providing them for free to kick-start this website.
With this Investment tracking spreadsheet you will be able to:
- Automatically track daily stock, ETF or Mutual Fund current/previous prices.
- Review the average cost per share of your funds.
- Track your total gains/losses.
- Track remaining retirement fund contributions.
- Review your current asset allocation against your ideal allocation.
- Test how current purchases alter your average cost per share and remaining contributions.
This tool is not intended for market timing, I follow long term buy- and-hold strategies for my retirement portfolio.
Here’s what the free investment tracking spreadsheet looks like
Instructions are included with the spreadsheet but in short, the tan colored sections are areas that you have to input manually. All other sections will automatically populate. Start customizing by replacing the sample fund names with funds you want to track. You will need to change the function to match your fund ticker names. Next, your investment values, total shares and your ideal asset allocation.
The basic asset allocation section provided in this spreadsheet will show you how your funds are balanced but it doesn’t tell you how you money is spread around within your funds. I expanded this section on a separate spreadsheet will be releasing it soon.
The Share Purchase Tester
You can use the Share Purchase Testing section to see how purchases at today’s prices alter your cost per share. This section also helps track your remaining contributions to retirement accounts.
In order to edit this spreadsheet you will need to make a copy in Google Drive. If you do not have a Gmail account, you can still view the spreadsheet but you wont be able to make changes.
I have also included a downloadable Excel Spreadsheet version but unfortunately, I have not been able to test it. Many of the functions I use to automate this spreadsheet rely on Google Drive codes, which likely wont work in Excel. However, this spreadsheet should be flexible enough to adapt to your needs with some moderate editing. Please let me know if you have questions or with any suggestions for improvement.
Keep posted for the next free investment tracking spreadsheet which will cover asset allocation.
Google Drive Link: Best Free Investment Tracking Spreadsheet
Excel Link: Best Free Investment Tracking Spreadsheet