Managed Funds
The Managed Fund tab tracks your investments live prices and performance of your holdings.
Introduction
The Managed Fund tab helps you track your investments and provides insights into their performance. The tab consists of two main components:
The Watch table at the top displays information about your investments (both those you've invested in and those you're following but haven't invested in yet).
The Purchase History table records all your purchases. Using these exact dates and prices, the Sheet automatically calculates various performance statistics.
Adding a new Fund purchase to the Watch list
To start tracking a fund, complete a new row in the Watch table by filling in the fields from left to right:
ID
The fund's identifier from Bloomberg, MorningStar, Yahoo Finance, or FT.com. Since different platforms track different funds, you'll need to determine which source tracks your fund and find its ID. Click here for instructions on finding your fund ticker.
Fund Name
A simple nickname for the fund that helps you identify it.
Currency
The currency in which the fund is priced. For example, if you have an AUD-based sheet but own an American fund, enter USD as the currency. The Live Price will then display the converted price in your local currency.
Target Allocation
If you maintain target allocations in your portfolio to keep holdings balanced, enter the percentage here.
MGT Fee
The management fee for the fund. This is for reference only and helps you keep track of fees across your investments.
Location
A reference field to help ensure geographic diversification. This information populates the graphs on the right side of the tab.
Region %
A reference field to track regional diversification. This information populates the graphs on the right side of the tab.
Sector
A reference field to track sector diversification. This information populates the graphs on the right side of the tab.
Buying and Selling
Each time you buy or sell units in a Managed Fund, update the Purchase History table with the following information:
Ticker
The ticker that matches the holding in the Watch table.
Purchase Date
The date of the transaction.
Volume
The number of units transacted (positive for purchases, negative for sales).
Bought Price
The price per unit in your local base currency.
IMPORTANT: Any fund that you currently own (with a positive balance) and have transaction history for must appear in the Watch table.
Returning the price with 3-4 Decimal Places
See the FAQ on this topic here.
International Managed Fund Support
Version 2 of the Sheet supports international funds and converts their values to your local currency in real-time. These assets are included in your net worth using the current day's exchange rate.
Step 1 - Entering an international asset into the Watch table
To add an international asset, first enter its ID (column A) and name (column B) in the Watch table. Then enter the currency in which the asset is priced (column C). For example, use USD for assets on the NYSE (New York Stock Exchange). Verify the currency on the website where you found the Managed Fund ID.
In the example above, the Watch table displays the converted local value in the Live Price column. For the fund MGE0001AU.AX, the original price is $1.97 AUD, but the Sheet displays the converted value of £1.05 GBP.
Step 2 - Entering purchases for an international asset
Recording purchases for international assets is similar to local assets. The key difference is the Order Price column, which must contain the pre-converted price in your local currency.
For example: If you have the UK Sheet (GBP currency) and purchased 10 units of FXAIX at $153 USD per unit, you would enter the converted amount of £111.42 in the Order Price column.
Backdated Currency rates
For historical purchases where you need past exchange rates, use these resources:
Automatic conversion for past transactions will be added in a future update.
Adding new rows to the Watch table
To expand the Watch table:
Step 1 - Right-click on any row containing a yellow holding.
Step 2 - Select Insert 1 above.
Step 3 - The new row will be empty of formulas. To add them, right-click on the row you used in Step 1 and select Copy.
Step 4 - Click on the empty row created in Step 2, right-click and select Paste.
This will expand the table and fill the new row with all required formulas. Repeat as needed.
Spaceship, Raiz and Microinvesting Platform Support
Spaceship Voyager
For Spaceship Voyager funds, enter the following details in the Managed Funds tab:
Spaceship Voyager Universe:
Fund ID - SPACEVOYUNIV
Fund Name (Important) - Spaceship Voyager Universe
Spaceship Voyager Origin:
Fund ID - SPACEVOYORIGIN
Fund Name (Important) - Spaceship Voyager Origin
Spaceship Voyager Earth:
Fund ID - SPACEVOYEARTH
Fund Name (Important) - Spaceship Voyager Earth
Spaceship Voyager Galaxy:
Fund ID - SPACEVOYGALAXY
Fund Name (Important) - Spaceship Voyager Galaxy
Spaceship Voyager Explorer:
Fund ID - SPACEVOYEXPLORER
Fund Name (Important) - Spaceship Voyager Explorer
For Purchase History, enter either your itemized transactions or, if you have many purchases, a single entry that you update regularly. Note that consolidating purchases into a single entry will make performance/gain calculations inaccurate.
Prices are updated every 24 hours.
For Raiz & Other Investment Platforms:
For other microinvestment platforms, you have two options:
Other Assets Tab (Easiest) - This records your investments in your net worth, but you'll need to update the balance before recording each month.
Managed Funds Tab - Enter your platform as a managed fund and manually update the live price as needed (ignore any warnings). Enter purchase history as provided by your platform.
Last updated