Trading Journal Template for Prop Traders (Free Columns to Copy)

Key takeaways

• A journal turns your trading into data you can improve: setups, risk, results and mistakes.
• Track risk as a percentage of the account and your daily result against the loss limits.
• Review weekly and change only one thing at a time.
• Your journal tells you when you are ready for a challenge, a payout or a larger account.

Every consistently funded trader keeps some kind of journal. Not because writing things down is fun, but because it is the only reliable way to know what is working. This guide gives you a simple journal template designed for prop firm accounts, with the columns that matter for loss limits, payouts and the consistency rule.

Why prop traders need a journal

• Loss limits punish patterns, not single trades. A journal shows the patterns.
• Consistency rules depend on how your profit is spread across days.
• Your memory is biased. Without records, you remember big wins and forget small rule breaks.
• It tells you when to scale and when to slow down.

The template: columns to copy

Create a spreadsheet with one row per trade and these columns:

1. Date and time (and session: Asia, London or New York).
2. Account (for example Two Step $50K, Phase 1).
3. Instrument (EUR/USD, gold and so on).
4. Direction (long or short).
5. Setup name from your written plan.
6. Entry, stop and target prices.
7. Position size in lots.
8. Risk in $ and as % of the account.
9. Result in $ and in R (result divided by the amount risked).
10. Followed the plan? Yes or no.
11. Emotion before the trade (calm, rushed, frustrated, confident).
12. Screenshot link of the chart at entry and exit.
13. One-line note: what you would do the same or differently.

The daily summary

Add a second sheet with one row per day:

• Day’s result in $ and %.
• Distance from the daily loss limit at the worst point of the day.
• Distance from the maximum loss limit at the close.
• Number of trades and number that followed the plan.
• Best day so far in the payout cycle, and its share of total profit (for the consistency rule).

Put your journal to work on a funded account with no time limit.
See One Step rules →

The numbers that matter

Once you have 50 to 100 trades, calculate:

• Win rate: winning trades ÷ total trades.
• Average win and average loss in dollars or R.
• Expectancy: (win rate × average win) − (loss rate × average loss).
• Longest losing streak: the key number for sizing against your maximum loss limit.
• Worst day: compare it with your account’s daily limit.
• Rule-break rate: how often you did not follow the plan, and what those trades cost.

For a worked example of expectancy, see How to Become a Consistently Profitable Funded Trader.

Your weekly review

1. What was my result, and how did it compare with my expectancy?
2. Which setup, pair or session performed best and worst?
3. How many trades broke a rule, and what did they cost?
4. How close did I come to any loss limit?
5. What is the one change I will make next week?

Change one thing at a time. If you change several, you will not know which one helped.

Using the journal to make decisions

• Ready for a challenge? Positive expectancy over at least 100 trades, and a longest losing streak your risk per trade can survive within the maximum loss limit.
• Ready for a payout? Your best-day share is within the consistency rule for your account.
• Ready to scale? Several profitable payout cycles with no near-breaches. See how to scale a funded account.
• Time to slow down? Rising rule breaks or worst days creeping toward the daily limit.

[position-size-calculator]

Tips to keep journaling

• Log trades immediately, before you look for the next one.
• Keep it short. Thirty seconds per trade is enough.
• Use screenshots instead of long descriptions.
• Review on the same day each week, for example Saturday morning.
• Let tools help. Analytics such as Clarity Tracking can show patterns quickly, but the notes on why you took a trade are yours to write.

Turn your journal into a funded track record.
Explore Funded Trading Accounts →

Frequently asked questions

Should I use a spreadsheet or an app?

Either works. A spreadsheet is free and flexible; an app can save time. What matters is that you record every trade and review it.

How many trades before the stats mean anything?

At least 50, and ideally 100 or more of the same setup.

Should I journal losing trades differently?

No. Record every trade the same way. The note on whether you followed the plan matters more than the result.

What is R in a trading journal?

R is your result divided by the amount you risked. A trade that risked $250 and made $500 is +2R. It lets you compare trades of different sizes.