Free trading journal template
One row per trade. Net P&L, planned risk and R multiple are worked out for you, and a summary tab shows your win rate, your best and worst setups and weekdays, and what breaking your rules is costing you. Works in Excel and Google Sheets.
Free, no email needed. Includes three example rows from a sample futures journal; delete them when you start.
What's in it
Date, entry and exit time
When the trade happened, for the weekday and time-of-day view.
Account and instrument
Keeps several prop or personal accounts apart.
Direction, contracts, entry, exit
The trade itself.
Stop price
Turns into your planned risk, so every trade gets an R multiple.
Point value and fees
ES 50, NQ 20, MNQ 2, CL 1000; shares 1. Net P&L is worked out for you.
Setup
From a drop-down you edit, so the summary can rank your setups.
Rules broken
Moved stop, revenge trade, size too big… The summary shows what they cost.
Emotion and notes
How you felt, and one honest sentence about the trade.
How to keep it going past week two
- Fill it in the same day. Ten minutes after the close beats an hour on Sunday. Memory of why you took a trade fades within hours.
- Always set a stop price. Without it there is no planned risk and no R multiple, and those are what make different days comparable.
- Be honest in Rules broken. It is the column that pays: after a month, the summary shows what moved stops and revenge trades actually cost you.
- Read the summary weekly. One setup to keep, one habit to stop. That is enough.
Most spreadsheets still go quiet after a couple of weeks, because typing up every trade after a long session is tiring. If that is where yours stops, Afterfill fills the same columns for you: it imports every fill from your platform and turns a few seconds of your voice at entry and exit into the setup, the rule you broke and the note. You can import this file into it later, so nothing is lost.
Template questions
Does it work in Google Sheets?
Yes. In Google Drive choose New → File upload, open the .xlsx with Google Sheets, and the formulas and drop-downs keep working. Or use File → Import in an existing sheet.
What does the summary show?
Number of trades, net P&L, win rate, average win and loss, profit factor, average R, what the trades where you kept your rules made versus the ones where you broke one, and P&L by setup and by weekday.
Can I use it for forex or stocks?
Yes. Put the dollar value of a 1.0 price move in Point value: 1 for shares, 100,000 for one lot of EURUSD (so a 0.0001 move is $10), and so on. The rest works the same.
Can I move it into Afterfill later?
Yes. The column names match what Afterfill's journal import recognises: choose Import trades → From another journal and drop the file. Your setups, broken rules, emotions and notes come along.
Or let the journal fill itself in.
Afterfill imports your fills and writes the journal from a few seconds of your voice at entry and exit.