Trading journal: how to keep one, template and key metrics

A trading journal is a systematic record of every trade (what you did, why, how much you risked, how it turned out and how you felt) that lets you measure your real edge and fix mistakes with data instead of impressions. It’s the foundation for calculating win rate, expectancy and drawdown, and for knowing whether your strategy works or you just had a good week. On prop firm accounts, it’s also the most direct tool for staying inside the daily loss limit and the consistency rule. Below you’ll find the template, the spreadsheet formulas and an example with 20 trades.

What is a trading journal for?

The market gives noisy feedback: a bad decision can end in profit and a good one in a loss. Without a record, you remember the trades that hurt most, not the ones that happen most often.

Learning research backs this up. Ericsson, Krampe and Tesch-Römer (1993) described deliberate practice as activity designed to improve a specific skill, with immediate feedback and repetition. Hattie and Timperley’s (2007) review of the power of feedback concludes that it works best when it answers three questions: where am I going, how am I doing and what’s next. A journal answers exactly that: plan, metrics and a correction for next week.

In practice, a journal does three concrete things:

• Tells you whether you have an edge: with 30 to 50 trades of one setup, you can estimate its expectancy.
• Separates the setup from the execution: a loss with the plan followed is a cost of doing business; entering without a signal is an avoidable mistake.
• Keeps the account rules in check: you know how much room you have left before the daily loss limit and the maximum drawdown.

The reasons evaluations get blown, which we break down in why traders fail at prop firms, show up in the journal first: overtrading, moving the stop or doubling size after a loss.

How to keep a trading journal: a template with the fields to log

The template should let you calculate metrics and take under a minute to fill in per trade:

Field	What to log	Example
Date and time	Entry date and time (New York time)	11/12/2026, 09:47
Instrument	Exact contract or pair	MNQ (Micro Nasdaq-100)
Setup	Short name of the pattern from your plan	Opening range breakout
Direction	Long or short	Long
Entry	Actual fill price	21,050.00
Stop	Initial stop price (not the moved one)	21,030.00
Target	Planned take profit price	21,090.00
Size	Contracts or lots	5 micros
Risk in USD	Distance to stop × point value × size	20 pts × USD 2 × 5 = USD 200
Result in USD	Profit or loss net of commissions	+USD 400
Resulting R	Result ÷ initial risk	+2.0R
Emotion	One word before and after entering	Calm / anxious
Plan adherence	Yes or No, and which rule was broken	Yes
Screenshot	Chart image with entry, stop and exit	Link to the file

The stop you log is the initial one: if you move it later, the R stops being comparable. And the plan adherence field only makes sense if you have a written plan; if you don’t have one yet, start with how to create your own trading plan.

Trading metrics to calculate every week

With the R column filled in (for example in K2:K21), the metrics come from simple Excel or Google Sheets formulas (depending on your regional settings, the separator may be a comma or a semicolon):

Metric	What it measures	Spreadsheet formula
Win rate (WR)	Percentage of winning trades	=COUNTIF(K2:K21,”>0″)/COUNT(K2:K21)
Average winning R	How much you make on average when you’re right	=AVERAGEIF(K2:K21,”>0″)
Average losing R	How much you lose on average when you’re wrong	=ABS(AVERAGEIF(K2:K21,”<0″))
Expectancy	Average expected result per trade, in R	(WR × average win) − ((1 − WR) × average loss)
Profit factor	Gross profit ÷ gross loss	=SUMIF(K2:K21,”>0″)/ABS(SUMIF(K2:K21,”<0″))
Maximum drawdown	Largest drop from a peak in the cumulative balance	A cumulative balance column and a running-peak column; drawdown is the largest gap between them
Best and worst day	Extreme daily results against the consistency rule and the daily limit	Pivot table by date; best day ÷ total profit

A high win rate isn’t enough: with a 70% win rate, 0.5R winners and 1.5R losers, expectancy is (0.7 × 0.5) − (0.3 × 1.5) = −0.10R.

Worked example: a week with 20 trades

Say a trader has a 50K simulated futures account with a USD 1,000 daily loss limit and USD 2,500 drawdown. They trade MNQ with 5 micros and a 20-point stop, so 1R = USD 200. They take 4 trades a day for 5 days:

Day	Trades (in R)	Day total	In USD	Running balance
Monday	+2 · −1 · −1 · +2.5	+2.5R	+500	+500
Tuesday	−1 · −1 · −1 · +1.5	−1.5R	−300	+200
Wednesday	+3 · −1 · +2 · −1	+3R	+600	+800
Thursday	−1 · −1 · +1.5 · −1	−1.5R	−300	+500
Friday	+2 · +1.5 · −1 · +2	+4.5R	+900	+1,400

Here’s how the week’s metrics come out:

• Win rate: 9 winners out of 20 = 45%.
• Average winning R: 18R ÷ 9 = 2.0R. Average losing R: 11R ÷ 11 = 1.0R.
• Expectancy: (0.45 × 2.0) − (0.55 × 1.0) = 0.90 − 0.55 = +0.35R per trade, about USD 70 with 1R = USD 200. That matches the total result: 7R over 20 trades.
• Profit factor: 18R ÷ 11R = 1.64.
• Maximum drawdown: trade by trade, the balance goes from a +2.5R peak on Monday to −0.5R on Tuesday, a drop of 3R (USD 600), 24% of the account’s drawdown.
• Worst day: −USD 300, 30% of the daily limit.
• Best day vs consistency: Friday contributed USD 900 of USD 1,400, or 64% of the profit. Under a 50% consistency rule, that day weighs too much: to balance it out, total profit would need to reach USD 1,800 without any day exceeding USD 900.

The week was good on expectancy and risk, but without the journal the trader wouldn’t know they still don’t meet the consistency rule. Check your account rules for how that percentage is calculated.

How to do your weekly trading journal review

Set aside 30 to 45 minutes outside market hours, say on Saturday, and always follow the same order:

1. Complete the data: compare the spreadsheet with the exported history so no trade or commission is missing.
2. Calculate the metrics: win rate, average R, expectancy, profit factor, maximum drawdown, best and worst day.
3. Split by adherence: calculate expectancy for the trades where you followed the plan and, separately, for the ones that broke a rule. The difference is what your discipline mistakes cost you.
4. Split by setup and time of day: a setup with negative expectancy over 30 or more trades deserves a review or a pause.
5. Review the screenshots of your three best and three worst trades and look for what they had in common.
6. Write down one measurable correction for next week, such as “no trading after two losses in a row” or “no entries before 9:45 a.m. New York time.”

This loop is what sustains the consistency evaluation accounts demand; we cover it in depth in trading discipline on prop firm evaluation accounts.

Tools: spreadsheet, Excel trading journal and platform exports

You don’t need paid software to start: an Excel or Google Sheets spreadsheet covers everything. Export prices and results from your platform and add only the qualitative fields (setup, emotion, adherence, screenshot) by hand.

Tool	How to export your history	Format
Tradovate	Reports icon → Performance tab (or Orders) → choose the date range → Go → download	CSV (Performance also as PDF)
cTrader Desktop	History tab → date range and account → Statement button → choose format	Excel (XLSX) or HTML; according to cTrader support, the Excel option is in the Windows desktop version

Common trading journal mistakes

• Filling it in days later: the emotion and the reason for entry get conveniently rewritten.
• Not logging the initial risk: without risk in USD there’s no R, and without R there’s no comparable expectancy.
• Switching setups after 10 trades: that sample can’t tell a bad streak from a strategy with no edge.
• Measuring only the USD result: a winning week with the plan broken is still a bad week.
• Creating 40 columns: an overly long journal gets abandoned within two weeks.

A trading log for funded traders: remaining daily limit and drawdown

On a prop firm account, your journal should tell you before every trade how much room you have left. Add these columns:

Extra column	Calculation	Use
Remaining daily limit	Allowed daily loss + day’s result so far	If the next trade’s risk exceeds this value, don’t trade
Remaining drawdown	Current balance − current liquidation level	Sets the maximum prudent size
Liquidation level	Depends on drawdown type: fixed if static; recalculated at the close if EOD	Update it every day at the close
Best day / total profit	Largest daily profit ÷ cumulative profit	Track the consistency rule

Using the example above: if you’re down USD 600 after three losses, your remaining daily limit is USD 400, just 2R. A useful rule: stop trading when the remaining limit drops below 2R. If your drawdown is EOD, remember that the liquidation level rises with closes at new highs; the difference is explained in EOD vs static drawdown.

The pressure of the daily limit changes how you trade; logging your emotion on a 1-to-5 scale helps you stop in time. In funded trader psychology you’ll find techniques to handle it.

Your trading journal on Emerge Profit accounts

Emerge Profit’s simulated trading accounts have a daily loss limit, a maximum drawdown, a 50% consistency rule (Futures Instant Funding also offers 30%) and consistent position sizing. Your journal lets you track each one:

• Futures Evaluation (from $60): EOD drawdown and 5 minimum days; on the 50K, a USD 2,500 target and USD 1,100 daily loss limit. On Tradovate, NinjaTrader or TradingView. Positions are closed before the end of each session.
• Futures Instant Funding (from $130): no evaluation phase; on the 50K Classic, a USD 1,000 daily loss limit and USD 2,500 EOD or static drawdown, the same figures used in this article’s example.
• EmergeFX Evaluation (from $68): currencies, indices and commodities in 1-Step or 2-Step, on cTrader or DXtrade. Static drawdown and weekend holding allowed.
• EmergeFX Instant Funding (from $120): static drawdown, so the liquidation level in your journal never changes.

Before you buy an account, keep the journal for at least two weeks on a demo using the rules of the account you’ve chosen.

Trading journal FAQ

Sources

• Ericsson, K. A., Krampe, R. T. and Tesch-Römer, C. (1993). The role of deliberate practice in the acquisition of expert performance. Psychological Review, 100(3), 363-406 (accessed November 2026).
• Hattie, J. and Timperley, H. (2007). The Power of Feedback. Review of Educational Research, 77(1), 81-112 (accessed November 2026).
• FundedNext Futures – How to check your trading performance in Tradovate (accessed November 2026).
• Blueberry Markets – cTrader: how to download trading account statements (accessed November 2026).
• cTrader Community – Downloadable trading statement in Excel / CSV format (September 2024).

Emerge Profit · Simulated funded accounts

Choose how to start: with an evaluation or with instant access

Lowest cost

Futures Evaluation

from $60

Pass a simulated evaluation with no activation fee and keep 100% of your first rewards once you are funded.

View evaluations

Most popular

Futures Instant Funding

from $130

No evaluation: trade from day one on NinjaTrader, Tradovate or TradingView with no platform license fee.

View Instant Funding

Lowest cost

EmergeFX Evaluation

from $68

1-step or 2-step evaluations on cTrader or DXtrade, with clear rules and no time limit.

View evaluations

Most popular

EmergeFX Instant Funding

from $120

Instant access on cTrader or DXtrade, with no evaluation phase.

View Instant Funding

✔ 4 years in the market · Dedicated support · Instant activation

Emerge Profit provides simulated trading accounts for educational and evaluation purposes. We are not a broker and we do not manage client funds. Prices shown are promotional and may change.