SpreadSheet Backtesting Template 23.4.2019
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
AVG WinAVG LossAVG R/RTotal PipsTotal Non-BE TradesTotal WinsTotal LossesWinning %Initial CapitalRisk Per PositionTotal Gain ($)Total Gain (%)Max DrawdownTotal T2 TradesT2 %Break EvenBreak Even (%)Danger Zone
2
2.76%1.00%2.7616011848010443.48%$10,0001.00%$20,532.41205.32%-11.94%0N/A6736.41%26.60%
3
4
Trade #MarketEntrySetupDateTimeStop LossTarget 1Target 2Result ($)Total PipsBalanceTotal Gain (%)Drawdown (%)Result (%)Risk ($)Risk (%)Flagged For ReviewDaySTATS
5
1EUR/JPY15MPullback2/3/178:15:00 pm23-23--$100.00-23$9,900.00-1.00%-1.00%-1.00%$100.001.00%ThursdayMondayTuesday
Wednesday
ThursdayFriday
Timeframes:
Markets:Setups:
Drawdown
6
2EUR/JPY15MPullback8/3/1710:45:00 pm1851-$280.5028$10,180.501.81%0.00%2.83%$99.001.00%NoWednesdayWin %N/A28.79%40.00%25.86%33.33%15MAUD/JPYPullback1.00%
7
3EUR/JPY15MPullback10/3/175:15:00 pm160-$0.0028$10,180.501.81%0.00%0.00%$101.811.00%FridayB/E %N/A28.79%21.67%34.48%21.21%1HREUR/JPY0.00%
8
4EUR/JPY15MPullback14/3/177:00:00 pm14-14--$101.8114$10,078.700.79%-1.00%-1.00%$101.811.00%NoTuesdayTotal0666058664HREUR/USD0.00%
9
5EUR/JPY15MPullback17/3/174:30:00 pm11-11--$100.793$9,977.91-0.22%-1.99%-1.00%$100.791.00%NoFridayWins019241522DailyUSD/CAD1.00%
10
6EUR/JPY15MPullback21/3/178:30:00 pm21-21--$99.78-18$9,878.13-1.22%-2.97%-1.00%$99.781.00%TuesdayLoss0282323301.99%
11
7EUR/JPY15MPullback22/3/179:45:00 am200-$0.00-18$9,878.13-1.22%-2.97%0.00%$98.781.00%WednesdayB/E0191320142.97%
12
8EUR/JPY15MPullback22/3/172:00:00 pm1544-$289.7626$10,167.891.68%-0.12%2.93%$98.781.00%Wednesday2.97%
13
9EUR/JPY15MPullback24/3/1710:30:00 pm190-$0.0026$10,167.891.68%-0.12%0.00%$101.681.00%FridaySTRATEGY0.12%
14
10EUR/JPY15MPullback29/3/1711:15:00 am21-21--$101.685$10,066.210.66%-1.12%-1.00%$101.681.00%WednesdayOverall:Pullback0.12%
15
11EUR/JPY15MPullback29/3/179:00:00 pm1717-$100.6622$10,166.871.67%-0.13%1.00%$100.661.00%WednesdayWin %31.87%N/AN/AN/AN/A1.12%
16
12EUR/JPY15MPullback30/3/171:15:00 pm13-13--$101.679$10,065.200.65%-1.13%-1.00%$101.671.00%ThursdayB/E %26.69%N/AN/AN/AN/A0.13%
17
13EUR/JPY15MPullback4/4/173:30:00 pm160-$0.009$10,065.200.65%-1.13%0.00%$100.651.00%TuesdayTotal25100001.13%
18
14EUR/JPY15MPullback4/4/177:30:00 pm32-32--$100.65-23$9,964.55-0.35%-2.12%-1.00%$100.651.00%TuesdayWins8000001.13%
19
15EUR/JPY15MPullback5/4/1712:00:00 pm16-16--$99.65-39$9,864.90-1.35%-3.10%-1.00%$99.651.00%WednesdayLoss10400002.12%
20
16EUR/JPY15MPullback6/4/1712:15:00 pm200-$0.00-39$9,864.90-1.35%-3.10%0.00%$98.651.00%NoThursdayB/E6700003.10%
21
17EUR/JPY15MPullback6/4/178:45:00 pm200-$0.00-39$9,864.90-1.35%-3.10%0.00%$98.651.00%Thursday3.10%
22
18EUR/JPY15MPullback11/4/179:45:00 am1417-$119.79-22$9,984.69-0.15%-1.92%1.21%$98.651.00%Tuesday
Timeframe:
15M3.10%
23
19EUR/JPY15MPullback11/4/173:30:00 pm110-$0.00-22$9,984.69-0.15%-1.92%0.00%$99.851.00%TuesdayPullback1.92%
24
20EUR/JPY15MPullback12/4/179:45:00 am1320-$153.61-2$10,138.301.38%-0.41%1.54%$99.851.00%WednesdayWin %31.87%N/AN/AN/AN/A1.92%
25
21EUR/JPY15MPullback12/4/176:30:00 pm19-19--$101.38-21$10,036.920.37%-1.41%-1.00%$101.381.00%WednesdayB/E %26.69%N/AN/AN/AN/A0.41%
26
22EUR/JPY15MPullback14/4/1711:00:00 am16-16--$100.37-37$9,936.55-0.63%-2.40%-1.00%$100.371.00%FridayTotal25100001.41%
27
23EUR/JPY15MPullback14/4/176:15:00 pm1458-$411.6621$10,348.213.48%0.00%4.14%$99.371.00%FridayWins800000REBALANCE2.40%
28
24EUR/JPY15MPullback18/4/1711:15:00 am17-17--$103.484$10,244.732.45%-1.00%-1.00%$103.481.00%TuesdayLoss10400000.00%
29
25EUR/JPY15MPullback18/4/1710:15:00 pm20-20--$102.45-16$10,142.281.42%-1.99%-1.00%$102.451.00%NoTuesdayB/E6700001.00%
30
26EUR/JPY15MPullback19/4/174:30:00 pm1419-$137.653$10,279.922.80%-0.66%1.36%$101.421.00%Wednesday1.99%
31
27EUR/JPY15MPullback20/4/174:15:00 pm13-13--$102.80-10$10,177.121.77%-1.65%-1.00%$102.801.00%Thursday
Timeframe:
1HR0.66%
32
28EUR/JPY15MPullback21/4/1710:45:00 am1013-$132.303$10,309.433.09%-0.37%1.30%$101.771.00%NoFridayPullback1.65%
33
29EUR/JPY15MPullback21/4/1710:00:00 pm27-27--$103.09-24$10,206.332.06%-1.37%-1.00%$103.091.00%FridayWin %N/AN/AN/AN/AN/A0.37%
34
30EUR/JPY15MPullback26/4/179:15:00 am1326-$204.132$10,410.464.10%0.00%2.00%$102.061.00%WednesdayB/E %N/AN/AN/AN/AN/A1.37%
35
31EUR/JPY15MPullback26/4/1711:45:00 am220-$0.002$10,410.464.10%0.00%0.00%$104.101.00%WednesdayTotal000000.00%
36
32EUR/JPY15MPullback2/5/178:45:00 pm13-13--$104.10-11$10,306.363.06%-1.00%-1.00%$104.101.00%TuesdayWins000000.00%
37
33EUR/JPY15MPullback3/5/171:45:00 pm7-7--$103.06-18$10,203.292.03%-1.99%-1.00%$103.061.00%WednesdayLoss000001.00%
38
34EUR/JPY15MPullback9/5/177:15:00 pm260-$0.00-18$10,203.292.03%-1.99%0.00%$102.031.00%TuesdayB/E000001.99%
39
35EUR/JPY15MPullback11/5/1711:00:00 am17-17--$102.03-35$10,101.261.01%-2.97%-1.00%$102.031.00%Thursday1.99%
40
36EUR/JPY15MPullback12/5/174:15:00 pm180-$0.00-35$10,101.261.01%-2.97%0.00%$101.011.00%Friday
Timeframe:
4HR2.97%
41
37EUR/JPY15MPullback16/5/177:45:00 pm270-$0.00-35$10,101.261.01%-2.97%0.00%$101.011.00%TuesdayPullback2.97%
42
38EUR/JPY15MPullback18/5/179:00:00 am24-24--$101.01-59$10,000.250.00%-3.94%-1.00%$101.011.00%ThursdayWin %N/AN/AN/AN/AN/A2.97%
43
39EUR/JPY15MPullback18/5/1710:45:00 am3466-$194.127$10,194.371.94%-2.08%1.94%$100.001.00%ThursdayB/E %N/AN/AN/AN/AN/A3.94%
44
40EUR/JPY15MPullback19/5/179:00:00 am20-20--$101.94-13$10,092.420.92%-3.05%-1.00%$101.941.00%FridayTotal000002.08%
45
41EUR/JPY15MPullback19/5/179:00:00 pm240-$0.00-13$10,092.420.92%-3.05%0.00%$100.921.00%FridayWins000003.05%
46
42EUR/JPY15MPullback23/5/1711:15:00 am20-20--$100.92-33$9,991.50-0.08%-4.02%-1.00%$100.921.00%TuesdayLoss000003.05%
47
43EUR/JPY15MPullback26/5/176:00:00 pm2346-$199.8313$10,191.331.91%-2.10%2.00%$99.921.00%FridayB/E000004.02%
48
44EUR/JPY15MPullback30/5/171:00:00 pm12-12--$101.911$10,089.420.89%-3.08%-1.00%$101.911.00%Tuesday2.10%
49
45EUR/JPY15MPullback1/6/179:00:00 am1113-$119.2414$10,208.662.09%-1.94%1.18%$100.891.00%Thursday
Timeframe:
Daily3.08%
50
46EUR/JPY15MPullback2/6/171:45:00 pm11-11--$102.093$10,106.571.07%-2.92%-1.00%$102.091.00%FridayPullback1.94%
51
47EUR/JPY15MPullback6/6/179:00:00 am1545-$303.2048$10,409.774.10%-0.01%3.00%$101.071.00%TuesdayWin %N/AN/AN/AN/AN/A2.92%
52
48EUR/JPY15MPullback6/6/177:15:00 pm300-$0.0048$10,409.774.10%-0.01%0.00%$104.101.00%TuesdayB/E %N/AN/AN/AN/AN/A0.01%
53
49EUR/JPY15MPullback13/6/1710:00:00 pm17-17--$104.1031$10,305.673.06%-1.01%-1.00%$104.101.00%TuesdayTotal000000.01%
54
50EUR/JPY15MPullback16/6/179:00:00 am1717-$103.0648$10,408.734.09%-0.02%1.00%$103.061.00%FridayWins000001.01%
55
51EUR/JPY15MPullback27/6/1712:45:00 pm16-16--$104.0932$10,304.643.05%-1.02%-1.00%$104.091.00%TuesdayLoss000000.02%
56
52EUR/JPY15MPullback30/6/172:00:00 pm17-17--$103.0515$10,201.592.02%-2.01%-1.00%$103.051.00%FridayB/E000001.02%
57
53EUR/JPY15MPullback30/6/178:45:00 pm21-21--$102.02-6$10,099.581.00%-2.99%-1.00%$102.021.00%Friday2.01%
58
54EUR/JPY15MPullback7/7/179:00:00 am1546-$309.7240$10,409.304.09%-0.01%3.07%$101.001.00%NoFriday
Timeframe:
2.99%
59
55EUR/JPY15MPullback7/7/178:30:00 pm190-$0.0040$10,409.304.09%-0.01%0.00%$104.091.00%FridayPullback0.01%
60
56EUR/JPY15MPullback14/7/1710:45:00 am170-$0.0040$10,409.304.09%-0.01%0.00%$104.091.00%FridayWin %N/AN/AN/AN/AN/A0.01%
61
57EUR/JPY15MPullback19/7/1712:00:00 pm1520-$138.7960$10,548.095.48%0.00%1.33%$104.091.00%WednesdayB/E %N/AN/AN/AN/AN/A0.01%
62
58EUR/JPY15MPullback19/7/179:00:00 pm1515-$105.4875$10,653.576.54%0.00%1.00%$105.481.00%WednesdayTotal000000.00%
63
59EUR/JPY15MPullback21/7/179:45:00 pm2424-$106.5499$10,760.107.60%0.00%1.00%$106.541.00%FridayWins000000.00%
64
60EUR/JPY15MPullback25/7/179:15:00 pm2020-$107.60119$10,867.708.68%0.00%1.00%$107.601.00%TuesdayLoss000000.00%
65
61EUR/JPY15MPullback2/8/1710:30:00 pm29-29--$108.6890$10,759.037.59%-1.00%-1.00%$108.681.00%WednesdayB/E000000.00%
66
62EUR/JPY15MPullback4/8/171:45:00 pm11-11--$107.5979$10,651.446.51%-1.99%-1.00%$107.591.00%Friday1.00%
67
63EUR/JPY15MPullback9/8/175:30:00 pm2424-$106.51103$10,757.957.58%-1.01%1.00%$106.511.00%WednesdayAsian OpenAsian Close1.99%
68
64EUR/JPY15MPullback15/8/172:00:00 pm140-$0.00103$10,757.957.58%-1.01%0.00%$107.581.00%TuesdayBetween9:00 am11:59 amBetween12:00 pm6:00 pm1.01%
69
65EUR/JPY15MPullback16/8/171:30:00 pm120-$0.00103$10,757.957.58%-1.01%0.00%$107.581.00%WednesdayWin %37.10%Win %28.43%1.01%
70
66EUR/JPY15MPullback17/8/171:45:00 pm14103-$791.48206$11,549.4315.49%0.00%7.36%$107.581.00%ThursdayB/E %27.42%B/E %29.41%1.01%
71
67EUR/JPY15MPullback22/8/171:00:00 pm15-15--$115.49191$11,433.9314.34%-1.00%-1.00%$115.491.00%TuesdayTotal62Total1020.00%
72
68EUR/JPY15MPullback23/8/173:00:00 pm190-$0.00191$11,433.9314.34%-1.00%0.00%$114.341.00%WednesdayWins23Wins291.00%
73
69EUR/JPY15MPullback25/8/1712:00:00 pm13-13--$114.34178$11,319.6013.20%-1.99%-1.00%$114.341.00%FridayLoss22Loss431.00%
74
70EUR/JPY15MPullback29/8/1710:00:00 am42-42--$113.20136$11,206.4012.06%-2.97%-1.00%$113.201.00%TuesdayB/E17B/E301.99%
75
71EUR/JPY15MPullback12/9/179:30:00 pm2066-$369.81202$11,576.2115.76%0.00%3.30%$112.061.00%Tuesday2.97%
76
72EUR/JPY15MPullback19/9/171:30:00 pm1444-$363.82246$11,940.0319.40%0.00%3.14%$115.761.00%TuesdayLondon Open - U.S. OpenU.S. Close - Asian Pre-Open0.00%
77
73EUR/JPY15MPullback20/9/173:15:00 pm10-10--$119.40236$11,820.6318.21%-1.00%-1.00%$119.401.00%WednesdayBetween6:00 pm11:59 pmBetween12:00 am9:00 am0.00%
78
74EUR/JPY15MPullback26/9/175:00:00 pm250-$0.00236$11,820.6318.21%-1.00%0.00%$118.211.00%TuesdayWin %32.18%Win %N/A1.00%
79
75EUR/JPY15MPullback11/10/179:00:00 am110-$0.00236$11,820.6318.21%-1.00%0.00%$118.211.00%WednesdayB/E %22.99%B/E %N/A1.00%
80
76EUR/JPY15MPullback12/10/178:15:00 pm1133-$354.62269$12,175.2521.75%0.00%3.00%$118.211.00%ThursdayTotal87Total01.00%
81
77EUR/JPY15MPullback13/10/1712:15:00 pm1337-$346.53306$12,521.7825.22%0.00%2.85%$121.751.00%FridayWins28Wins00.00%
82
78EUR/JPY15MPullback18/10/175:15:00 pm13107-$1,030.64413$13,552.4235.52%0.00%8.23%$125.221.00%WednesdayLoss39Loss00.00%
83
79EUR/JPY15MPullback19/10/1710:30:00 am150-$0.00413$13,552.4235.52%0.00%0.00%$135.521.00%ThursdayB/E20B/E00.00%
84
80EUR/JPY15MPullback20/10/171:15:00 pm160-$0.00413$13,552.4235.52%0.00%0.00%$135.521.00%Friday0.00%
85
81EUR/JPY15MPullback24/10/175:30:00 pm1339-$406.57452$13,958.9939.59%0.00%3.00%$135.521.00%Tuesday9:00 AM10:00 AM0.00%
86
82EUR/JPY15MPullback27/10/178:30:00 pm2262-$393.39514$14,352.3843.52%0.00%2.82%$139.591.00%FridayBetween9:00 am10:00 amBetween10:00 am11:00 am0.00%
87
83EUR/JPY15MPullback31/10/1710:00:00 pm1953-$400.36567$14,752.7447.53%0.00%2.79%$143.521.00%TuesdayWin %47.22%Win %26.67%0.00%
88
84EUR/JPY15MPullback3/11/1712:00:00 pm9-9--$147.53558$14,605.2146.05%-1.00%-1.00%$147.531.00%FridayB/E %27.78%B/E %20.00%0.00%
89
85EUR/JPY15MPullback3/11/177:15:00 pm13-13--$146.05545$14,459.1644.59%-1.99%-1.00%$146.051.00%FridayTotal36Total151.00%
90
86EUR/JPY15MPullback7/11/1710:00:00 am10-10--$144.59535$14,314.5743.15%-2.97%-1.00%$144.591.00%TuesdayWins17Wins41.99%
91
87EUR/JPY15MPullback7/11/174:00:00 pm90-$0.00535$14,314.5743.15%-2.97%0.00%$143.151.00%TuesdayLoss9Loss82.97%
92
88EUR/JPY15MPullback8/11/172:00:00 pm10-10--$143.15525$14,171.4241.71%-3.94%-1.00%$143.151.00%WednesdayB/E10B/E32.97%
93
89EUR/JPY15MPullback9/11/179:00:00 am1314-$152.62539$14,324.0443.24%-2.91%1.08%$141.711.00%Thursday3.94%
94
90EUR/JPY15MPullback14/11/179:00:00 am12110-$1,313.04649$15,637.0756.37%0.00%9.17%$143.241.00%Tuesday11:00 AMMidday2.91%
95
91EUR/JPY15MPullback15/11/172:00:00 pm17-17--$156.37632$15,480.7054.81%-1.00%-1.00%$156.371.00%WednesdayBetween11:00 am11:59 amBetween12:00 pm1:00 pm0.00%
96
92EUR/JPY15MPullback17/11/179:15:00 pm22131-$921.81763$16,402.5164.03%0.00%5.95%$154.811.00%FridayWin %18.18%Win %25.00%1.00%
97
93EUR/JPY15MPullback21/11/179:15:00 pm310-$0.00763$16,402.5164.03%0.00%0.00%$164.031.00%TuesdayB/E %36.36%B/E %18.75%0.00%
98
94EUR/JPY15MPullback22/11/172:00:00 pm130-$0.00763$16,402.5164.03%0.00%0.00%$164.031.00%WednesdayTotal11Total160.00%
99
95EUR/JPY15MPullback23/11/179:00:00 am110-$0.00763$16,402.5164.03%0.00%0.00%$164.031.00%ThursdayWins2Wins40.00%
100
96EUR/JPY15MPullback24/11/1711:30:00 am1416-$187.46779$16,589.9665.90%0.00%1.14%$164.031.00%FridayLoss5Loss90.00%
Loading...