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 to the Tab
The Managed Fund tab tracks your various funds live and displays performance statistics for your purchase history. At the top of the tab you have the Watch table, which holds information about your investments (both those you've invested in and haven't invested in but are following).
The Purchase History table contains a list of all your purchases to date. Based on these exact prices and dates the Sheet automatically creates a variety of performance statistics.
Adding a new Fund purchase to the Watch list
To start tracking a fund that you own or have an interest in, simply start from left to right and fill out a new row.
Column | Explanation |
ID | This refers to the ID of the fund, and this is based on either the Bloomberg, MorningStar, Yahoo Finance or FT.com ID. As different funds are tracked on different websites, you will have to find which of these sources tracks your fund and determine that ID. You can find your fund ticker using the instructions here. |
Fund Name | This is a plain English name of the holding for your reference. |
Currency | This is the price that the holding is based in. For example if you have a AUD based sheet and own an American fund, you would enter USD as the currency. The Live Price will be the current price price automatically converted to AUD. |
Target Allocation | For those who like to apply allocations to their portfolios to always keep all their holdings in a target balance, this is where you would set that allocation. |
MGT Fee | This is a place to put the management fee for a holding. This is purely cosmetic and to help you have an overview of fees in your funds. |
Location | This is a cosmetic field to help ensure you're regionally diversified. This populates the graphs on the right side of the tab. |
Region % | This is a cosmetic field to help ensure you're regionally diversified. This populates the graphs on the right side of the tab. |
Sector | This is a cosmetic field to help ensure you're diversified across various sectors. This populates the graphs on the right side of the tab. |
If you are unsure of your Fund ID, please see these instruction on finding your Fund ID here.
Buying and Selling
Every time you buy or sell a parcel in your Managed Fund, you need to update the Purchase History table.
Column | Explanation |
Ticker | This is a ticker matching the holding in the Watch table. |
Purchase Date | The date of purchase. |
Volume | The amount of units moved. This is a positive number when purchasing, negative number when selling. |
Bought Price | This is the price you purchased/sold at. |
IMPORTANT: For the Funds that you still own (ie. have a positive balance for) and have a purchase history for these must be in the Watch table.
Spaceship, Raiz and Microinvesting Platform Support
Spaceship Voyager as of v2.10 has live pricing support. In the Managed Funds tab please enter the following details:
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
Purchase History - Enter in your itemized Purchase History, or if you have a large amount of purchases you can enter in a single purchase that you regularly update the quantity. Please note if you batch into a single purchase this will make any performance/gain figures inaccurate. Please note prices are only updated every 24hrs. For Raiz & Other Investment Platforms: For other Microinvestment Platforms you have 2 options:
Other Assets Tab (Easiest) - This Will Mean Your Investments Will Be Recorded In Your Net Worth, You Will Just Have To Update The Balance Before Recording Your Month.
Managed Funds Tab - Enter Your Platform As A Managed Fund And Manually Update The Live Price As Needed (Ignore Any Warnings). Enter In The Purchase History As Provided By Your Platform.
International Managed Fund Support
In the v2 version, the Sheet has support for including international funds and converting these live into your local currency. These assets are then included in your net worth with the current days exchange rate.
Step 1 - Entering an international asset into the Watch table
To enter an international asset into the Sheet, it must first go into the Watch table. As a first step, enter the assets ID (column A) and name (column B). Lastly, enter the currency for the asset based on where it is priced (ie. USD for the NYSE - New York Stock Exchange) into column C. Please confirm the currency on the website where you sourced the Managed Fund ID from.
As you can see in the watch table screenshot, the Live Price column will now display the current price in your local currency. If you take MGE0001AU.AX as an example in the screenshots, the current price is $1.97 AUD, but the Sheet has display a converted value of £1.05 GBP in the Live Price column.
Step 2 - Entering purchases for an international asset
Entering in the purchase history of an international is much the same as as a local asset. The only distinction is the Order Price column. The order price must be pre-converted upon entering.
For example: You have the UK Sheet (GBP Currency) and purchased 10 units of FXAIX for $153USD/unit. You would then enter £111.42 in the Order Price column.
Backdated Currency rates
For purchases made in the past where you need to lookup the exchange rate, you can use these resources:
In a future version of the Sheet support is being added to automatically convert past transactions.
Adding new rows to the Watch table
If you would like to expand the watch table, please follow the instructions below:
Step 1 - Right click on a row that contains a yellow holding.
Step 2 - Click Insert 1 above.
Step 3 - A new row should have been created but it will be empty of all formulas. To fill it with the correct formulas, right click on the row you clicked on in Step 1 and click on Copy.
Step 4 - Click on the empty row you created in Step 2, right click and click on paste.
This should expand the table and fill the new row with all the required formulas. Please repeat this as often as is needed.
Last updated