So… i exported all my trades from 01.01.2019 -> 23.04.2020 from IG and placed it in a pivot table to view some results and compare it with the Detailed report stats in PRT and the findings are.. pretty shocking.
Im exporting the IG.com trade-history list called (translated) “Profit/Loss overview” and i exported the data into excel and im viewing the column called P/L (and not the one called Total which calculates your total P/L after cost is subtracted.)
What you see in the screenshot is: The difference between IG P/L on each market – PRT P/L on each market, and as you can see the difference is total -574€
Meaning that only looking at PRT detailed report, you would think I was 574€ richer than i am. Not only that but the number of trades (marked in red) where off by +\-1. This could be some sort of accident/bug or maybe related to when a trade was opened and closed compared to the dates i used for extracting the data, but 1 trade should not be effecting the stats overall so much so its pretty safe to say that the difference is significant without the +\- 1 trade.
Lets look at Wall st market as an example: From 407 trades, the difference between “IG numbers – PRT numbers” = -266 €. I trade 1€ contracts so this is a total of 266 PIPS!! difference… This is from multiple strategies.
When comparing numbers WITH all the trading related cost included, (meaning im looking at the column thats called “Total” from the IG report) the difference between IG – PRT = -377 €
Now, i understand (kind of annoying but..) that PRT cannot calculate all costs related to trading (like holding overnight etc), but thats “only” -111 € difference between “Total P/L” VS “P/L”.
Meaning still that the missing -266€ is just purely from PRT “guesstimating” your actual buy/sell price vs IG’s actual buy/sell numbers.
So what does all this mean? Well when your looking at a backtest, just know that result is actually gonna be “alot” (depending on who you ask i guess) worse. The backtest cannot be 100% trusted. Im not rich, and my trading account would have LOVED the missing -574€ total missing…
Please, check these numbers for yourself and share them here if your findings are similar to me so we can compare. Also if you think ive calculated something wrong or have questions on how i did it, let me know and ill answer you.
Step 1. Go into IG history – Download the P/L Overview list from a selected date of choice (preferebly as far back as your detailed PRT report allows you to go)
Step 2. Convert the data to excel and create a Pivot table (let me know if you need help doing this) – I needed to tweak the , vs . in excel to get the numbers right.
Step 3. In the pivot table, use “Market” in Row and Sum of P/L + Count of P/L as the Values (meaning the Sums P/L of each market + amount of trades on each market)
Step 4. Compare your IG report for each market with the detailed report from IG from each of the same markets, using the same dates as your IG report is from.
Edit: This also means if youre running multiple strategies on 1 market, IG cannot show you the true results for each strategy because it can only look at the Market as a whole and not each strategy alone. PRT can look at each strategy alone, but the numbers cannot be trusted 100%..