new testing.xlsx

	A	B	C	D	E	F
1	Valuation Date	Cust Account no	Portfolio No	Asset class	Sub-Asset Class	Value Reff
2	1/5/2021	A	A-1	Cash	Cash	183174.82
3	1/5/2021	A	A-2	Cash	Cash	0
4	1/5/2021	A	A-2	Cash	Cash	55352.33
5	1/5/2021	A	A-2	Cash	Cash	-66796.45
6	1/5/2021	A	A-2	Cash	Cash	-149711.51
7	1/5/2021	B	B-1	Cash	Cash	112997.65
8	1/5/2021	B	B-1	Cash	Cash	346034.61
9	1/5/2021	A	A-2	Equities	Stocks	19156.72
10	1/5/2021	A	A-2	Equities	Stocks	106383.6
11	1/5/2021	A	A-1	Fixed Income	Bonds	206566.67
12	1/5/2021	A	A-1	Fixed Income	Bonds	315458.33
13	1/5/2021	B	B-1	Fixed Income	Bonds	315458.33
14	1/5/2021	A	A-1	Alternatives	Funds	205649.52
15	1/5/2021	A	A-1	Alternatives	Funds	313637.84
16	1/5/2021	B	B-1	Fixed Income	Bonds	205468.06
17	1/5/2021	B	B-1	Fixed Income	Bonds	200174.9
18	1/5/2021	A	A-1	Alternatives	Funds	842065.51
19	1/5/2021	A	A-2	Equities	Derivatives	197000
20	1/5/2021	A	A-2	Equities	Derivatives	284562.6
21	1/5/2021	A	A-2	Equities	Derivatives	201280
22	1/5/2021	A	A-2	Equities	Derivatives	199540
23	1/5/2021	B	B-1	Equities	Derivatives	1359969
24	1/5/2021	A	A-2	Equities	Derivatives	199380
25	1/5/2021	A	A-2	Equities	Derivatives	258205.15
26	1/5/2021	A	A-2	Equities	Derivatives	189460
27	1/5/2021	A	A-2	Loan	Liabilities	-146050.74
28	1/5/2021	A	A-2	Alternatives	Derivatives	-96.98
29	1/5/2021	A	A-2	Alternatives	Derivatives	-1799.22
30	1/5/2021	A	A-2	Alternatives	Derivatives	-11043.25
31	1/5/2021	A	A-2	Alternatives	Derivatives	-10981.5
32	2/6/2021	A	A-1	Cash	Cash	183174.82
33	2/6/2021	A	A-2	Cash	Cash	0
34	2/6/2021	A	A-2	Cash	Cash	55616.08
35	2/6/2021	A	A-2	Cash	Cash	-66795.59
36	2/6/2021	A	A-2	Cash	Cash	-548331.51
37	2/6/2021	B	B-1	Cash	Cash	113139.22
38	2/6/2021	B	B-1	Cash	Cash	346034.69
39	2/6/2021	A	A-2	Equities	Stocks	19175.2
40	2/6/2021	A	A-2	Equities	Stocks	107532
41	2/6/2021	A	A-1	Fixed Income	Bonds	206595.83
42	2/6/2021	A	A-1	Fixed Income	Bonds	315500
43	2/6/2021	B	B-1	Fixed Income	Bonds	315500
44	2/6/2021	A	A-1	Alternatives	Funds	205649.52
45	2/6/2021	A	A-1	Alternatives	Funds	313637.84
46	2/6/2021	B	B-1	Fixed Income	Bonds	205511.11
47	2/6/2021	B	B-1	Fixed Income	Bonds	200738.36
48	2/6/2021	A	A-1	Alternatives	Funds	842065.51
49	2/6/2021	A	A-2	Equities	Derivatives	196840
50	2/6/2021	A	A-2	Equities	Derivatives	281513.1
51	2/6/2021	A	A-2	Equities	Derivatives	201280
52	2/6/2021	A	A-2	Equities	Derivatives	199540
53	2/6/2021	B	B-1	Equities	Derivatives	1402992
54	2/6/2021	A	A-2	Equities	Derivatives	198540
55	2/6/2021	A	A-2	Equities	Derivatives	258201.82
56	2/6/2021	A	A-2	Equities	Derivatives	189460
57	2/6/2021	A	A-2	Equities	Derivatives	198620
58	2/6/2021	A	A-2	Equities	Derivatives	200000
59	2/6/2021	A	A-2	Loan	Liabilities	-146056.37
60	2/6/2021	A	A-2	Alternatives	Derivatives	-78.13
61	2/6/2021	A	A-2	Alternatives	Derivatives	-1610.91
62	2/6/2021	A	A-2	Alternatives	Derivatives	-14064.4
63	2/6/2021	A	A-2	Alternatives	Derivatives	-11746.61
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