Permanent portfolio historical performance spreadsheet
27 August 2013
Today I created a publicly-accessible Google Spreadsheet that calculates the performance of the Permanent Portfolio over a range of dates.
As a proxy for the four asset classes, the spreadsheet uses four ETFs:
- VTI (Stocks)1
- GLD (Gold)
- TLT (Long-term Government Bonds)
- SHY (Cash)
At the time of this writing, the spreadsheet looks something like this:
The only cells that should be edited are the start and ending dates, after which the spreadsheet calculates the performance of the portfolio over that range (assuming a 25% allocation to each.)
If you’d like to create a copy of this spreadsheet for your own use, you can find it here:
Click here to jump to the spreadsheet
- As readers of my Money for Something book know, I personally invest in both VTI and VXUS for my stocks allocation. I decided to not include VXUS in this spreadsheet, however, since it's a relatively new ETF and wouldn't allow the overall performance to be calculated beyond around 2011. ↩
Enjoy this article? — You can find similar content via the category and tag links below.
Questions or comments? — Feel free to email me using the contact form below, or reach out on Twitter.