Example portfolio returns tracker
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Portfolio returns tracker, v1.2
2
by FIRE v London (mail@FIREvLondon.com)
3
Latest version 16 January 2017
4
5
What this workbook is for
6
Evaluating your asset exposure of your investment portfolio
7
Calculating your portfolio returns, in a unitised way
8
Integrating accounts from multiple brokers into one consistent portfolio
9
10
How to use
11
The core principle of this workbook is to enable you to import portfolios from any broker in any (Excel-readable) format
12
The basic process is this
13
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
14
2. For any new holdings not in the spreadsheet yet, add them in two places:
15
a) Add details about the security in 'Asset database'. You should record the asset type, the annual % cost, the annual % yield, the geography
16
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.
17
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!
18
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
19
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
20
6. The 'returns' tab should then reflect your historic performance and graph it over time
21
22
Other tips
23
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'
24
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.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu