Workspace / Research tools
Data analysis

Trade Journal Analyzer: Expectancy and Drawdown

Find out what a completed trade sample actually earned after its recorded costs. Provide rows containing timestamp, gross_pnl and fees, plus the starting equity used to reconstruct the account curve. Each row should represent one closed trade, not an individual order fill. The analyzer includes break-even trades in its sample count and keeps their contribution distinct from wins and losses. Processing stays in your browser, including file reading. The example button loads illustrative records; there is no account connection or automatic trade import.

Explicit assumptionsFormula & methodology includedNo account required

Enable JavaScript to analyze data in this browser. The methodology and worked example remain available below.

Worked example — illustrative data
Net closed-trade P&L$247.00
Win rate including break-even trades60%
Net expectancy per trade$49.40
Closed-trade equity maximum drawdown0.77%
Total fees$18.00
Profit factor2.75
Net trade = gross P&L − fees. Profit factor = net winning P&L / absolute net losing P&L. Drawdown uses running closed-trade equity peaks.

One row per completed trade in chronological order. Open P&L, deposits, withdrawals and intratrade drawdown are excluded. Break-even trades count in the win-rate denominator. Profit factor is undefined when there are no net losing trades.

Close timestampGross P&LFeesNet P&LClosed-trade equity
2025-01-01T12:00:00.000Z120411610116
2025-01-02T12:00:00.000Z-753-7810038
2025-01-03T12:00:00.000Z200519510233
2025-01-04T12:00:00.000Z-603-6310170
2025-01-05T12:00:00.000Z8037710247

Define one comparable trade per row

The field gross_pnl represents signed trading profit or loss before the fee column is deducted. A losing trade therefore needs a negative value. Net trade result equals gross_pnl minus fees. Do not import an exchange field that already includes commissions and subtract those commissions again. Use one quote currency for every row. Aggregate partial closes into the trade definition you intend to measure, and include all closed trades in the period rather than selecting only successful setups.

Calculate returns without discarding zeros

Win rate is the number of positive net trades divided by all accepted trades, including zero results. Average net expectancy is total net result divided by that same count. Profit factor divides the sum of positive results by the absolute sum of negative results. When there are no losses, that ratio is not a reliable finite performance estimate. Break-even trades affect sample size and win rate even though they add nothing to total profit. Costs can also turn a gross winner into a net loser.

Reconstruct the equity path

Starting equity plus cumulative chronological net results gives the modeled closed-trade equity curve. Drawdown measures its decline from an earlier running peak, including initial equity as the first reference. This curve cannot reveal losses that occurred while trades remained open. Deposits, withdrawals, funding and interest require consistent treatment before results resemble an actual account statement. A profitable short sample can reflect chance or selection. Use the output to inspect records and compare defined samples, not to extrapolate a guaranteed income.

Your research workspace

Save selected inputs and research notes explicitly in this browser. Compare assumptions and restore a saved setup without submitting a trade. JavaScript enables the controls.

Find a tool or explanation