Excel Backtesting

MQL5 Experts Scripts

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 

 Cannot upload excel, I can send personally if needed. 

Responded

1
Developer 1
Rating
(61)
Projects
120
34%
Arbitration
17
18% / 41%
Overdue
51
43%
Free
2
Developer 2
Rating
(49)
Projects
134
27%
Arbitration
62
13% / 53%
Overdue
58
43%
Free

Project information

Budget
10 - 40 USD
For the developer
9 - 36 USD
Deadline
1 day(s)