Capital Gains / Loss sheet Example

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q
1	Date	Stock	Price per share	# bought / sold	Subtotal cost	Broker's Comm	Total Cost (Sub + com)
2		MSFT	200	2	400	$10	410
3
4
5
6

7
8
9
10	Date	Stock	Price Beginning	Price End	Capital Gain/loss		Date	Stock	Price Beginning	Price End	Capital Gain/loss	Date	Stock	Price Beginning	Price End	Capital Gain/loss
11		MSFT	200							41	1	2/2/2015 - 2/6/15	AAPL	41	55.2	14.2
12										50.59	4.59	2/2/2015 - 2/6/15	IBM	50.59	30.27	-20.32
13										17	-7	2/2/2015 - 2/6/15	GM	17	30.19	13.19
14
15
16
17
18
19
20	2/9/15 - 2/13/15	AAPL	150.88	156.09	5.19
21	2/9/15 - 2/13/15	IBM	152.94	150.41	-2.53
22	2/9/15 - 2/13/15	GM	30.19	32	1.81
23
24
25	Date	Stock	Price Beginning	Price End	Capital Gain/loss
26	10/12/15- 10/16/2015	apple	153.36	111.86	0.38
27	10/19/15-10/23/15	Apple	111.04	115.5	3.46
28	10/26/15-10/30/15	Apple	119.08	120.53	1.45
29
30
31	5-2-16 / 5-5-16	Apple	93.62	92.39	-1.23
32
33	4/28/2016	WMRT	69.7	20	1389.8	10
34	5-8 / 5-12	Apple	92.94
35
36	walmart		102.71
37	apple		204.35
38
39
40	4-8-12	Apple	192.56	195.56	3
41
42
43
44	Date	Stock	Price Beginning	Price End	Capital Gain/loss
45	May 3rd	AAPL	150.88	211.39	59.39
46	May 3rd	IBM	152.94	140.95	-12
47		GM	30.19	38.78	8.68
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