Free download

Free Trading Journal Template

A free Excel and Google Sheets trading journal built for futures and prop firm traders. Log your trades and get your stats, drawdown and consistency rule calculated automatically.

  • Journal sheet with dropdowns for side, exit reason, plan and emotion
  • Automatic stats: net P&L, win rate, profit factor, average win and loss
  • Prop firm rules sheet: trailing drawdown floor and drawdown left
  • Consistency rule check with the net profit you still need
  • Daily P&L summary built from your trades
  • Works in Excel and Google Sheets

How do I start a trading journal?

Start simple: log every trade the same day, with the result and one honest line about why you took it. Consistency matters more than detail. A journal you fill in every day beats a perfect one you abandon in a week.

  1. Download the template and delete the example rows.
  2. Enter your account rules: starting balance, max drawdown, daily loss limit and consistency threshold.
  3. After each trade, log the result, exit reason, whether you followed your plan and how you felt.
  4. Once a week, review your stats and look for the mistake you repeat most.

What should I track as a prop firm trader?

Beyond P&L, track the numbers your firm grades you on: how much drawdown you have left, your daily loss, and how much of your profit came from your best day (the consistency rule). A profitable strategy can still fail an evaluation if one of these rules breaks.

Spreadsheet or trading journal app?

A spreadsheet is free and flexible, and it's a great way to build the habit. A journal app saves you the manual work: Zentrade imports NinjaTrader, Rithmic and Tradovate files, tracks each account's rules automatically and, on ZenMode, warns you during your session before you break a rule. Zentrade also has a free plan.

FAQ

What should a trading journal include?

At minimum: date, instrument, side, size, entry and exit time, result, exit reason, whether you followed your plan, your emotion and notes. Those last three are what reveal the patterns that cost you money.

Does this template work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas work in Excel 2019 or later, Excel for Microsoft 365 and Google Sheets.

Is a spreadsheet good enough for a prop firm evaluation?

It's a solid start. The limits show up when you trade several accounts, want to import trades from your platform, or need a warning during your session before you break a rule. That's what a dedicated journal like Zentrade adds.

How often should I fill in my trading journal?

After every trade, or at least at the end of every session while the details are fresh. Weekly reviews of your journal are where you find your best hours, setups and the mistakes you repeat.

Is the template free?

Yes, it's free with no sign-up. You can also use Zentrade's free plan, which journals your trades and tracks your prop firm rules automatically.

Related guides and tools

Stop calculating by hand

Zentrade tracks your consistency rule, trailing drawdown and daily loss limit on every account automatically. Free plan forever, no credit card.