StockBrokers.com Trading Journal Template

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	T	U
1
2							KEY
3								you enter info here
4							1234	This is calculated
5							1234	Trading metrics
6
7
8
9	To make a copy and start using this template click File - Make A Copy. The more up-to-date you keep your trading journal, the more valuable it will be. Modify this as you see fit so you capture what's important to you, whether it's your mood, the state of the market, a particular strategy you are using, etc. I've also added a tab for your educational activities.							TRADING METRICS
10								Average reward/risk ratio		#DIV/0!	Total profit/loss	$59,854.00	Average days held	0.05
11								Wins		2	Average profit	$606.06
12								Losses		98	Average loss	-$146.00
13								Win/Loss ratio		0.02040816327	Profit/loss ratio	4.15
14	note: write your own trades over these (fictitious) examples.
15	TRADE INFO											STRATEGY					EVALUATION
16	Trade #	Entry date	Ticker	Quantity	Price	Entry $$	Exit date	Exit $$	Profit/loss	Days		Protective stop	Target	Reward to risk	Strategy	Conviction	Comment	Won/Lost	Lesson learned
17	1	12/15/2022	AAPL	-1000	130	$130,000.00	12/19/2022	-$100,000.00	$30,000.00	4		$140.00	$100.00	3	Neg mkt momentum	high	Won	W	The trend is your friend
18	2	12/29/2022	AAPL	1000	100	-$100,000.00	12/30/2022	$130,000.00	$30,000.00	1		$90.00	$140.00	4	Point and figure	medium	Bailed out early	W	Stick with the winners
19	3	12/30/2022	NVDA	1000	140.36	-$140,038.00	12/30/2022	$139,892.00	-$146.00	0		$138.00	$145.00	1.97	Pos stk momentum	medium	Impulsive	L	Want more conviction
20	4								$0.00	0				#DIV/0!				L
21	5								$0.00	0				#DIV/0!				L
22	6								$0.00	0				#DIV/0!				L
23	7								$0.00	0				#DIV/0!				L
24	8								$0.00	0				#DIV/0!				L
25	9								$0.00	0				#DIV/0!				L
26	10								$0.00	0				#DIV/0!				L
27	11								$0.00	0				#DIV/0!				L
28	12								$0.00	0				#DIV/0!				L
29	13								$0.00	0				#DIV/0!				L
30	14								$0.00	0				#DIV/0!				L
31	15								$0.00	0				#DIV/0!				L
32	16								$0.00	0				#DIV/0!				L
33	17								$0.00	0				#DIV/0!				L
34	18								$0.00	0				#DIV/0!				L
35	19								$0.00	0				#DIV/0!				L
36	20								$0.00	0				#DIV/0!				L
37	21								$0.00	0				#DIV/0!				L
38	22								$0.00	0				#DIV/0!				L
39	23								$0.00	0				#DIV/0!				L
40	24								$0.00	0				#DIV/0!				L
41	25								$0.00	0				#DIV/0!				L
42	26								$0.00	0				#DIV/0!				L
43	27								$0.00	0				#DIV/0!				L
44	28								$0.00	0				#DIV/0!				L
45	29								$0.00	0				#DIV/0!				L
46	30								$0.00	0				#DIV/0!				L
47	31								$0.00	0				#DIV/0!				L
48	32								$0.00	0				#DIV/0!				L
49	33								$0.00	0				#DIV/0!				L
50	34								$0.00	0				#DIV/0!				L
51	35								$0.00	0				#DIV/0!				L
52	36								$0.00	0				#DIV/0!				L
53	37								$0.00	0				#DIV/0!				L
54	38								$0.00	0				#DIV/0!				L
55	39								$0.00	0				#DIV/0!				L
56	40								$0.00	0				#DIV/0!				L
57	41								$0.00	0				#DIV/0!				L
58	42								$0.00	0				#DIV/0!				L
59	43								$0.00	0				#DIV/0!				L
60	44								$0.00	0				#DIV/0!				L
61	45								$0.00	0				#DIV/0!				L
62	46								$0.00	0				#DIV/0!				L
63	47								$0.00	0				#DIV/0!				L
64	48								$0.00	0				#DIV/0!				L
65	49								$0.00	0				#DIV/0!				L
66	50								$0.00	0				#DIV/0!				L
67	51								$0.00	0				#DIV/0!				L
68	52								$0.00	0				#DIV/0!				L
69	53								$0.00	0				#DIV/0!				L
70	54								$0.00	0				#DIV/0!				L
71	55								$0.00	0				#DIV/0!				L
72	56								$0.00	0				#DIV/0!				L
73	57								$0.00	0				#DIV/0!				L
74	58								$0.00	0				#DIV/0!				L
75	59								$0.00	0				#DIV/0!				L
76	60								$0.00	0				#DIV/0!				L
77	61								$0.00	0				#DIV/0!				L
78	62								$0.00	0				#DIV/0!				L
79	63								$0.00	0				#DIV/0!				L
80	64								$0.00	0				#DIV/0!				L
81	65								$0.00	0				#DIV/0!				L
82	66								$0.00	0				#DIV/0!				L
83	67								$0.00	0				#DIV/0!				L
84	68								$0.00	0				#DIV/0!				L
85	69								$0.00	0				#DIV/0!				L
86	70								$0.00	0				#DIV/0!				L
87	71								$0.00	0				#DIV/0!				L
88	72								$0.00	0				#DIV/0!				L
89	73								$0.00	0				#DIV/0!				L
90	74								$0.00	0				#DIV/0!				L
91	75								$0.00	0				#DIV/0!				L
92	76								$0.00	0				#DIV/0!				L
93	77								$0.00	0				#DIV/0!				L
94	78								$0.00	0				#DIV/0!				L
95	79								$0.00	0				#DIV/0!				L
96	80								$0.00	0				#DIV/0!				L
97	81								$0.00	0				#DIV/0!				L
98	82								$0.00	0				#DIV/0!				L
99	83								$0.00	0				#DIV/0!				L
100	84								$0.00	0				#DIV/0!				L