EnglishفارسیTürkçe

Features

Journal Backtest Prop Firm Scripts Replay & Trade Charts Analysis Playbook Mentor Broker sync

Resources

Pricing Learn Forex calculator Crypto futures calculator Symbols Supported brokers Sign in Get started
Free download · 2026

Free trading journal template for Excel, Google Sheets and PDF

A ready-made journal for forex, gold, index, futures and crypto traders. You type a trade's prices; the sheet works out the dollars, the R and every number you need for your weekly review. Below it: the columns that matter, the formulas behind them, and a printable version.

Excel .xlsx, 7 sheets, about 270 KB · PDF, 2 pages, A4 · No sign-up, no email, no macros

Would rather not type every trade? TradeAssay can fill the journal in for you from MetaTrader, cTrader and crypto exchanges.

The free TradeAssay trading journal template open in Microsoft Excel: the Journal sheet with example trades, and the Dashboard with win rate, profit factor, expectancy and drawdown.

In 30 seconds

  • What you getA journal, a dashboard of 24 numbers, a monthly report, a daily plan and a printable PDF.
  • What you typeDate, symbol, buy or sell, size, entry, stop, target, exit, costs, setup and whether you kept your plan.
  • What it works outP&L in dollars, risk, R, win rate, profit factor, expectancy, drawdown and streaks.

Excel, Google Sheets, Notion, paper or an app?

A trading journal template comes in five forms. They all hold the same record; they differ in how much of the work they do for you.

FormatBest forGood atWatch out for
ExcelMost tradersReal formulas and charts, works offline, privateYou type every trade
Google SheetsLogging from phone and computerFree, syncs everywhere, easy to share with a mentorThe same typing; slower with thousands of rows
NotionNotes and screenshotsRich pages, pictures, tagsWeak at maths: P&L, R and drawdown need workarounds
Printable PDFWriting by handNothing to set up, no screen timeNo calculations at all
A journal appActive tradersTrades imported or synced, every trade on its chart, deep analysisA new tool to learn; the advanced parts are paid

This template covers the first, second and fourth: one Excel file that also opens in Google Sheets, and a printable PDF. When you outgrow it, the same file moves into TradeAssay with every trade in it.

What is inside the template

Every sheet does one job. You only ever type in two of them: Journal after each trade, and Daily plan before the market opens if you use it.

  • Journal. One row per trade, 1,000 rows ready. White columns are yours; grey columns calculate themselves.
  • Dashboard. 24 numbers about your trading, a balance curve, and tables by setup, mistake, emotion, weekday and whether you followed your plan.
  • Monthly. Trades, win rate, net P&L and total R for each month of the year you choose, with a chart.
  • Daily plan. Your bias, key levels, the day's news, the most you allow yourself to lose today, and a short review after the close.
  • Instruments. What a 1.0 move is worth on one lot for the common forex pairs, metals, index CFDs, oil, crypto and US futures.
  • Lists. Your setups, mistakes and emotions for the dropdowns. Rename them to your own words.
  • Start here. One page: how to use it, and four numbers worth knowing.
The Journal sheet open in Microsoft Excel: twelve example trades with date, time, symbol, side, lots, entry, stop loss, take profit, exit, costs, net P&L, risk and R.
Journal, open in Excel: the columns you type, and the first results. The twelve example trades show how it works; delete them when you start.
The Journal sheet in Excel, scrolled right: dollars per 1.0 move, net P&L, risk, R, planned reward to risk and outcome, then setup, mistake, emotion, whether the plan was followed and notes.
Journal, further right: the grey columns fill themselves in (net P&L, risk, R, planned R:R, outcome), next to your setup, mistake, emotion and plan.
The Dashboard sheet in Excel: 12 trades, 66.7% win rate, net P&L $202.78, profit factor 1.20, expectancy +0.72R, maximum drawdown $804.50, the balance curve and the tables by setup and by mistake.
Dashboard: 24 numbers, the balance curve and the tables by setup and mistake, all from the Journal sheet.

The columns every trading journal needs

A journal you stop filling in is worth nothing, so fewer columns you actually keep beat forty you abandon. These are the ones that pay for the typing:

ColumnWhat to writeWhy it matters
Date and timeWhen you opened and closedFinds your best and worst hours and weekdays
Symbol and sideEURUSD, XAUUSD, NQ…; buy or sellShows which markets and which direction pay you
SizeLots or contractsCatches oversized trades, often the most expensive mistake
Entry and exitThe prices you actually gotYour P&L, worked out, not guessed
Stop lossThe stop you entered withDefines your risk, and so your R
Take profitYour planned targetPlanned reward to risk, and whether you cut winners short
Commission and swapFrom your broker's statementCosts quietly eat a small edge
SetupWhich of your setups it wasWhich setup actually makes money
MistakeNone, early exit, moved stop…What each mistake costs you, in dollars
EmotionCalm, anxious, greedy…Links your state of mind to your results
Followed my plan?Yes or noThe single most useful column in the journal
Notes and chart linkOne line, and a link to a screenshotThe context you need when you review

The template has exactly these, with dropdowns for side, setup, mistake, emotion and plan so a row takes under a minute.

Choosing a setup from the dropdown in the Journal sheet in Excel: Breakout, Pullback, Reversal, Range, Trend continuation and News.
Pick the setup, mistake, emotion and plan from a list; rename the lists to your own words.

How to fill it in, step by step

  1. Open the file and read Start here once. It is one page.
  2. In Journal, delete the example rows: select the row numbers 2 to 13, right-click and choose Delete. (The Delete key alone would also erase the grey formulas.)
  3. After each trade, fill one row: date and time, symbol, side, lots, entry, the stop you entered with, target, exit, commission and swap.
  4. Pick the setup, any mistake, how you felt and whether you followed your plan from the dropdowns. These four columns are what make the review useful later.
  5. On the Dashboard, type your starting balance once. Everything else there updates by itself.

Here is the first example trade, so you can see what the sheet does with your numbers. You bought 0.50 lot of EURUSD at 1.15820 with a stop at 1.15620 and a target at 1.16220, closed at 1.16180 and paid $3.50 in commission.

$176.50Net P&L: 0.00360 × 100,000 × 0.50, less $3.50
$100.00Risk: 0.00200 × 100,000 × 0.50
+1.77RResult in R: $176.50 ÷ $100.00
2.00Planned reward to risk

The stop matters more than any other column. R measures each result against what you were prepared to lose, so it must be the stop you had when you entered. If you moved it later, still write the first one. Moving it is a mistake worth recording, and it quietly breaks your R if you don't.

The formulas, if you want to build your own

Nothing in the template is hidden or locked. These are its formulas for the first trade row, simplified for reading (the file also leaves a row blank until it has the prices it needs). The columns are the template's: D side, E lots, F entry, G stop, H target, I exit, M commission, N swap, O the dollar value of a 1.0 move, P net P&L, Q risk, R the result in R and T the outcome.

FigureWhat it meansExcel formula
Net P&LPrice move × size × value of a move, less costs=(I2-F2)*IF(D2="Sell",-1,1)*O2*E2-ABS(M2)+N2
RiskWhat you stood to lose at your stop=ABS(F2-G2)*O2*E2
RThe result measured in the risk you took=P2/Q2
Planned R:RDistance to target ÷ distance to stop=ABS(H2-F2)/ABS(F2-G2)
Win rateWins ÷ (wins + losses)=COUNTIF(T:T,"Win")/(COUNTIF(T:T,"Win")+COUNTIF(T:T,"Loss"))
Profit factorEverything won ÷ everything lost=SUMIF(P:P,">0")/ABS(SUMIF(P:P,"<0"))
ExpectancyThe average trade, in R or in dollars=AVERAGE(R:R) · =AVERAGE(P:P)
Max drawdownThe deepest fall from a high pointBalance in AA =Start+SUM($P$2:P2), its running high in AB =MAX($AA$2:AA2), the fall in AC =AB2-AA2, then =MAX(AC:AC) (hidden columns in the file)

The value of a 1.0 move in column O is looked up from the Instruments sheet by the symbol, which is what lets one formula work for EURUSD, gold and Nasdaq futures alike.

Where the dollars come from

The sheet multiplies the price move by the size and by what a 1.0 move is worth on one lot. That last number lives in the Instruments sheet and follows the standard contracts: a forex lot is 100,000 units, so one pip (0.0001) is $10 per lot on EURUSD; a lot of gold is 100 ounces, so a $1 move is $100; index CFDs are usually $1 per point per lot; futures use the exchange's multiplier.

SymbolA 1.0 move on one lot or contractNote
EURUSD, GBPUSD, AUDUSD$100,000One pip is $10
USDJPY, USDCAD, USDCHF100,000 ÷ the rateRates are on the same sheet; update them now and then
XAUUSD (gold)$100A $0.01 move is $1
US30, NAS100, US500$1Brokers differ: check your contract size
NQ · MNQ$20 · $2One contract
ES · MES$50 · $5One contract
GC · CL$100 · $1,000One contract

Broker names work too: XAUUSDm, EURUSD.pro and US30.cash all find their row. For futures, type the root (NQ, not NQZ6). If your broker shows a different figure for a trade, type it in Gross P&L and the sheet uses it instead of its own maths. In MetaTrader you find the real contract by right-clicking a symbol and choosing Specification.

A trading journal template for your market

One file covers them all, but each market has its own catch:

  • Forex. Lots of 100,000 units. Pairs not quoted in dollars, such as USDJPY, are converted with the rate on the Instruments sheet. On swing trades, record the swap: it adds up. Size a trade first with the forex position size calculator.
  • Gold (XAUUSD). 100 ounces per lot, so a $1 move is $100 a lot, and gold moves about $30 in an hour at its busiest. Note the hour of each trade: when gold really moves matters for your stops.
  • Index CFDs. US30, NAS100, US500, GER40 and UK100 are usually $1 per point per lot, but brokers differ. Check the contract once and correct the Instruments row.
  • Futures. NQ, MNQ, ES, MES, YM, MYM, RTY, M2K, GC, MGC, CL and MCL at their exchange multipliers. Record commission for the round trip; on micros it is a real share of a scalp.
  • Crypto. BTCUSD and ETHUSD at one coin per lot. On exchange futures, put funding in the Swap column. The crypto futures calculator works out size and liquidation.
  • Prop firm challenges. The Dashboard shows your maximum drawdown, and the Daily plan holds your loss limit for the day. The sheet does not know your firm's trailing drawdown or daily-loss rule; read why traders fail prop firm challenges for the arithmetic.

The printable trading journal (PDF)

Some traders keep their journal on paper on purpose: writing a trade by hand makes you look at it. The PDF has two A4 landscape pages: a trade log with the same columns as the spreadsheet, and a weekly review with eight boxes for your numbers and five questions.

Download the printable PDF and print as many copies as you need.

A daily plan, before the market opens

The Daily plan sheet is the other half of a journal: what you meant to do, written before you knew how the day would go. One row a day: your bias, key levels, the day's news, the most you will lose today, how you feel from 1 to 10, and after the close, a short review and one thing for tomorrow.

The Daily plan sheet: date, market bias, key levels, news today, maximum loss today, how I feel, end-of-day review and tomorrow I will, with two example days.
Daily plan: two example days.

How to review your journal once a week

A journal earns its keep in the weekly review, not in the typing. The twelve example trades show why the Dashboard looks past the win rate.

  • The win rate looked great and the money didn't. Eight wins out of twelve is 66.7%, yet the profit factor is only 1.20, because the average loss ($259.68) is bigger than the average win ($155.19).
  • One trade did that. A single NQ contract risked $800 while every other trade risked $40 to $180. It lost $804.50, and the Mistake column says why: oversized.
  • R tells the truth about the setup. Breakout lost $348.22 in dollars, but its average result is +0.99R. The setup worked; the size of one trade did not.
  • Following the plan was the whole edge. The three trades marked "No" lost $835.10 together. The nine trades that followed the plan made $1,037.88.
Dashboard tables by setup and by mistake: Breakout 3 trades, 67% win rate, minus $348.22, plus 0.99R on average; trades with no mistake 7, plus $1,047.88.
Results by setup and by mistake, from the same twelve trades.

Five questions to answer every week, the same ones printed on page 2 of the PDF:

  1. Did I follow my plan on every trade? Which ones not, and why?
  2. Which setup made money this week, and which one lost?
  3. What was my most expensive mistake, and what did it cost?
  4. How did I feel before my worst trade?
  5. One thing I will do differently next week.

One warning the sheet prints for you: small samples lie. Give a setup about 30 trades before you trust its win rate, and read how many trades your statistics need before you change a method because of a bad week.

Using it in Google Sheets

The quickest way: make your own copy in Google Sheets. It lands in your Google Drive, private to you. Or do it by hand:

  1. Download the Excel file above.
  2. In Google Drive, choose New → File upload and pick the file.
  3. Right-click it, choose Open with → Google Sheets, then File → Save as Google Sheets.
The template's Dashboard open in Google Sheets: the same 12 trades, 66.7% win rate, net P&L $202.78 and profit factor 1.20 as in Excel.
The same Dashboard in Google Sheets: every figure matches Excel. The balance chart shows as dots rather than a line.

The formulas, dropdowns and numbers come across unchanged. Nothing in the file needs macros or add-ins, so it also opens in the Excel and Google Sheets apps on a phone, where adding a trade is easy and the dropdowns are a little fiddly.

When a spreadsheet stops being enough

If you take a handful of trades a week, this file is all the journal you need. It starts to cost you when the typing does: thirty trades a week is roughly an hour of copying prices, a mistyped digit changes a result without telling you, and a row of numbers never shows you the chart you traded.

This Excel templateTradeAssay
Getting trades inYou type each oneImport a file (this one too) or add by hand, free. Automatic sync from MetaTrader 4 and 5, cTrader, Bybit, Binance, Hyperliquid and IBKR on Pro
P&L and costsFrom the prices you typeYour broker's own figures, commission and swap included, when synced
Win rate, R, expectancy, drawdownYesYes, with a calendar, day pages and seven Analysis views, free
Each trade on its chart, replayNoPro
Playbooks and rule trackingA Followed-my-plan columnEach rule ticked and priced, free
BacktestingNoUnlimited on Pro and in the 7-day trial

Moving this file into TradeAssay

You don't lose your history when you move. In TradeAssay, open Import, choose File and pick this workbook. The columns are recognised by their names, in English, Persian or Turkish, and you see every trade before anything is saved. Setups, mistakes and notes stay in the file; the trades themselves come in.

Frequently asked questions

Is the trading journal template really free?

Yes. There is no sign-up and no email to give. Use it, change it and share it freely.

Does it work in Google Sheets and on a Mac?

Yes. It opens in Excel for Windows and Mac and in Google Sheets: upload the .xlsx to Google Drive and open it with Google Sheets. It uses no macros and no add-ins.

Is there a printable trading journal PDF?

Yes. The PDF has two A4 landscape pages: a trade log with the same columns as the spreadsheet, and a weekly review with your numbers and five questions. Print as many as you need.

What should a trading journal include?

For every trade: date and time, symbol, buy or sell, size, entry, the stop you entered with, target, exit, costs, the setup, any mistake, how you felt and whether you followed your plan. The stop and the plan column are the two that matter most.

How do I calculate R in Excel?

Divide the trade's net P&L by the money you risked to your first stop. Risk is the distance from entry to stop, times the size, times what a 1.0 move is worth: in the template, =ABS(F2-G2)*O2*E2, and R is =P2/Q2.

Why doesn't my P&L match my broker's?

Usually the contract size, which differs between brokers on index and oil CFDs, or a currency conversion. Change the number in the Instruments sheet, or type your broker's figure in Gross P&L and the sheet uses it instead.

My symbol is not in the list. What do I do?

Add a row to the Instruments sheet with what a 1.0 move is worth on one lot. Broker suffixes such as XAUUSDm, EURUSD.pro or US30.cash are recognised already.

Can I use it for a prop firm challenge?

Yes, for keeping the record: it shows your maximum drawdown, and the Daily plan sheet holds your maximum loss for the day. It does not know your firm's daily loss rule or trailing drawdown.

What is a good win rate?

There is no good win rate on its own. A 40% win rate with winners of 2R makes money; a 70% win rate with winners of 0.3R loses it. Judge a method by its expectancy in R over enough trades.

Written by the TradeAssay Team, traders with more than seven years of experience in forex, gold, indices and futures. Every number on this page was calculated by the template itself in Microsoft Excel.

When the typing starts to cost you reviews, TradeAssay keeps the same journal for you, with every trade on its chart.

Start free

Trading foreign exchange, futures and other leveraged products carries a high level of risk and is not suitable for every investor. This template and this page are a record-keeping tool and illustrative arithmetic, not investment advice. The example trades are examples, not results.

Your next trade deserves a reason.

Bring in your history and see what it says — free, in a few minutes.

Create your free account
Help centre

Answers to what traders ask us most — and a ticket to a person when they aren't enough.

Open help
Write to us

support@tradeassay.com — read by the people who build the app.

Send an email
Learn

Long reads on sample size, R and prop-firm rules, each with a calculator.

Start reading