Portfolio returns tracker, v1.2

by FIRE v London (mail@FIREvLondon.com)

Latest version 16 January 2017

What this workbook is for

Evaluating your asset exposure of your investment portfolio

Calculating your portfolio returns, in a unitised way

Integrating accounts from multiple brokers into one consistent portfolio

How to use

The core principle of this workbook is to enable you to import portfolios from any broker in any (Excel-readable) format

The basic process is this

1. For each of your brokerage accounts, obtain the latest snapshot holding (via Download-as-CSV or similar), and copy/paste into this workbook, one tab per broker

2. For any new holdings not in the spreadsheet yet, add them in two places:

a) Add details about the security in 'Asset database'. You should record the asset type, the annual % cost, the annual % yield, the geography

b) Put the name into 'Name lookup'. The first time you do this the two name fields ('Security/Fund, raw text' and 'Unique security') in this tab will be the same.

3. For any holdings where the security isn't new but broker's name has changed slightly (e.g. 'Acme PLC Ord Shs' instead of 'Acme Plc Ordinary Shares') add a new row into 'Name lookup' with the new raw name but the original unchanged 'unique security' name. Leave your original row there - your broker is quite likely to revert back to that name at some point!

4. If you have added/removed holdings since the last update, amend the 'Integrated' spreadsheet accordingly - by inserting or removing rows for each affected broker

5. After each [month], add a new row in the 'Over time' tab, just above the bottom row, and copy/paste the bottom row into it. The bottom row shouldn't be changed

6. The 'returns' tab should then reflect your historic performance and graph it over time

You can define your own geographic split (e.g. UK/US/Europe/other, UK, US, Other) very easily by changing the 'Geography (monevator)' data in 'Asset database'

If you want to distinguish between tax-sheltered (ISAs/SIPPs/etc) and taxable accounts, then use the 'Subaccount' field in the 3: Integrated tab. On platforms like Fidelity you will need to download each subaccount separately, with appropriate labels for ISA/Investment funds/etc.