Risk warning: CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. Risk disclosure
Education10 min read

Trading journal: how to keep one (with a free template)

Learn how to keep a trading journal: what to record, a free trading journal template for Excel or Google Sheets, key stats to track and a weekly review.

Trading journal spreadsheet with columns for setup, entry, stop loss, exit, result in R and emotions (example data)
On this page
  1. Why keep a trading journal?
  2. What to record in a trading journal
  3. Before the trade
  4. After the trade
  5. What is "R"?
  6. Trading journal template
  7. Useful formulas for your sheet
  8. The statistics that matter
  9. Break the data down
  10. Example breakdown by setup
  11. Screenshots: the most underrated part
  12. Recording emotions and discipline
  13. How to review your journal
  14. Daily (5 minutes)
  15. Weekly (30 minutes)
  16. Monthly (1 hour)
  17. Trading journal options: spreadsheet, app or notebook
  18. Common trading journal mistakes
  19. A simple plan to start this week
  20. Start your journal on a Xellion demo account

A trading journal is a record of every trade you take: what you traded, why you took it, how you managed it, how it ended and what you learned. It turns a string of individual wins and losses into data you can study. Over time it shows which setups actually work for you, which habits cost you money, and whether you are following your own plan.

Trading journal and trade journal are searched thousands of times a month in India, often with "template" or "app". This guide explains what to record, gives you a trading journal template you can copy into Excel or Google Sheets, shows the statistics worth tracking, and walks through a simple weekly review. All prices in this article are example prices.

Why keep a trading journal?

Most traders remember their big wins and their worst losses. They forget the dozens of ordinary trades in between, which is where most of the useful information is. A journal fixes that.

Without a journalWith a journal
"I think breakouts work for me""My breakouts won 38% of the time with an average 1.4:1 reward-to-risk"
"I had a bad week""Four of my five losses came from trades taken after 10 pm IST outside my plan"
"I always get stopped out""My stops are inside 1 × ATR on 70% of losing trades"
Repeat the same mistakesSpot patterns and change one thing at a time

A journal will not make a strategy profitable on its own. It shows you the truth about how you trade, so you can decide what to keep, what to change and what to stop.

What to record in a trading journal

Record the same fields for every trade. Consistency matters more than detail.

Before the trade

  • Date and time (IST) of entry
  • Instrument (for example EUR/USD, gold, GBP/JPY)
  • Direction: buy or sell
  • Timeframe of the setup (H1, H4, daily)
  • Setup name: a short, consistent label, for example "hammer at support", "breakout retest", "trend pullback"
  • Reason for entry: one or two lines on what you saw
  • Entry price, stop loss and take profit
  • Position size and money at risk (in $ and as % of the account)
  • Planned reward-to-risk
  • Screenshot of the chart at entry

After the trade

  • Exit price, date and time
  • Result in $, in pips or points, and in R (multiples of the amount risked)
  • Exit reason: stop loss, take profit, manual exit, trailing stop, time stop
  • Did you follow your plan? Yes or no
  • Emotions before and during the trade (calm, rushed, fearful, overconfident, bored)
  • Mistakes (if any) and lessons
  • Screenshot of the chart at exit

What is "R"?

R is the amount you risked on the trade. If you risk $10 and make $25, the result is +2.5R. If you lose the full $10, it is –1R. Measuring results in R lets you compare trades of different sizes and on different instruments fairly.

Trading journal template

Copy these columns into Excel or Google Sheets. One row per trade.

ColumnExample entry
Trade #27
Date / time (IST)18 Nov 2026, 2:45 pm
InstrumentEUR/USD
DirectionBuy
TimeframeH4
SetupHammer at support
ReasonHammer swept below 1.1600 support and closed back above
Entry1.1625
Stop loss1.1595
Take profit1.1685
Stop distance30 pips
Size0.03 lot
Risk ($ / %)$9 / 0.9%
Planned R:R2:1
Exit1.1685
Exit reasonTake profit
Result ($ / pips)+$18 / +60 pips
Result (R)+2.0R
Followed plan?Yes
EmotionCalm, slightly impatient on day 2
MistakeNone
LessonWaiting for the H4 close avoided an early entry
ScreenshotsLink to entry and exit images

All prices in the example are example prices.

Useful formulas for your sheet

  • Stop distance (pips) = |Entry – Stop| ÷ pip size (0.0001 for most pairs, 0.01 for JPY pairs)
  • Result (R) = Result in $ ÷ Risk in $
  • Win rate = Number of winning trades ÷ total trades
  • Average win (R) and average loss (R) = average of the R column for wins and for losses
  • Expectancy (R per trade) = (Win rate × average win R) – (Loss rate × average loss R)

The forex lot size and pip calculator helps fill the size and risk columns.

The statistics that matter

After 30 to 50 trades, your journal starts to say something. These are the numbers to watch:

StatisticWhat it tells youExample
Win rateHow often you win45%
Average win (R)Size of typical winners+1.9R
Average loss (R)Size of typical losers (should be close to –1R)–1.05R
ExpectancyAverage result per trade in R(0.45 × 1.9) – (0.55 × 1.05) = +0.28R
Profit factorGross profit ÷ gross loss1.5
Max drawdownLargest fall from a peak in the account–8%
Plan adherence% of trades that followed the rules82%
Longest losing streakPrepares you for future streaks6 trades

All figures are illustrative examples, not results.

Win rate alone is misleading. A 40% win rate can be positive if winners average 2R. A 70% win rate can be negative if losers are far bigger than winners. Look at expectancy.

If your average loss is much bigger than –1R, you are moving stops, removing them or getting large slippage. Our stop loss in trading guide covers how to fix this.

Break the data down

The real value of a journal comes from slicing the results. Use filters or a pivot table to compare:

BreakdownQuestion it answers
By setupWhich setups make money? Which should I drop?
By instrumentDo I trade gold better than GBP/USD?
By timeframeAre my H4 trades better than my H1 trades?
By session / time of dayDo trades during the London session (from around 1:30 pm IST in winter) beat late-night trades?
By day of weekAre Fridays costly?
By "followed plan?"How do rule-following trades compare with impulse trades?
By emotionDo "rushed" or "bored" trades lose more?

Example breakdown by setup

All figures are illustrative examples.

SetupTradesWin rateAvg RExpectancy
Hammer at support1450%+1.8 / –1.0+0.40R
Shooting star at resistance944%+2.0 / –1.0+0.32R
Breakout without retest1225%+1.6 / –1.1–0.43R
Marubozu continuation850%+1.5 / –1.0+0.25R

In this example, the trader would stop taking breakouts without a retest and focus on the setups that show a positive expectancy. Read more about the patterns in our hammer candlestick pattern, shooting star candlestick pattern and marubozu candlestick pattern guides.

Screenshots: the most underrated part

Numbers tell you what happened. Screenshots show you why. Take one at entry and one at exit, with your levels drawn. When you review, look for things the numbers hide:

  • Were your best trades at clearly marked levels from the support and resistance trading process?
  • Did losing trades enter in the middle of a range?
  • Did you enter before the signal candle closed?
  • Was there major news on the calendar?

In MT5 you can save a chart image from the chart's right-click menu or the File menu on desktop. On mobile, a phone screenshot works.

Recording emotions and discipline

Many traders skip this column. It is often the most useful one. Use a short, consistent list so you can filter later:

LabelMeaning
CalmFollowed the plan, no pressure
RushedEntered quickly, fear of missing out
RevengeTrade taken to win back a loss
BoredTrade taken for activity, not a setup
FearfulClosed early or skipped a valid setup
OverconfidentIncreased size after wins

After a month, compare results by label. Many traders find that "revenge" and "bored" trades account for a large share of their losses.

How to review your journal

Daily (5 minutes)

  • Complete every field for trades closed today.
  • Add exit screenshots.
  • Write one line: what went well, what to improve.

Weekly (30 minutes)

  1. Total the week in R and in $.
  2. Count trades that broke your rules. What did they cost?
  3. Sort by setup. Which worked, which did not?
  4. Pick your best trade and your worst trade. What was different?
  5. Write one change for next week. Only one.

Monthly (1 hour)

  • Update the full statistics table: win rate, expectancy, profit factor, drawdown.
  • Check whether your average loss is close to –1R.
  • Decide whether to keep, adjust or drop each setup.
  • Review position size: is your risk per trade still right for your account?

Trading journal options: spreadsheet, app or notebook

OptionProsConsBest for
Spreadsheet (Excel / Google Sheets)Free, flexible, easy formulas and filtersManual entryMost traders
Dedicated trading journal appCharts and stats built in, some import tradesOften paid, less flexibleTraders with many trades
NotebookEncourages reflection, no screen neededHard to analyseWriting notes alongside a spreadsheet
MT5 history and reportsAccurate fills and resultsNo reasons, emotions or setupsChecking figures against your journal

Many traders combine methods: MT5 history for accurate numbers, a spreadsheet for analysis and a short written note for thoughts. The MT5 desktop terminal lets you view account history and generate a report from the History tab; check on the platform for export options on the Xellion app and WebTrader.

Common trading journal mistakes

MistakeWhy it hurtsBetter approach
Logging only some tradesBiased data; you skip the painful onesLog every trade, including demo trades
Filling it in days laterReasons and emotions are forgottenLog entries before or straight after entering
No setup labelsYou cannot compare strategiesUse a short, fixed list of setup names
Results only in $Different sizes distort the pictureAdd an R column
Too many fieldsYou stop keeping itStart with 10–12 columns, add later
Never reviewingA journal nobody reads changes nothingFixed weekly review time
Changing many things at onceYou cannot tell what helpedOne change per week

A simple plan to start this week

  1. Copy the template columns into a spreadsheet.
  2. Write your setup list (three to five setups maximum).
  3. Decide your risk per trade (many traders use 1%) and stop loss method.
  4. Log every trade, demo or live, for the next 30 trades.
  5. Hold a weekly review every weekend.
  6. After 30 trades, calculate expectancy by setup and keep only what works.

Pair your journal with a clear plan for each style. For example, our swing trading forex and intraday trading forex guides suggest timeframes and rules you can record and test.

Start your journal on a Xellion demo account

A demo account is the ideal place to build the journal habit, because you can log dozens of trades without risking money. Open the Xellion WebTrader in your browser, or use the Xellion app on iOS or Android, or MetaTrader 5, with a free demo account. Log every trade with the template above, review weekly, and only move to live trading once your journal shows a process you follow consistently.

When you are ready to go live, UPI deposits are instant from $50, and the Standard account needs a minimum first deposit of $50.

What is a trading journal?

A trading journal is a record of every trade you take, including the instrument, entry, stop loss, exit, result, reason for the trade and lessons learned. It helps you measure which setups and habits work for you.

What should I write in a trading journal?

At minimum: date, instrument, direction, setup, entry, stop loss, take profit, position size, money at risk, exit, result in $ and in R, whether you followed your plan, and a short note on emotions and lessons. Add entry and exit screenshots.

Is there a free trading journal template?

Yes. Copy the columns in the template table above into Excel or Google Sheets. It includes formulas for stop distance, R multiple, win rate and expectancy.

Should I use a trading journal app or a spreadsheet?

A spreadsheet is free and flexible and is enough for most traders. Apps can add automatic statistics and charts. Whichever you choose, the habit of logging every trade and reviewing weekly matters more than the tool.

How many trades do I need before the journal is useful?

Patterns start to appear after about 30 to 50 trades. For conclusions about a single setup, aim for at least 20 to 30 trades of that setup.

Should I journal demo trades?

Yes. Journalling demo trades builds the habit and tests your strategy before real money is at risk. Keep demo and live trades in separate tabs.

How often should I review my trading journal?

A quick daily update, a 30-minute weekly review and a monthly statistics check work well for most traders.

This article is general information and education, not investment advice. CFDs are complex instruments and carry a high risk of losing money rapidly due to leverage.

Ready to put it into practice?
Open an account in minutes, or practise on a free demo first.

Risk warning: CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. You should consider whether you understand how CFDs work and whether you can afford to take the high risk of losing your money. Blog articles are general information and education, not investment advice. Risk disclosure