Template
Trading journal template for Excel
A plain Excel workbook: a paste area, a trade log, and the statistics you can calculate from your own numbers. No sign-up, no macros, nothing sent anywhere.
Short answer
This free Excel trading journal has five sheets: a paste area whose first 11 columns match a Statementizer Trades export, a journal with one row per closed trade, a stats sheet with win rate, profit factor, expectancy and drawdown, and a by-symbol summary. Every figure is a formula on numbers you enter.
Download
Blank template: empty sheets with the formulas ready. Example file: the same workbook filled with four invented trades, so you can see every formula at work before you start.
Download the blank template (.xlsx)Download the example file (.xlsx)
What is inside
| Sheet | What it is for |
|---|---|
| Read me | What each sheet does, the definitions of every figure, and the notice. |
| Trades | A paste area. Its first 11 columns are the same, in the same order, as the Trades sheet of a Statementizer Excel export. Column L is yours for notes. |
| Journal | One row per completed round trip, 300 rows. White columns are yours to fill in; grey columns are formulas. |
| Stats | Win rate, profit factor, expectancy, drawdown and more, calculated from the Journal. |
| By symbol | Type symbols and see fills, quantities and cash for each, from the rows pasted into Trades. |
Pasting a Statementizer export
The Trades sheet has these columns, in this order. They are the columns of the Trades sheet in a Statementizer Excel export, so you can copy the export's rows and paste them in at cell A2 without rearranging anything.
Date · Symbol · Side · Quantity · Price · Gross · Fees · Net · Currency · Confidence · Review Status
In an export, Gross is quantity times price, and Net is the amount paid on a buy or received on a sell once the fees are counted. The By symbol sheet uses Side (buy or sell),Quantity, Fees and Net.
The Journal columns
Fill in the white columns. The grey columns calculate by themselves and stay blank until Shares is filled, so empty rows cost nothing.
| Col | Name | You or formula | What it holds |
|---|---|---|---|
| A | Date closed | You enter it | The day the trade was closed. |
| B | Symbol | You enter it | The ticker or instrument name. |
| C | Direction | You enter it | Long or Short, from a drop-down. Blank counts as Long. |
| D | Shares | You enter it | Number of shares or units. The formulas stay blank until this is filled. |
| E | Entry price | You enter it | Price per share paid (Long) or received (Short) to open. |
| F | Exit price | You enter it | Price per share received (Long) or paid (Short) to close. |
| G | Entry fee | You enter it | Total commission for the opening trade. Optional. |
| H | Exit fee | You enter it | Total commission for the closing trade. Optional. |
| I | Initial risk (optional) | You enter it | The amount you were prepared to lose on the trade, used only for the R multiple. |
| J | Setup / tag | You enter it | Free text for your own grouping. |
| K | Notes | You enter it | Free text. |
| L | Gross P/L | Formula | Long: shares x (exit - entry). Short: shares x (entry - exit). |
| M | Fees | Formula | Entry fee + exit fee. |
| N | Net P/L | Formula | Gross P/L - Fees. |
| O | Return on entry value | Formula | Net P/L / (shares x entry price + entry fee). |
| P | R multiple | Formula | Net P/L / Initial risk. Blank when no Initial risk is entered. |
| Q | Result | Formula | Win if Net P/L is above zero, Loss if below, Even if zero. |
| R | Cumulative net P/L | Formula | Running total of Net P/L down the sheet. |
| S | Running peak | Formula | Highest Cumulative net P/L so far, never below zero. |
| T | Drawdown | Formula | Running peak - Cumulative net P/L. |
The Stats sheet
Every measure is plain arithmetic on the Journal's Net P/L column. The last column shows what each gives for the example file.
| Measure | How it is calculated | Example file |
|---|---|---|
| Closed trades | Rows in the Journal with shares entered. | 4 |
| Wins | Net P/L above zero, after fees. | 2 |
| Losses | Net P/L below zero, after fees. | 2 |
| Even | Net P/L exactly zero. | 0 |
| Win rate | Wins divided by closed trades. | 50.00% |
| Total net P/L | Sum of Net P/L. | 345.90 |
| Gross wins | Sum of the winning trades' Net P/L. | 448.20 |
| Gross losses | Sum of the losing trades' Net P/L (a negative number). | -102.30 |
| Average win | Gross wins divided by wins. | 224.10 |
| Average loss | Gross losses divided by losses (a negative number). | -51.15 |
| Profit factor | Gross wins divided by the size of gross losses. | 4.38 |
| Expectancy per trade | Total net P/L divided by closed trades. | 86.48 |
| Largest win | Highest Net P/L. | 332.10 |
| Largest loss | Lowest Net P/L. | -92.40 |
| Total fees | Entry and exit fees together. | 39.60 |
| Maximum drawdown | Largest fall from the running peak of cumulative Net P/L (the peak starts at zero). | 92.40 |
| Average R multiple | Average of Net P/L divided by Initial risk, over rows that have an Initial risk. | 0.62 |
The example file
Four invented round trips of made-up stocks, one of them a short. The figures below are what the formulas show; each was also recalculated by a separate program when the file was built.
| Closed | Symbol | Direction | Shares | Entry | Exit | Gross P/L | Fees | Net P/L | Result |
|---|---|---|---|---|---|---|---|---|---|
| 2026-03-11 | EXMP | Long | 100 | 42.18 | 45.60 | 342.00 | 9.90 | 332.10 | Win |
| 2026-03-19 | DEMO | Long | 150 | 18.95 | 18.40 | -82.50 | 9.90 | -92.40 | Loss |
| 2026-04-02 | ZLTA | Short | 60 | 38.20 | 36.10 | 126.00 | 9.90 | 116.10 | Win |
| 2026-04-09 | EXMP | Long | 80 | 44.00 | 44.00 | 0.00 | 9.90 | -9.90 | Loss |
How to use it
- Download the blank template and open it in Excel.
- After each trade closes, add a row on the Journal sheet: date, symbol, direction, shares, entry and exit prices and the two fees. The grey columns fill in.
- Optionally paste your statement's rows into Trades and list your symbols on By symbolto check the fills and fees against what you entered.
- Read the totals on Stats. Compare them with your own records.
Good to know
- Excel versions. The workbook uses only IF, OR, SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS, MAX, MIN, AVERAGE and IFERROR. Microsoft's help lists SUMIFS and IFERROR for Excel 2016, 2019, 2021, 2024, Microsoft 365 and Excel for the web. There are no macros and no external links.
- Formulas calculate when the file opens. A previewer that does not run formulas, such as some email or phone file viewers, shows the grey columns empty.
- Floating point. Excel keeps numbers in binary floating point, so a result can differ from exact decimal arithmetic by a tiny fraction of a cent. Cells show two decimals. The calculators on this site, for example the stock profit calculator and thestock average calculator, use exact decimal arithmetic.
- Size. The Journal holds 300 rows. To use more, copy the last row's formulas down and extend the ranges on the Stats sheet.
- What it does not do. It does not match buys with sells for you, work out cost basis, convert currencies or calculate tax. You enter each round trip yourself.
- How it was checked. The example file's every formula was recalculated by an independent spreadsheet engine and compared with a separate calculation of the same trades. It was not opened by hand in every version of Excel, so check the first results against your own arithmetic.
Common questions
- Is the template free?
- Yes. The links above download the files directly, with no form and no account.
- Does the file send my trades anywhere?
- No. It is a plain
.xlsxworkbook with no macros and no external links. Whatever you type stays in the file on your computer. - Why are some cells empty?
- The grey formula cells stay blank until Shares is filled in on that row.
- What counts as one trade?
- One row is one completed round trip: an entry and the exit that closed it, entered by you.
- Can I add my own columns?
- Yes, to the right of the grey columns on the Journal. Columns J and K are free text for your own notes and tags.
What Statementizer does with this
Typing every trade by hand is the slow part. Statementizer reads supported broker statement PDFs into rows you can review, with each commission split out, and its Excel export has a Trades sheet in the same columns as this template's Trades sheet. See what it reads from Interactive Brokers Activity Statements.
See how Statementizer worksSources
The statistics are arithmetic, defined on this page and in the workbook's Read me sheet. The sources below describe the spreadsheet functions the workbook uses and the Excel versions that have them.
Verified on 2026-10-18 by the Statementizer Team.