Portfolio Planning Public
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
What is this spreadsheet for?This spreadsheet helps you plan and track an asset type allocation and specific holdings for a portfolio spread over several trading accounts.
2
How do I use the Allocations sheet?Create Asset Types, such as Bonds and US Equity on the 'Allocations' sheet. To do this, duplicate one of the rows under Asset Type and rename it. Make sure that the Named range (see Data menu) continues to include all of the AssetTypes.
3
Name Accounts on the Allocations page 'List Items' page. If you create more accounts make sure that the 'Value Checksum' formula includes the new column.
4
Set Target Allocations that add up to 100%
5
How do I use the Holdings sheet?Edit or add rows on the 'Holdings' sheet, specifying their Account, Symbol, Asset Type, and the number of Shares. For Cash holdings use the first few rows and fill in Value instead of choosing a Symbol and number of Shares. If you add new rows make sure that Named Ranges 'HoldingValue', 'PortfolioPercent', and 'TotalValue' account for every row on the holdings page. Optionally, fill in the Expense Ratio.
6
How do I use the Watch List sheet?Use the 'Watch List' to keep notes on assets that you currently do not hold. Use the "Account Types", specified in 'List Items' to plan where you prefer to keep the assets in the Watch List, be it a tax shelter or otherwise. You can define more 'List Items' and more columns in the 'Watch List' and extend the planning functionality.
7
N.b.This is neither my Portfolio, nor is it an endorsement of any particular type of share.
8
AllocationValueAccount
9
Asset TypeTargetActualDiff
Threshold
CurrentAccount 1Account 2Account 3Account 4Account 5Account 6
10
Bonds7.00%7.00%0.00%1.75%$1,533.00$766.50$766.50$0.00$0.00$0.00$0.00
11
Canadian Equity20.00%23.69%3.69%5.00%$5,188.50$0.00$0.00$5,188.50$0.00$0.00$0.00
12
US Equity10.00%13.22%3.22%2.50%$2,895.00$0.00$0.00$0.00$2,895.00$0.00$0.00
13
International Equity15.00%13.86%-1.14%3.75%$3,036.00$0.00$0.00$3,036.00$0.00$0.00$0.00
14
Emerging Markets20.00%14.84%-5.16%5.00%$3,250.00$0.00$0.00$0.00$3,250.00$0.00$0.00
15
Alternatives0.00%0.00%0.00%0.00%$0.00$0.00$0.00$0.00$0.00$0.00$0.00
16
REITs0.00%0.00%0.00%0.00%$0.00$0.00$0.00$0.00$0.00$0.00$0.00
17
Cash28.00%27.39%-0.61%5.00%$6,000.00$1,000.00$2,000.00$3,000.00$0.00$0.00$0.00
Value Checksum
18
Total Value of Holdings
$21,902.50$1,766.50$2,766.50$11,224.50$6,145.00$0.00$0.00$21,902.50
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
Sources
39
I started with a spreadsheet from this "Dough Roller" blog post.
www.doughroller.net
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...
 
 
 
Allocations
Holdings
Watch List
List Items
 
 
Main menu