PipGauge

Home › Calculators › Journal Analyzer

CSV Trade Journal Analyzer

Turn a CSV export from your trading journal or broker into the core performance stats, entirely inside your browser.

Direct answer

This trade journal analyzer reads a CSV of your closed trades and computes win rate, profit factor, expectancy, average win and loss, payoff ratio, largest win and loss, longest winning and losing streaks, and maximum drawdown on the cumulative P&L curve. The file is parsed with your browser's FileReader and never leaves your device — nothing is uploaded to a server.

Trade log input

Your CSV is parsed inside this browser tab. The file is not uploaded to a server.
Use a trade export with a P&L, profit, net or result column.
Auto-detect looks for pnl, p&l, profit, net or result. Choose manually if your export uses another name.
The example includes a quoted symbol field with a comma.
Paste or upload a CSV to analyze closed-trade P&L.

Journal stats

Net P&L—
Win rate—
Profit factor—
Expectancy per trade—
Payoff ratio—
Max drawdown $—
Wins / losses / total—
Max consecutive W / L—
Gross profit / gross loss—

Equity curve from cumulative P&L

The curve starts at 0 and adds each parsed trade P&L in file order.
Trade-cost check

See what a real trade would cost you

Before you place this, compare brokers on the one number that matters — the all-in cost of spread and commission — using our open, for-sale-proof methodology.

Compare broker trading costs →

Disclosure. Some outbound links may be affiliate links; they never change a calculator’s result. How we make money.

Risk warning. CFDs are complex instruments and carry a high risk of losing money rapidly due to leverage. A significant proportion of retail investor accounts lose money when trading CFDs; where a broker publishes an official percentage, we show it only with the source and capture date. Consider whether you understand how CFDs work and can afford the risk. Full risk disclosure.

Educational tools for non-US traders · not directed at US persons.

How it works

What it reads

The analyzer needs one thing: a column of per-trade profit and loss. It auto-detects a header named like PnL, P&L, Profit, Net or Result; if it cannot find one, you pick the column yourself. Quoted fields that contain commas (such as a symbol written "EUR, USD") are handled, and rows whose P&L cell is not a number are skipped and counted rather than crashing the run.

The statistics

  • Win rate = winning trades ÷ total trades.
  • Profit factor = gross profit ÷ absolute gross loss. Above 1 means the winners outweigh the losers over this sample.
  • Expectancy = net P&L ÷ number of trades, the average result per trade in your account currency.
  • Payoff ratio = average win ÷ average loss.
  • Max drawdown is the largest peak-to-trough drop on the cumulative P&L curve, in currency terms.
  • Longest streaks report the most consecutive winners and losers in sequence.

Why it stays in the browser

Trade history is sensitive. This tool uses client-side JavaScript only, so the CSV is read and analyzed on your machine. There is no account, no upload and no storage. Closing the tab clears the data.

Worked example

For the trade sequence 100, -50, 200, -100, -80, 300, -40, the analyzer reports 7 trades, a 42.9% win rate, gross profit 600, gross loss -270, net 330, profit factor 2.22, expectancy about 47.1 per trade, a longest losing streak of 2 and a maximum drawdown of 180 (from the peak of 250 down to 70).

Limits

These are descriptive statistics on the trades you provide. A small sample, survivorship in which trades you logged, and changing market conditions all limit how far past results describe future ones. The stats are a review aid, not a forecast.

Frequently asked questions

Is my trade data uploaded anywhere?
No. The CSV is parsed with your browser's FileReader in client-side JavaScript. There is no server upload, account or storage, and closing the tab clears the data.
What columns does the CSV need?
At minimum a per-trade profit and loss column. The tool auto-detects a header like PnL, P&L, Profit, Net or Result, and lets you pick the column if detection fails.
How is profit factor calculated?
Gross profit divided by the absolute value of gross loss. A value above 1 means winners outweighed losers across the trades you loaded; with no losing trades it is reported as infinite.
What does maximum drawdown mean here?
It is the largest drop from a running high to a later low on the cumulative P&L curve, expressed in your account currency.
Do these stats predict future returns?
No. They summarize the sample you provide. Sample size, which trades you logged and changing conditions all limit how much past results say about the future.

Related calculators

ExpectancyRisk of RuinDrawdown RecoveryPosition Size