Excel Backtesting

MQL5 Scripts Other

Specification

I need an excel backtesting code that can run through O, H, L, C and check for a given TP and SL.

 

My technical knowledge lacks somewhat, so I do not know if this is possible with IF funcitons, or if a macro or something is needed...


From any given price point of my choosing I would like the the code to check thorugh the prices from that point onwards, and find where it hits the given SL or TP.

 

Please see my excel for what I want. 

 

I will determine Entrys by plotting MACD indicator onto the excel, then use IF functions to determine whether to trade. I would need to be able to copy the formula across the whole column, I do not want to have to do it individually each time.

 

Let me know if initerested, thanks 

Responded

1
Developer 1
Rating
(164)
Projects
218
50%
Arbitration
6
17% / 67%
Overdue
11
5%
Free
2
Developer 2
Rating
(29)
Projects
49
22%
Arbitration
14
29% / 21%
Overdue
13
27%
Free
3
Developer 3
Rating
(12)
Projects
17
35%
Arbitration
1
0% / 100%
Overdue
3
18%
Free
4
Developer 4
Rating
(195)
Projects
395
28%
Arbitration
155
20% / 52%
Overdue
112
28%
Free
5
Developer 5
Rating
(49)
Projects
134
27%
Arbitration
62
13% / 53%
Overdue
58
43%
Free
Published: 313 articles, 1 code
6
Developer 6
Rating
(31)
Projects
81
83%
Arbitration
1
0% / 0%
Overdue
29
36%
Free
7
Developer 7
Rating
Projects
0
0%
Arbitration
0
Overdue
0
Free

Project information

Budget
10 - 40 USD
Deadline
1 day(s)