v2.1.1

This small release adds some big functionality. It addresses a recent issue where the GOOGLEFINANCE function stopped pulling expense ratios.

With this new version, you can now define "backup sources" to ensure key data is always available. This allows Portfolio Tracker to:

• Pull expense ratios, names, and prices even when GOOGLEFINANCE fails.
• Retrieve fund information from backup sources for funds not supported by GOOGLEFINANCE (like SPAXX).
• Automatically pull expense ratios for ETFs, which is a current limitation of the GOOGLEFINANCE function #17

Resources:

• Template - Create your copy to get started!

  This template contains the minimum amount of data to allow for easy setup.

• Sample Data - Create a copy to see a fully populated sample.

  Note: A fully populated sheet with Sample Data.
  It is recommended to use this for reference only. Start with the template above when entering your own data.

• Documentation

Added

• Ability to define Backup Sources for Asset Name, Price and Expense Ratio

v2.1.0

v2.1.0 is now available, featuring new functionality, bug fixes, and design improvements!

• Template - Create your copy to get started!

  This template contains the minimum amount of data to allow for easy setup.

• Sample Data - Create a copy to see a fully populated sample.

  Note: A fully populated sheet with Sample Data.
  It is recommended to use this for reference only. Start with the template above when entering your own data.

• Documentation

Note: If you are upgrading from a previous version be sure to read the Upgrade Guide.

Added

• New Account Dashboard

Updated

• UI Improvements
• Removed "most" of the sample data

  Many issues were caused when attempting to clear out this data
  A separate version with sample data is available

• Better conditional formatting to indicate cells that:
  • expect a value (orange)
  • contain invalid data (red)
  • are missing a formula (pink)
• Improved column groupings (with easier-to-see group titles)
• Improved Allocation Dashboard
  • Added "Group By"
  • Total Asset Value now shows daily change
  • Rebalance Summary includes "Rebalance Amt"
• Asset Setup
  • Class Categories can now be further categorized with a parent "top-level category"
• Account Setup
  • Account Types can now be assigned a "tax type"
• Holdings
  • Table Group Views now include aggregate values

Fixed

• Return percentages are incorrect (#6)
• Zero Allocation Target Ignored for Rebalance (#10)

v2.0.1

This is a small release to fix some minor annoyances.

• Make a copy - Create your copy!
• Documentation - Read all about it

Added

• Account Target Percentages (Holdings Tab) now default to Actual Percentage to minimize confusion.
  • This will show no change in the “After Rebalance” graph, unless you decide to modify them.
  • Once your holdings are entered you may manually update the holding targets to run "what if" scenarios. (i.e. "What if I reduce my bond fund percentage in Roth IRA and increase it in my 401K?"

    Note: Just make sure your targets add up to 100% for each account (There is currently no validation for this)

Fixed

• After Rebalance totals were incorrect. They were not accounting for assets with multiple classes

v2.0.0

After almost a decade, it is here!

• Make a copy - Create your copy!
• Documentation - Read all about it

Note: Documentation is still being written, so check back often.

v1.0.0 - 3/5/2015

Initial Release shared with Rob Berger of DoughRoller (now under new ownership)

• Make a copy - Create your own copy of the Google Sheet.
• Documentation - Original documentation.

Note: Rob, with my permission, removed some functionality and made small tweaks throughout the years.
His current version may be found here.

• Original article (with credit given) is available on the Wayback Machine.
• Original podcast episode: DR 179 - A Free Investment Tracking Spreadsheet