It’s important to understand that the trades table is not affected by trade settings such as Gross/Net, R Multiple, Close Date, Open Date, or Transaction Date. The trades table is intended to serve as a log of all your trades, whereas the widgets and reports are influenced by these settings. For instance, if you choose not to include open trades’ PnL in your reports, it doesn’t mean that open trades will be hidden from the trades table — they will still be visible because hiding them would be illogical.
Below are some scenarios where the PnL shown on the trades table might not match the PnL in the reports.
Net vs. Gross vs. R Multiple Reports
If your trade settings are configured to report PnL based on “Close Date” or “Open Date,” ensure that you are comparing widgets that report Net Results against the trades column labeled “PnL Net $” (or “PnL Net %“). To compare Gross results, refer to the column labeled “PnL Gross $” (or “PnL Gross %“) under the trades table, which reports the total return of the trade in gross. You can switch which basis your reports use from the “$” icon in the top toolbar (Gross/Net and Currency/R Multiple).
Transaction Date
If you’ve chosen to report based on Transaction Date and have trades with partial realized gains on different dates, note that this setting only affects “Accumulative Return $” and “Account Balance” — every other report metric still uses Close Date. For those two metrics, the PnL in the trades column may not match the widgets, because the trades table is designed to report the total PnL of the trade, while these metrics are more granular and reflect the per-transaction breakdown.
This discrepancy is intentional. As traders, when viewing a trade from a high-level perspective, we typically want to know the overall profit or loss from the trade, not the PnL for a specific date/transaction. To see how much was made on a trade for a particular date, simply click on the trade to view partial returns.
Excluding Open Trades from Reports
Under Settings → Trades, the “Consider Partial Realized Gains” option controls whether the system factors in PnL from partial closes on open trades when calculating your report totals. Turning it off does not mean the trades table will hide the trade — it will still display the open trade and its associated PnL there; only the widgets and reports will exclude it. This behavior is intentional.