Your backtest profit sum is missing commission and swap

2 November 2026, 23:07
Jevon Naldo Yoshield
0
19

The Profit column holds the trade's price result only; commission and swap are separate columns. On a gold report I opened (XAUUSD.pc), closing deals total 59.58 in Profit against the printed 72.33. The 12.75 gap is Swap; commission is 0.00.

Raw-spread accounts break it a second way: commission is booked on the entry deal, so costs on closing rows alone land off by exactly the entry commission, 25.85 on one report and 1,884.30 on another. The sum must cover every trade row.

Across 37 reports, Profit alone matched the net on 16. Closing-row sums matched 31, trade-row sums 36; one failure has a single deal row against 1,336 printed, a truncated export. The 12.75 gap is 17.6% of the gold report's net, its swap share, not a constant. With no swap, that part is zero.

Total Net Profit should equal last Balance minus initial deposit. On 8,710 rows, balance delta matched profit plus commission plus swap with 0 mismatches. A mismatch means an incomplete export or a shifted column, so its totals cannot be trusted.