On this page
- Why keep a trading journal?
- What to record in a trading journal
- Before the trade
- After the trade
- What is "R"?
- Trading journal template
- Useful formulas for your sheet
- The statistics that matter
- Break the data down
- Example breakdown by setup
- Screenshots: the most underrated part
- Recording emotions and discipline
- How to review your journal
- Daily (5 minutes)
- Weekly (30 minutes)
- Monthly (1 hour)
- Trading journal options: spreadsheet, app or notebook
- Common trading journal mistakes
- A simple plan to start this week
- 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 journal | With 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 mistakes | Spot 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.
| Column | Example entry |
|---|---|
| Trade # | 27 |
| Date / time (IST) | 18 Nov 2026, 2:45 pm |
| Instrument | EUR/USD |
| Direction | Buy |
| Timeframe | H4 |
| Setup | Hammer at support |
| Reason | Hammer swept below 1.1600 support and closed back above |
| Entry | 1.1625 |
| Stop loss | 1.1595 |
| Take profit | 1.1685 |
| Stop distance | 30 pips |
| Size | 0.03 lot |
| Risk ($ / %) | $9 / 0.9% |
| Planned R:R | 2:1 |
| Exit | 1.1685 |
| Exit reason | Take profit |
| Result ($ / pips) | +$18 / +60 pips |
| Result (R) | +2.0R |
| Followed plan? | Yes |
| Emotion | Calm, slightly impatient on day 2 |
| Mistake | None |
| Lesson | Waiting for the H4 close avoided an early entry |
| Screenshots | Link 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:
| Statistic | What it tells you | Example |
|---|---|---|
| Win rate | How often you win | 45% |
| Average win (R) | Size of typical winners | +1.9R |
| Average loss (R) | Size of typical losers (should be close to –1R) | –1.05R |
| Expectancy | Average result per trade in R | (0.45 × 1.9) – (0.55 × 1.05) = +0.28R |
| Profit factor | Gross profit ÷ gross loss | 1.5 |
| Max drawdown | Largest fall from a peak in the account | –8% |
| Plan adherence | % of trades that followed the rules | 82% |
| Longest losing streak | Prepares you for future streaks | 6 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:
| Breakdown | Question it answers |
|---|---|
| By setup | Which setups make money? Which should I drop? |
| By instrument | Do I trade gold better than GBP/USD? |
| By timeframe | Are my H4 trades better than my H1 trades? |
| By session / time of day | Do trades during the London session (from around 1:30 pm IST in winter) beat late-night trades? |
| By day of week | Are Fridays costly? |
| By "followed plan?" | How do rule-following trades compare with impulse trades? |
| By emotion | Do "rushed" or "bored" trades lose more? |
Example breakdown by setup
All figures are illustrative examples.
| Setup | Trades | Win rate | Avg R | Expectancy |
|---|---|---|---|---|
| Hammer at support | 14 | 50% | +1.8 / –1.0 | +0.40R |
| Shooting star at resistance | 9 | 44% | +2.0 / –1.0 | +0.32R |
| Breakout without retest | 12 | 25% | +1.6 / –1.1 | –0.43R |
| Marubozu continuation | 8 | 50% | +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:
| Label | Meaning |
|---|---|
| Calm | Followed the plan, no pressure |
| Rushed | Entered quickly, fear of missing out |
| Revenge | Trade taken to win back a loss |
| Bored | Trade taken for activity, not a setup |
| Fearful | Closed early or skipped a valid setup |
| Overconfident | Increased 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)
- Total the week in R and in $.
- Count trades that broke your rules. What did they cost?
- Sort by setup. Which worked, which did not?
- Pick your best trade and your worst trade. What was different?
- 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
| Option | Pros | Cons | Best for |
|---|---|---|---|
| Spreadsheet (Excel / Google Sheets) | Free, flexible, easy formulas and filters | Manual entry | Most traders |
| Dedicated trading journal app | Charts and stats built in, some import trades | Often paid, less flexible | Traders with many trades |
| Notebook | Encourages reflection, no screen needed | Hard to analyse | Writing notes alongside a spreadsheet |
| MT5 history and reports | Accurate fills and results | No reasons, emotions or setups | Checking 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
| Mistake | Why it hurts | Better approach |
|---|---|---|
| Logging only some trades | Biased data; you skip the painful ones | Log every trade, including demo trades |
| Filling it in days later | Reasons and emotions are forgotten | Log entries before or straight after entering |
| No setup labels | You cannot compare strategies | Use a short, fixed list of setup names |
| Results only in $ | Different sizes distort the picture | Add an R column |
| Too many fields | You stop keeping it | Start with 10–12 columns, add later |
| Never reviewing | A journal nobody reads changes nothing | Fixed weekly review time |
| Changing many things at once | You cannot tell what helped | One change per week |
A simple plan to start this week
- Copy the template columns into a spreadsheet.
- Write your setup list (three to five setups maximum).
- Decide your risk per trade (many traders use 1%) and stop loss method.
- Log every trade, demo or live, for the next 30 trades.
- Hold a weekly review every weekend.
- 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.
- Open a free demo account
- Compare account types · Funding options · Platforms
- New to MT5? MT5 download, login and setup guide
- Related reading: price action trading, candlestick patterns guide, stop loss in trading, ATR indicator guide
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.



