Managed Funds

The Managed Fund tab tracks your investments live prices and performance of your holdings.

Manual User Cells

• Managed Fund Details in the Watch table at the top • Purchase History in the Purchase History table towards the bottom

Introduction

The Managed Fund tab helps you track your investments and provides insights into their performance. The tab consists of two main components:

1. 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 Watch Table

1. The Purchase History table records all your purchases. Using these exact dates and prices, the Sheet automatically calculates various performance statistics.

The Purchase History Table

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:

Column	Explanation
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.

If you're unsure about your Fund ID, follow these instructions to find your Fund ID.

Buying and Selling

Each time you buy or sell units in a Managed Fund, update the Purchase History table with the following information:

Column	Explanation
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.

Automatic price lookups - for v2.14 and above:

Version 2.14 introduced automatic price lookup support, including for assets in different currencies. Important notes:

• The asset must be in the Watch table with the correct currency setting

• To conserve Google's quota limits, only 50 transactions can be looked up at once. After a value is retrieved, replace the formula with the actual value to free up slots for other lookups.

  • This process happens automatically when you open your sheet.

• These lookups provide estimates only. Prices fluctuate throughout the day, so the value returned is an average from the day, not an exact figure.

  • This applies to currency fluctuations as well.

  • For more accurate gain and CGT estimates, enter your exact transaction price if available.

• Support is limited to tickers available through Google Finance

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

Example Watch Table in UK Sheet

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.

Example fund with data sourced from Yahoo Finance

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

Automatic price lookups - for v2.14 and above:

A recent update added automatic price lookups with currency conversion support. Important notes:

• The asset must be in the Watch table with the correct currency setting

• Only 50 transactions can be processed at once to conserve Google's quota. After a value is retrieved, replace the formula with the actual value to free up slots.

  • This happens automatically when you open your sheet.

• These lookups provide estimates only. Both ticker and currency prices fluctuate throughout the day, so values are averaged.

  • For accurate gain and CGT estimates, enter your exact transaction price when available.

• Support is limited to funds available through Google Finance

For historical purchases where you need past exchange rates, use these resources:

• https://www.xe.com/currencytables/
• https://www.x-rates.com/historical/
• https://www.ofx.com/en-au/forex-news/historical-exchange-rates/

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:

1. Other Assets Tab (Easiest) - This records your investments in your net worth, but you'll need to update the balance before recording each month.

2. 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.