Trading journal analyser

Analyse a local CSV of completed trades. Review net results, costs, win rate, profit factor and closed-trade drawdown without an exchange connection.

Inputs

Hypothetical example. Replace these inputs with your own.

Equity before the first completed trade · quoteOne quote currency for this fileCompleted trades (paste the documented CSV)Local CSV (read in this browser)

Browser-selected files are not uploaded. Without JavaScript, pasted CSV is sent transiently to PHP on this website. Use the documented format below. Required records are not inferred or filled in.

Completed trades only. One quote currency per file. CSV header: id,closed_at,symbol,side,quantity,entry_price,exit_price,fees,other_costs,risk_quote. Plain unquoted fields; UTC closing times such as 2025-01-01T12:00:00Z. Risk may be blank. Maximum 1,000 rows and 256 KiB.

Result

Calculation result

Example result

Net result: -3 USD
Total fees and other costs: 3 USD
Completed trades: 3 count
Winning trades / all trades: 33.3333 %
Net profit factor: 0.857143 ratio
Average net trade: -1 USD
Maximum closed-equity drawdown: 2.0629 %
Maximum closed-equity drawdown: 21 USD
Ending closed equity: 997 USD
Average R where risk is supplied: -0.15 R
Trades with supplied risk: 2 count
Winning trades: 1 count
Losing trades: 1 count
Breakeven trades: 1 count
Longest winning run: 1 count
Longest losing run: 1 count

Only completed trades are included. The supplied quote label applies to every price, fee, cost and risk amount; symbols are labels and are not looked up.
Trades are ordered by UTC closing time. Rows with the same closing time keep their original CSV order. Breakeven trades count in the win-rate denominator and reset both streaks.
Drawdown follows closed equity from the supplied starting balance. Open positions, intratrade drawdown, partial fills, deposits, withdrawals, currency conversion and tax are excluded.
Average R uses only trades with a supplied positive risk amount. Each R multiple includes the entered fees and other costs.

Calculation breakdown
Close order · count	CSV line · line	Trade ID	Closed at · UTC	Symbol label	Side	Quantity · units	Entry price · USD/unit	Exit price · USD/unit	Fees · USD	Supplied risk · USD	Gross result · USD	Total trade costs · USD	Net result · USD	Net R multiple · R	Closed equity · USD	Running equity peak · USD	Closed-equity drawdown · USD	Closed-equity drawdown · %
1	2	a	2025-01-01T12:00:00Z	EXAMPLE	long	1	100	120	2	10	20	2	18	1.8	1,018	1,018	0	0
2	3	b	2025-01-02T12:00:00Z	EXAMPLE	short	2	100	110	1	10	-20	1	-21	-2.1	997	1,018	21	2.0629
3	4	c	2025-01-03T12:00:00Z	EXAMPLE	long	1	100	100	0	Not defined	0	0	0	Not defined	997	1,018	21	2.0629

Saved scenarios

Save up to 20 new-tool scenarios on this device, separately from the six existing tools. Prices and balances stay out of the URL. DCA, journal and correlation scenarios save settings and a digest, requiring the matching CSV again to calculate.

Scenario nameSaved scenario

Saving requires browser storage and Web Locks.

Formula and worked example

Long gross = quantity × (exit − entry); short gross reverses that difference. Net subtracts total trade fees and other costs. Drawdown follows the completed-trade equity path, starting with your supplied equity. Risk multiples use only rows with a positive risk amount.

Synthetic file: net +18, −21 and 0 produce a −3 total, 33.3333% win rate and 18/21 net profit factor. Closed-equity drawdown is 21 from a peak of 1,018. This omits open positions, intratrade drawdown, partial fills, deposits, withdrawals, FX and tax.

These estimates use bounded decimal arithmetic. They are scenario calculations, not trading instructions or forecasts.

Methodology sources: Trade fees and net results