Trading journal

Record closed trades in a workbook with 100 entry rows, net P&L, R-multiples and a guide.

Your trading workbook

Use one row per closed trade and keep a unique Trade ID for each entry.

Excel workbook (.xlsx), 123,108 bytes. Includes Journal and Guide sheets and 100 entry rows.

Before you enter trades

Entry and exit prices are currency per unit. Quantity must be a positive number of those same units. No lot size or contract multiplier is applied.

Select one three-letter currency code in Journal B4 and use it for every trade. Different currencies are excluded, not converted.

Open the workbook in a spreadsheet application that recalculates formulas after edits. A viewer that only reads saved results cannot calculate new results.

How to use the trading journal

Set Journal B4 to your three-letter currency code. Read the Guide sheet before entering trades.
Fill the yellow input area (A19:J118), one row per closed trade. Enter a unique Trade ID, a numeric spreadsheet close date, an instrument and Long or Short.
Use the selected currency for each trade. Enter numeric entry and exit prices and a positive quantity in matching units. Enter nonnegative total entry and exit costs; use 0 for no costs. Blank costs are incomplete.
Enter a positive initial risk amount in the selected currency to calculate R. Keep the grey formula columns K:O intact and recalculate in your spreadsheet application.
Only the 100 entry rows feed the summaries, including filtered-out rows. Sort the entire A:O record range together. Use another blank copy beyond 100 trades.

Formula

Long gross P&L = (exit price - entry price) × quantity. Short gross P&L = (entry price - exit price) × quantity.Net P&L = gross P&L - total costs. R-multiple = net P&L / positive initial risk.Currency expectancy is the arithmetic mean of numeric net P&L results. R expectancy is the arithmetic mean of numeric R-multiples, not total P&L divided by total risk. Breakeven trades count; an empty sample has blank expectancy.Running R expectancy in column O follows worksheet row order. These means describe the trades entered; they are not forecasts.

FAQ

Can I mix currencies or enter lots?

Use one three-letter currency code for the workbook and every trade. There is no currency conversion. Quantity must match the units used in the entry and exit prices; no implicit lot size or contract multiplier is applied.

Why is an R-multiple blank?

Zero, missing, negative or nonnumeric initial risk leaves R blank while retaining valid net P&L. These trades are excluded from R summaries and counted as completed trades without R. Missing or invalid required inputs leave all results blank.

Why do results need recalculation?

The blank workbook stores empty formula-result caches and zero summary counts and totals. Your spreadsheet application must recalculate formulas after edits. Keep the formula columns intact; a viewer of saved results alone cannot calculate updated results.

Other tools

Position size calculatorLot size from balance, risk and stop loss, with a gold (XAUUSD) mode.Pip value calculatorWhat one pip is worth on any pair and lot size.Compound interest calculatorHow your account grows when you reinvest returns.Average cost (DCA) calculatorYour average entry price across several buys.Risk of ruin calculatorEstimate the probability of reaching a loss threshold within a chosen number of trades.Forex market hoursWhen the Sydney, Tokyo, London and New York sessions overlap.Risk/reward calculatorCompare per-unit and position risk, target payoff and break-even win rates before and after costs.