Stock market recording sheet.xlsx

	A	B	C	D	E	F	G	H	I
1	Stock Market Recording Sheet						Name:
2							Date:
3
4	Stock Name	# of Shares	Original Investment	Closing/Purchase Price Per Share	Change	Today's Total Value (Closing Price x Number of Shares)	Profit (Today's Value - Original Investment)	Investment Fee	Buy or Sell
5	Tsla	10	$2,360.80	$236.08	$0.00	$2,360.80	$0.00	$7.00	Buy
6	BRIT	10	$2,100.00	$210.00	$0.00	$2,100.00	$0.00	$7.00	Buy
7
8
9
10
11
12
13
14		10,000-2360.80-2100.00-7-7+0
15	Cash left over = cash from previous day - new investments - new investment fees + sale of any stocks							$5,532.20
16		7632.2+2360.8
17	Equity = cash left over + today's total value (of stocks that you own)							$9,986.00
18
19
20
21
22
23
24
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