Trade Reward / Risk calculator

	A	B	C	D	E	F	G	H	I	J
1	Max Loss per trade	Short or Long?	Entry	Stop	Take profit	Risk	Shares to use	R/R	potential profit/share	Potential profit
2	$10,000.00	Short	$13.000	$13.800	$6.000	$0.80	12,500.	8.75	$7.000	$87,500.000
3
4
5
6
7
8	Your max loss should stay the same from trade to trade within a given strategy			Stop price should account for any slippage				R/R = Reward / Risk -- higher is better
9
10	Instructions: Enter data in green & blue cells; position size to use is shown in Yellow cell; orange cell should not be changed
11
12
13
14	To save a copy of the spreadsheet to your Google Docs so you can edit it, click on "File" then "make a copy". To download a copy to use in Excel or OpenOffice, click on "File" then "Download as..."		Adding to full size calculator
15			Risk	Stop	Entry	Shares	1R	2R	3R	Risk
16		Goal	$1,000.00	3.8	3.6	5000	$3.40	$3.20	$3.00	-$0.20
17		Initial	$500.00	3.8	3.6	2500	$3.40	$3.20	$3.00	-$0.20
18		Add	$500.00	3.8	3.2	833	$2.60	$2.00	$1.40	-$0.60
19			New Average	$3.50
20
21			Enter data in blue boxes; Goal risk goes in top left and doesn't change from trade to trade
22					Data in grey boxes is caculated
23
24
25
26
27
28
29
30
31
32			Risk	Stop	Entry	Shares	1R	2R	3R	Risk
33			$1,000.00	4.51	3.6	1098.9	2.69	1.78	0.87	-0.91
34			$439.56	4	3.6	1098.9	3.2	2.8	2.4	-0.4
35			$560.44	4	3.2	700.55	2.4	1.6	0.8	-0.8
36			$560.44	3.44
37			In example you move stop to 4 instead of 4.51 so you can add at $3.2 an additional 700 shares for full $1k risk
38			blue boxes are your new stop and add price
39			After the add you input the new true average and new # shares in red boxes
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