EN中文
Position Math

Calculators › Trading

CSV Trade Journal Analyzer

The trade journal analyzer reads a CSV export from your broker or journal and returns your core stats — win rate, net P&L, profit factor, expectancy, streaks and max drawdown — plus an equity curve, entirely inside your browser. Nothing is uploaded.

A trade journal analyzer reads a local CSV of closed-trade P&L, keeps it inside the browser with FileReader, and computes win rate, net P&L, profit factor, expectancy, payoff ratio, loss streaks and maximum drawdown on the cumulative equity curve.

Trade log input

Your CSV is read with FileReader inside this browser tab. Nothing is uploaded.
Use a closed-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 needed.
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—
Largest win / largest loss—

Cumulative P&L curve

The curve starts at 0 and adds each parsed trade P&L in file order. The CSV stays local to this page.

Newsletter

Get the weekly position-sizing playbook

One email a week: macro & US markets, gold, futures & crypto — plus prop-firm rules, risk math and new calculators. No spam, unsubscribe anytime.

How it works

What this calculator does

It reads a CSV of closed trades, finds or lets you choose the P&L column, parses numeric trade results, and calculates the main journal statistics a trader usually checks after a sample of trades.

Privacy model

The CSV is handled by browser-side JavaScript with FileReader. There is no account connection, no upload and no server-side storage. Closing the tab clears the data from the page.

The stats

The engine counts wins and losses, then computes win rate, gross profit, gross loss, net P&L, profit factor, average win, average loss, payoff ratio, expectancy per trade, largest win, largest loss, max consecutive wins and losses, and maximum drawdown on the cumulative P&L curve.

expectancy = net P&L / trade count

profit factor = gross profit / absolute gross loss

Worked example

For P&L values [100, -50, 200, -100, -80, 300, -40], net P&L is $330 across seven trades, win rate is 3 / 7, profit factor is 600 / 270, expectancy is $47.14 per trade, and the maximum drawdown on the cumulative curve is $180.

What it deliberately does not do

It does not clean messy broker semantics beyond a numeric P&L column, merge partial fills, infer taxes, or decide whether the sample is large enough. It is a local arithmetic and parsing tool, not a performance audit service.

Frequently asked questions

Does my CSV get uploaded?
No. The page reads the file with FileReader in your browser and analyzes it locally. There is no server upload, account connection or storage.
What columns does it need?
It needs one numeric P&L column. Auto-detect looks for names such as pnl, p&l, profit, net or result, and you can choose a column manually if your export uses another label.
Does it handle quoted commas in CSV files?
Yes. The parser supports quoted fields, including values like a symbol field that contains a comma.
How is maximum drawdown calculated?
The tool builds a cumulative P&L curve in file order, tracks the running peak, and reports the largest peak-to-trough dollar drop.
Is profit factor enough to judge a strategy?
No. Profit factor is useful, but it can look strong in a small or cherry-picked sample. Review sample size, drawdown, streaks, expectancy and the market context together.

Related calculators

ExpectancyMonte CarloLosing Streak

Funded-account checks

Use these three pages as a simple path: understand the rules, stress a scenario, then track consistency before a payout.

1Understand the ruleCompare challenge types, drawdown floors and payout logic.2Run a breach scenarioModel intraday vs end-of-day trailing drawdown before sizing a trade.3Track consistencyCheck whether one big day is blocking payout eligibility.
Information tool only. Every result is deterministic arithmetic (for the simulator, a probability estimate) from the numbers you enter. The calculators run in your browser with no account connection and nothing stored; the pairs scanner uses delayed, cached market data (daily figures, refreshed once a day), not a live feed. This is not investment, trading, tax, or financial advice — verify against your own broker or prop firm before acting.
Disclosure. Some outbound links may be affiliate or partner links; they never change how a tool computes.