Save up to 30% on your prop firm eval with codeSave up to 30% with codeTP1See all deals →← Back to TP1

Learn

Trading journal template

A trading journal is only as useful as what you write in it. This template lists the fields to log on every trade, with an example for each and why it matters, then the daily and weekly notes that go around the trades and the numbers to review at the end of each week. It is written for futures day traders (NQ, ES, GC and their micros) and works in any spreadsheet.

The fields to log on every trade

One row per trade. The first fields are the facts of the trade; the last ones are your read of it, which is where most of what a journal teaches comes from.

FieldExampleWhy log it
Date2026-06-10The day the trade counts on.
Entry time09:35In New York time, so trades line up with the session they belong to.
Exit time09:52With the entry time, it gives how long you held the trade.
InstrumentNQThe contract you traded: NQ, ES, GC or a micro like MNQ.
DirectionLongLong or short.
Size2Contracts. A blank size counts as 1 in the import.
Entry price20000.25Your average fill in.
Exit price20020Your average fill out. Leave it blank while the trade is open.
Stop19990Where you were wrong. Without it you can't work out the trade's R.
Risk ($)410What you stood to lose at the stop, the base of the R multiple.
Net P&L ($)785After fees and commissions. A journal that mixes gross and net figures can't be compared week to week.
Fees ($)5Commissions and exchange fees for the trade.
R multiple1.9Net P&L divided by the risk. It lets a 1-contract trade and a 4-contract trade be read on one scale.
Account50K evaluationWhich evaluation or personal account the trade fired on, so each account's rules can be checked on its own trades.
Setup (playbook)1m FVG after a sweepThe setup you meant to trade. Results by setup are the most useful view a journal gives.
Rules followed3 of 4How many of that setup's written rules you kept on this trade.
ConfluencesFVG, sweep of the Asia lowWhy you took it: what lined up on the chart.
MistakesChased the entryWhat went wrong, named, so the same one can be counted next week.
NotesWaited for the closeWhat you saw and felt, in a sentence or two.
ScreenshotLink to the chartThe chart at entry, so the review is of what you saw, not what you remember.

Log every trade, the losers and the ones you would rather forget included. A journal with only the good trades in it describes a trader who doesn’t exist.

Download the template as a CSV

Download the trading journal template (CSV). It opens in Excel, Google Sheets or Numbers, with these columns and a few example rows to replace:

Date,Time,Symbol,Side,Quantity,Entry,Exit,PnL,Setup,Notes

Add the other fields from the table above as columns of your own. The file uses the column names the Taking Prophets journal’s CSV import reads, so the trades you keep in a spreadsheet can be imported later without retyping them. The import also accepts Net PnL, Fees, Exit date and Exit time columns.

Before the open and after the close

Trades are half of a journal. The other half is one short entry per day:

  • Before the open: the levels you are watching, your bias, what you will trade and what you will skip.
  • After the close: what you did well, and the one thing you will fix tomorrow.
  • Across the day: a mistake that covers the whole day, like trading through a news release, goes here rather than on one trade.

Setups and rules

Give each setup you trade a name and write its rules down, one line each, like “Waited for the FVG” or “Entered inside the killzone”. On every trade, note how many of the rules you kept: 3 of 4, 4 of 4. Over a few weeks that column answers a question the P&L can’t: whether your losing trades came from the setup or from not following it.

Keep three kinds of tag apart: confluences (why you took it), execution (how you traded it, like “Followed plan”) and mistakes (what went wrong, like “Chased”). Mixed together, they can’t be counted.

What to review each week

Once a week, filter the week’s closed trades and work out:

  • Net P&L: The total of your closed trades, after fees.
  • Win rate: Winners divided by all closed trades. Break-evens count in the total, so they pull it down.
  • Profit factor: Dollars won on winners divided by dollars lost on losers. 1.0 is break-even.
  • Day win rate: Green days divided by every day with a closed trade.
  • Average win ÷ average loss: Your average winner divided by your average loser. 1.5 means the average win is one and a half times the average loss.

Then three questions the numbers point to:

  • What did the week net without its worst day? If one day decides the week, that day is the thing to review.
  • Which setup carried the week, and which cost it? Sort the trades by the setup column and total each one.
  • Which mistake came up most? Count the mistake tags. One named mistake is easier to stop than a vague bad week.

Plot the running total of net P&L by week as well: an equity curve shows a slow leak that a single week’s numbers hide.

A spreadsheet or a trading journal app

A spreadsheet works, and this template is enough to start. What it asks of you is the arithmetic: the R on each trade, the fees, and the weekly figures, done by hand or with formulas you maintain.

The free Taking Prophets trading journal fills these fields in for you. Net P&L is worked out from your prices for NQ, ES, GC and the other common futures, the R comes from your stop, and it shows your win rate, profit factor, equity curve and a Prophet Score, a 0 to 100 blend of win rate, profit factor, payoff, consistency and drawdown control. It has playbooks with rules to tick off, the three tag groups, a daily notebook and a weekly digest, and it imports this template’s CSV. How each part works is in the Journal docs.

Educational content. A journal records what you did; it doesn’t predict what you will do. Futures trading involves substantial risk of loss. See our risk disclosures.