Thursday, 15 October 2015

Portfolio Live - Investment Portfolio Rebalancing Spreadsheet

Portfolio Live v1p3

The objective of this spreadsheet is to allow you to re-balance your investment portfolio while reducing purchasing costs and maximize tax efficiency. It does not spread the funds (or stocks) across all accounts, but tries to keep all of each fund in just 1 or 2 accounts. 

Updated to version 1.3 on October 15th, 2015 to fix a minor bug. Updated to version 1.2 on August 28th, 2015 to add new functionality to allow you to balance the portfolio based on Asset Classes instead of just by each Asset (Fund or Stock). In the spreadsheet there are two separate sheets, one to do the calculation by Asset and the other by Asset Class. 

Version 1.1 added new functionality to allow you to force funds not to be sold from any of the accounts. This feature can be used to allow you to balance the portfolio as best as possible while not selling funds with unrealized capital gains in the Taxable account. 

Here's a link to the spreadsheet on Google Sheets. After you open this please make a copy to your own Google Drive.  

Here's a link to an Excel version. Note that in this version you need to enter stock, ETF and mutual fund prices by hand, or use this Google Sheet - Portfolio Prices - to pull prices from Google Finance and then paste them into the Excel spreadsheet.