ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASAT
1
BASIC (LITE) BACKTESTING SPREADSHEET - NOT THE FULL VERSION. STRATEGY DETAILS (fill this in for each new strategy): For example, 2024 Long Short Trend 3RRR+ Trailing & Daily Re-Fills Post Costs | Variable RRR| No Scaling | No News days or Holidays
2
DayJanFebMarAprMayJuneJulAugSeptOctNovDecINPUTSOUTPUTS
3
1
4
2
5
3Average Risk to Reward Ratio RRRMax Cumulative Loss (Backtest) [R]Yearly [R]Expectancy [R]Costs (Total)
6
400.00#DIV/0!#DIV/0!
7
5Maximum Drawdown for Blowup [%]Total TradesMonths TradedCosts (No Slippage)
8
68000#DIV/0!
9
7Human ErrorTotal WinsDaily Expectancy [R]Risk Per Trade Assuming Double the Max Cumulative Loss [%]
10
80.010#DIV/0!#DIV/0!
11
9Minimum Stoploss [points]Winrate (Backtest) [%]Average Number of Trades per Month
12
103#DIV/0!#DIV/0!
13
11Average Spread [points]Slippage [points]Daily Winrate (Backtest) [%]Average Winning Day
14
120.60.1#DIV/0!#DIV/0!
15
13Breakeven Winrate (Backtest) [%]Average Losing Day
16
14100.00%#DIV/0!
17
15Number of Losing DaysNumber of Winning Days
18
1600
19
17Maximum Risk Per Trade [%]No Position Days
20
18#DIV/0!0
21
19
22
20
23
21
24
22
25
23
26
24
27
25
28
26
29
27
30
28
31
29
32
30
33
31
34
SHORT/LONG RETURN [R]000000000000000000000000
35
SHORT/LONG MAX DD [R] 000000000000000000000000
36
RETURN TOTAL [R] 000000000000
37
DRAWDOWN TOTAL [R]000000000000
38
39
DO NOT ALTER THE DATA/TABLE BELOW THIS LINE ONLY ALTER WHAT IS ABOVE!
40
DayJanFebMarAprMayJuneJulAugSeptOctNovDec
41
1000000000000000000000000
42
2000000000000000000000000
43
3000000000000000000000000
44
4000000000000000000000000
45
5000000000000000000000000
46
6000000000000000000000000
47
7000000000000000000000000
48
8000000000000000000000000
49
9000000000000000000000000
50
10000000000000000000000000
51
11000000000000000000000000
52
12000000000000000000000000
53
13000000000000000000000000
54
14000000000000000000000000
55
15000000000000000000000000
56
16000000000000000000000000
57
17000000000000000000000000
58
18000000000000000000000000
59
19000000000000000000000000
60
20000000000000000000000000
61
21000000000000000000000000
62
22000000000000000000000000
63
23000000000000000000000000
64
24000000000000000000000000
65
25000000000000000000000000
66
26000000000000000000000000
67
27000000000000000000000000
68
28000000000000000000000000
69
29000000000000000000000000
70
30000000000000000000000000
71
31000000000000000000000000
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