MT4 to Excel through Excel RTD (Finally!)

Quoting garfield75

Disliked

{quote} I have introduced TradeID to match Entry with SL/TP. (macro in the attachment) Since market range and multiple trades can be open in one or both direction, sometimes TP or SL are hit at the same time for more than 1 trades. in the attached excel Tradeid 2 & 3 SL hit at the same time (on row 133) and it recorded a Loss for Trade 3. Not sure how to solve the PIP count of the loss here, its recorded 15, where it should have recorded 30 pips for that. {file}

Ignored

Quoting nicholas87

Disliked

{quote} THANK YOU

Ignored

Quoting garfield75

Disliked

{quote} @mtharwat - Please use attached V2 for testing. Column "R" now amends comment to capture if more than 1 trade closed on the same line/timeframe and TP/SL pip count also captures the same. {file}

Ignored

Quoting mtharwat

Disliked

{quote} Thanks, Garfield. You are a true champ.. I am attaching a small test report for random 10 pairs. The percentages were 0.2 Percent. I think I may open a new account and fund it for the purpose of testing all pairs. Or go demo for 28 pairs.. {file} {image}

Ignored

Quoting garfield75

Disliked

{quote} That is a good result. Should work well with trending pairs, non-trending pairs have low pip count. trading just EUR and GBP pairs would be more than enough. Did you try with JPY Pairs to see the result?

Ignored

Quoting mtharwat

Disliked

@Garfield I have done the JPY test... Now I want to check something with you. With the non-Yen pairs list, I should have divided the net profit by 10 to get the pips count. Then I added Yen pairs and divided them by 100 to get pips count. So I made another report with yen pairs and adjusted Pip count. The last Blue column is the theoretical pip gained per month as sometimes the test period (no of bars) differ. {image} {file}

Ignored

Quoting garfield75

Disliked

{quote} No sure if that is accurate. Why did you divided non-yen pair with 10 to get the pip count?

Ignored

Quoting mtharwat

Disliked

{quote} Ok, Recalculated the yen pairs profit by dividing it by 100. And left the other non-Yen pairs without any divisor. Is this correct? {image} {file}

Ignored

Quoting garfield75

Disliked

{quote} Seems to be rights based on the excel. All JPY pair had 17144 bars?

Ignored

Quoting mtharwat

Disliked

@Garfield, I tested many pairs for almost three hours. There is something with the VBA calculation. I tested many pairs with different percentages. When I go back to the best percentage, everything was fine and the results were the same. However, after I went through many pairs and went back to the first couple of pairs to retest something else, the results did not match. The same percentage and criteria I used as in the previous test on the same pair and results do not match. I do not understand why? 1-The number of trades differs. 2-the VBA (pop...

Ignored

Quoting garfield75

Disliked

{quote} Is it happening with all pairs or only some specific pairs? Can you attched couple of files with data to run/check.

Ignored

Quoting mtharwat

Disliked

{quote} It was not specific to any pair. Attached some of the Data I was testing. {file}

Ignored

Quoting garfield75

Disliked

{quote} Hey mtharwat, Before you hit "click me" button please make sure the all row for column Q, R , S & T are empty. if these are not empty then your numbers will get screwed up on re-run for a pair, which is what you are experiencing right now, because of the of the rows are amended with the result from previous count. This makes the P&L go up. Cheers

Ignored

Quoting mtharwat

Disliked

{quote} Hey Garfield, I forgot to add that I was doing this every single time with every change of percentage and pair. This is not the problem causing miscalculation. I made sure the three cells calculating Profit/loss/Net were zeroed. Cheers,

Ignored

Quoting garfield75

Disliked

{quote} I did 3 pairs 5 times each. All had same result. Question - are you doing a copy & paste of the data from for each pair from another sheet to the backtesting template?

Ignored

Quoting mtharwat

Disliked

{quote} Yes sir

Ignored

Quoting garfield75

Disliked

{quote} Cool. Next question You copy & paste column A to G from Row 5 onward. Do you then check column I to P has same number of rows with formula, same as row A to G? Add or Delete rows as required to match them?

Ignored

Quoting mtharwat

Disliked

{quote} Yes, all columns are extended to the last row. I am attaching GBOUSD and USDCAD. I first tested each one after another. Not the same one over. Alternated between them. The first two rounds, they matched. In the third round, they differed. Regardless, Test them and tell me what results did you get. Another thing is that the row count is in VBA (Pop up message) is a bit higher than the actual row number being tested. Would that cause an issue in the calculations? PM me instead so we come back here with a final conclusion. Cheers, {file} {file}...

Ignored