Free trading journal templates
Built for currency traders: log every pair with its session and pip distance, and the sheet calculates R-multiple, P&L, win rate and profit factor for you.
For spot and perpetual traders: track exchange, leverage and fees next to every entry, so your real R after costs is never a guess.
Made for ES, NQ, CL and GC traders: log contracts and ticks per trade, and let the summary show which markets actually pay you.
Track calls, puts and spreads with strike, expiry and premium, while keeping one consistent risk unit (R) so results compare across strategies.
For swing and position traders in shares: log sector and catalyst with each trade, then see which kinds of setups actually make you money.
Intraday traders live and die by timing. Log entry and exit times with each trade, then spot the hours where you trade best — and worst.
For trades that last days or weeks: log the timeframe and holding period, so you learn whether patience or quick exits serve you better.
Passing a challenge is about not breaking the rules. Track your running balance against daily loss and max drawdown limits after each trade.
Gold moves on news and sessions. Record the session, any news event and whether the market was trending or ranging with every trade.
Scalpers take many small trades, so costs and hold time matter. This sheet keeps it fast: one row per trade, with spread and seconds held.
Your results follow your state of mind. Score sleep and focus, note how you felt before and after, and see which emotions cost you R.
Most losses come from a few repeated mistakes. Log each one with its cost in R, and the rule you will follow next time.
One review a week is where the real learning happens. Fill in one row each weekend: results, best and worst trade, and one focus for next week.
Write your rules down before the market opens. Set risk per trade, daily and weekly loss limits, and the exact rules for entries and exits.
For long-term investors who want more than numbers: track each holding with your thesis, dividends received and how the position is doing.
Spreadsheet or journal app?
A spreadsheet is a great way to start. It gets slow once you have hundreds of trades, want screenshots next to each one, or want stats by strategy and emotion. Simple Trading Journal reads entry, stop loss and target from a chart screenshot and does the stats for you. It has a 14-day free trial and costs from €5/month.
Frequently asked questions
- Are the templates really free?
- Yes. Every template downloads instantly as Excel, CSV (for Google Sheets) and PDF. No email, no account, no payment.
- How do I use a template in Google Sheets?
- Download the Excel file and open it in Google Sheets with File → Import, or import the CSV file. The formulas work in both Excel and Google Sheets.
- What does the R multiple column mean?
- R is your result measured in units of the risk you took. A trade that risked 1% and made 2% is +2R. The sheet calculates it from entry, stop loss and exit.
- Can I move my spreadsheet trades into an app later?
- Yes. The CSV columns match the CSV import in Simple Trading Journal, so you can bring your history with you when a spreadsheet gets too slow.
Stop guessing. Start journaling.
Log a trade from a chart screenshot in seconds. 14-day free trial, Pro from €5/month.
