Portfolio Live v1p3

	A	B	C	D	E	F	G	I	J	K	L	N	O	Q	R	S	T	U	V	W	Y	Z	AA	AB	AC	AE	AF	AG	AH	AI	AM	AN	AO	AP	AR	AS	AT	AU	AV	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CB	CC
1	Funds and Portfolio %							Current Holdings				Prices		Target % by Account							Portfolio Value ($k)					Buy / Sell ($k)					Calculations
2			Target	Force No Sales (1=no sales)					Cash ($)			Price	Price						Actual	After											Portfolio Calculation					Minimum Portfolio % Due to No Sell Flag				Calculation of Portfolio by Account
3			(%)	RRSP	TFSA	Taxable	Other	RRSP	TFSA	Taxable	Other	Quote	($ CDN)	RRSP	TFSA	Taxable	Other	Total	Percent	Trades	RRSP	TFSA	Taxable	Other	Total	RRSP	TFSA	Taxable	Other	Total
4	Total ($k or %) ->		100.0%											55.5%	24.3%	20.1%		100.0%	100.0%	100.0%	63.8	28.0	23.1		114.8	(0.0)	0.0	0.0	(0.0)			1.000

5	Cash	CAD		0	0	1	0	14400	5500	3000		1	1.00						19.9%		14.4	5.5	3.0		22.9	-14.4	-5.5	-3.0		-22.9	0.17	0.83	0.83	1.00		RRSP	TFSA	Taxable	Other	RRSP						55.5%	0.0%		TFSA						24.3%	0.0%		Taxable						2.6%	17.5%		Other
6		USD										1	1.41																			Above	Ratio	Final		Min	Min	Min	Min		Remaining	Used	Rank	Rank	Remaining	Used	Min	Used		Remaining	Used	Rank	Rank	Remaining	Used	Min	Used		Remaining	Used	Rank	Rank	Remaining	Used	Min	Used		Used
7	List of Asset Classes		Target	Class Rank (1, 2, 3, ... )					Value																						Min	Min	Above	Port	Fund #	Portfolio	Portfolio	Portfolio	Portfolio	Fund #	Portfolio	Portfolio	Order	Order	Portfolio	Portfolio	Portfolio	Portfolio	Fund #	Portfolio	Portfolio	Order	Order	Portfolio	Portfolio	Portfolio	Portfolio	Fund #	Portfolio	Portfolio	Order	Order	Portfolio	Portfolio	Portfolio	Portfolio	Fund #	Portfolio
8	Asset Class Name		(%)	RRSP	TFSA	Taxable	Other	RRSP	TFSA	Taxable	Other
9	Bond		25.0%	1	1	1	1	9.9				1	1	25.0%				25.0%	8.7%	25.0%	9.9				9.9	18.8				18.8	0.00	0.25	0.25	0.25	1	0.00	0.00	0.00	0.00	1	0.250	0.250	1	1	0.250	0.250	0.000	0.250	1	0.000	0.000	1	1	0.000	0.000	0.000	0.000	1	0.000	0.000	1	1	0.000	0.000	0.000	0.000	1	0.000
10	US		30.0%	3	3	3	3	27.1	6.8			1	1	19.1%	10.9%			30.0%	29.5%	30.0%	27.1	6.8			33.9	-5.1	5.7			0.6	0.00	0.30	0.30	0.30	2	0.00	0.00	0.00	0.00	2	0.300	0.191	3	3	0.114	0.114	0.000	0.114	2	0.109	0.109	3	3	0.000	0.000	0.000	0.000	2	0.000	0.000	3	3	0.000	0.000	0.036	0.036	2	0.000
11	INTL		15.0%	2	2	2	2	12.4		4.1		1	1	11.4%		3.6%	-0.0%	15.0%	14.4%	15.0%	12.4		4.1		16.5	0.7			-0.0	0.7	0.04	0.11	0.11	0.15	3	0.00	0.00	0.04	0.00	3	0.114	0.114	2	2	0.300	0.191	0.000	0.191	3	0.000	0.000	2	2	0.109	0.109	0.000	0.109	3	0.000	0.036	2	2	0.000	0.000	0.000	0.000	3	0.000
12	CDN		30.0%	4	4	4	4		15.7	16.0		1	1		13.5%	16.5%		30.0%	27.6%	30.0%		15.7	16.0		31.7		-0.2	3.0		2.8	0.14	0.16	0.16	0.30	4	0.00	0.00	0.14	0.00	4	0.161	0.000	4	4	0.161	0.000	0.000	0.000	4	0.161	0.135	4	4	0.161	0.135	0.000	0.135	4	0.026	0.165	4	4	0.026	0.026	0.139	0.165	4	0.000
13												1	1																		0.00	0.00	0.00	0.00	5	0.00	0.00	0.00	0.00	5	0.000		#N/A	5	0.000	0.000	0.000	0.000	5	0.000		#N/A	5	0.000	0.000	0.000	0.000	5	0.000		#N/A	5	0.000	0.000	0.000	0.000	5	0.000
14												1	1																		0.00	0.00	0.00	0.00	6	0.00	0.00	0.00	0.00	6	0.000		#N/A	6	0.000	0.000	0.000	0.000	6	0.000		#N/A	6	0.000	0.000	0.000	0.000	6	0.000		#N/A	6	0.000	0.000	0.000	0.000	6	0.000
15												1	1																		0.00	0.00	0.00	0.00	7	0.00	0.00	0.00	0.00	7	0.000		#N/A	7	0.000	0.000	0.000	0.000	7	0.000		#N/A	7	0.000	0.000	0.000	0.000	7	0.000		#N/A	7	0.000	0.000	0.000	0.000	7	0.000
16												1	1																		0.00	0.00	0.00	0.00	8	0.00	0.00	0.00	0.00	8	0.000		#N/A	8	0.000	0.000	0.000	0.000	8	0.000		#N/A	8	0.000	0.000	0.000	0.000	8	0.000		#N/A	8	0.000	0.000	0.000	0.000	8	0.000
17												1	1																		0.00	0.00	0.00	0.00	9	0.00	0.00	0.00	0.00	9	0.000		#N/A	9	0.000	0.000	0.000	0.000	9	0.000		#N/A	9	0.000	0.000	0.000	0.000	9	0.000		#N/A	9	0.000	0.000	0.000	0.000	9	0.000
18												1	1																		0.00	0.00	0.00	0.00	10	0.00	0.00	0.00	0.00	10	0.000		#N/A	10	0.000	0.000	0.000	0.000	10	0.000		#N/A	10	0.000	0.000	0.000	0.000	10	0.000		#N/A	10	0.000	0.000	0.000	0.000	10	0.000
19	List of Funds & Stocks		USD?		Units (#)				Value
20	Select Class	Symbol	(y/n)	RRSP	TFSA	Taxable	Other	RRSP	TFSA	Taxable	Other
21	Bond	TSE:XBB		350				9.9				28.42	28.42
22	US	TSE:XSP		400	100			27.1	6.8			67.71	67.71
23	INTL	TSE:XIN		300		100		12.4		4.1		41.20	41.20
24	CDN	TSE:XIU			350	300			15.7	13.4		44.83	44.83
25	CDN	TSE:CVE				100				2.5		25.20	25.20
26												#N/A	0.00
27												#N/A	0.00
28												#N/A	0.00
29												#N/A	0.00
30												#N/A	0.00
31												#N/A	0.00
32												#N/A	0.00
33												#N/A	0.00
34												#N/A	0.00
35												#N/A	0.00
36												#N/A	0.00
37												#N/A	0.00
38												#N/A	0.00
39												#N/A	0.00
40												#N/A	0.00
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