Trading Journal and Position Sizing Workbook
R multiples, expectancy, drawdown, verified
Trading journal with risk-rule position sizing, R multiples, expectancy, profit factor, equity curve and drawdown, every statistic verified. Not advice.
One price, no licence to choose. Payment and VAT are handled by Gumroad, the merchant of record.
A trading journal that does the arithmetic properly. One row per closed trade: entry, stop, exit, size, fees. The workbook computes the position size the risk rule would have given from the balance before the trade (balance times your risk share, divided by the distance to the stop, rounded to your lot), the risk you actually took, net P&L, the R multiple and the running balance, so you can compare the size you took with the size the rule gave, trade by trade.
Stats: closed trades, wins, losses, win rate, net P&L, gross profit and gross loss, profit factor, expectancy in R with its win-rate decomposition beside it, average winning and losing R, largest win and loss, ending balance, return, maximum drawdown from the equity curve's running peak, and the Kelly fraction with the Guide's warning about why you should not bet it. Equity: balance after every trade, running peak, drawdown. Room for 200 trades; twelve illustrative trades to replace.
- Every statistic recalculated with a formula engine and matched to an independent Python replica before listing: 18 statistics and 12 trade rows, to the cent.
- Live formulas, no macros, no locked cells; opens in Excel and Google Sheets.
- Arithmetic on trades you enter: no signals, no forecasts, no recommendation to buy or sell anything. Trading involves risk of loss. Not investment advice.
What is inside
1 Excel workbook (.xlsx), sheets: Inputs, Trades (200 rows), Stats, Equity, Guide.
Use it if
You trade your own account or a small book and want a journal whose statistics you can trust and audit cell by cell.
Not for
You want signals, forecasts, backtests or a recommendation of what to trade; this workbook measures what you did.
Sheet previews
How buying works
- Choose a licenceSingle user for one person, team for up to 10, consultancy to use with clients. The buttons above go to the Gumroad page.
- Pay on GumroadCard or PayPal; Gumroad is the merchant of record and handles VAT and the receipt.
- Download the fileThe .xlsx arrives on the receipt page and by email. It opens in Excel and Google Sheets; nothing to install.
- Use itYellow cells are inputs, blue cells are formulas, every figure names its source. Questions: reply to the receipt; every reply is read and answered, usually the same day.
Advisers and accountants who recommend these workbooks to clients can earn 30% of each sale as a Gumroad affiliate: sign up on the store, no approval wait.
Search terms this page answers: trading journal excel template, position size calculator excel, R multiple expectancy spreadsheet, trading drawdown tracker, kelly fraction calculator.