Sequence of Trades
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPRSUVWXYZ
1
2
3
4
5
Instructions - Risk Model and Projected Equity Curve
6
7
1. Put the starting balance in A2 on the "Outcome" sheet for each account.
8
2. Put the winning % for the system in the blue cell, C1 (may use historical or current estimate of the winning percentage).
9
Note that the actual winning % is listed in C1003, it will likely be a little different from the anticipated winning percentage, as this is based on a 'monte carlo' sample of trades.
10
3. In G1, put the percentage of the account that will be risked per trade. For this spreadsheet this is assumed constant for all trades.
11
4. In I1, put the profit multiple for the take profit point. [EXAMPLE: Stop Loss is 20 pips away, Take Profit point is 40 pips away, so Profit Multiple = 2]
12
5. The % Scratch cell indicates the % of trades that are losers after the stop loss is set to the break-even point. Obviously a higher number of is
13
break even "losses" is desirible.
14
6. You can see how changing the winning percentage, amount risked per trade, profit multiple and % scratch trades changes your equity curve at the bottom.
15
7. You may also get a new sequence of random trades from http://www.random.org/nform.html and paste them into the B column from B2. [For this
16
example, there were 1000 integers generated between 1 and 100 in one column.]
17
18
19
20
21
22
Starting Bal.
Pred Win %
Act Win %
Act % Scratch
TP Multiple
Amount Risked Per Trade
Ending BalanceMax BalanceMin Balance$100,000
23
Outcome 11000.0038.039.00%0.00%2.23.50%1.38E+061.43E+06933.95545
24
Outcome 21000.0078.075.60%0.00%0.91.00%1.01E+051.02E+05999.31997
25
Outcome 31000.0078.078.10%0.00%0.91.00%1.63E+051.65E+05995.84862
26
Outcome 41000.0055.055.90%0.00%0.955.00%3.84E-492.38E+030.0010000000
27
Outcome 52000.0030.026.90%0.00%3.05.00%2.33E+032.37E+04799.2010000000
28
Outcome 61000.0057.056.90%0.00%1.122.00%1.43E+106.43E+10535.86294
29
Outcome 72000.0030.030.40%0.00%4.05.00%6.15E+117.29E+111734.03158
30
Outcome 81000.0070.070.00%0.00%1.125.00%3.17E+393.79E+396983.6330
31
Outcome 91000.0070.067.90%0.00%1.125.00%2.70E+346.85E+341066.10148
32
Outcome 10
1000.0070.071.00%0.00%1.125.00%3.75E+413.75E+412310.7643
33
2000308
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
Loading...