Free Trading Journal Templates

43 free trading journal templates for Excel, Google Sheets, Notion, and PDF. Used by 15,000+ traders worldwide. Download and start tracking today.

Free Download No Signup Ready to Use

A trading journal template is a pre-built spreadsheet or document that helps you log every trade you make. Whether you're day trading stocks, swing trading forex, or investing in options, keeping a detailed trading log is essential for improving your performance. These free trading spreadsheet templates give you a structured way to record entry and exit prices, position sizes, profit and loss, and the reasoning behind each trade.

Unlike pen-and-paper journals, a digital trade tracker template automatically calculates key metrics like win rate, average return, and risk-reward ratio. By reviewing your trading log template weekly, you can identify patterns in your trading behavior—which setups work best, which times of day you perform well, and which mistakes cost you money. Download a template below and start building the data-driven foundation for better trading decisions.

Airtable Trading Journal
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Airtable Trading Journal

A pre-built Airtable base with four linked tables, R-multiple formulas, and rollup views for win rate and expectancy. Free download, no account required.

Get Template — $5
Algorithmic Trading Log Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Algorithmic Trading Log Spreadsheet

Track algo strategy parameters, compare backtest vs live performance, and monitor slippage with this free Excel trading log template.

Get Template — $5
Backtesting Log Spreadsheet.xlsx
B I U
$ %
fx
#SetupSymbolWin?R:RNotes
1 1 Bull Flag AAPL Yes 2.1:1 Clean break
2 2 VWAP Rev TSLA No 0:1 Late entry
3 3 ORB NVDA Yes 3.2:1 A+ setup
Excel

Free Backtesting Log Spreadsheet

Download our free backtesting log spreadsheet. Document strategy tests, track historical results, and validate your trading edge.

Get Template — $5
CFD Trading Journal Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free CFD Trading Journal Spreadsheet

Track CFD trades with leverage, margin, overnight financing, and spread costs. Free Excel template for UK, EU, and AU traders.

Get Template — $5
Commodity Trading Journal.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Commodity Trading Journal Excel

Download a free Excel commodity trading journal with fields for contract specs, margin, rollover dates, and seasonal patterns. Track oil, gold, and...

Get Template — $5
Crypto Portfolio & Trade Tracker Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Crypto Portfolio & Trade Tracker Spreadsheet

Track trades across Binance, Coinbase, Kraken, Bybit, and Uniswap in one Excel spreadsheet. Includes DeFi, gas fees, staking, and capital gains.

Get Template — $5
Crypto Trading Journal
B I U
$ %
fx
DateCoinSideSizePriceP&L
1 03/07 BTC Long 0.15 $67,420 +$1,240
2 03/06 ETH Short 2.5 $3,890 -$380
3 03/05 SOL Long 45 $142.30 +$890
Google Sheets

Free Crypto Trading Journal Google Sheets - Download

Download our free crypto trading journal for Google Sheets. Track multiple coins, exchanges, and 24/7 trading with cloud access anywhere.

Get Template — $5
Day Trading Excel Journal with P&L Tracker.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Day Trading Excel Journal with P&L Tracker

Download a free Excel day trading journal with session time bucketing, commission tracking, and daily P&L formulas built for active retail traders.

Get Template — $5
Earnings Season Tracker Spreadsheet
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Earnings Season Tracker Spreadsheet - Download

Track EPS beats, IV crush, and post-earnings price moves in one Google Sheets template. Measure your real accuracy on earnings plays across every season.

Get Template — $5
ETF Trading Journal Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free ETF Trading Journal Spreadsheet

Download a free Excel spreadsheet to track ETF trades with expense ratios, sector exposure, leveraged ETF tracking, and NAV vs price analysis.

Get Template — $5
Forex Position Sizing & Lot Size Worksheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Forex Position Sizing & Lot Size Worksheet

Excel worksheet for forex lot size calculation, pip value by pair, and multi-pair correlation risk tracking. Free download, no account required.

Get Template — $5
Forex Trading Journal.xlsx
B I U
$ %
fx
DatePairSideLotsPipsP&L
1 03/07 EUR/USD Long 0.50 +42 +$210
2 03/06 GBP/JPY Short 0.30 -28 -$84
3 03/05 USD/CHF Long 0.40 +65 +$260
Excel

Free Forex Trading Journal Excel - Download

Download our free forex trading journal spreadsheet. Track currency pairs, pip P&L, session analysis, and forex-specific metrics.

Get Template — $5
Futures Trading Journal.xlsx
B I U
$ %
fx
DateContractSideLotsTicksP&L
1 03/07 ES Long 2 +18 +$900
2 03/06 NQ Short 1 -12 -$240
3 03/05 CL Long 3 +22 +$660
Excel

Futures Trading Journal

Free futures trading journal for Excel. Track contract specs, margin usage, rollover dates, and multi-contract P&L for futures traders.

Get Template — $5
Forex Lot Size Calculator Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Forex Lot Size Calculator Spreadsheet

Download a free Excel lot size calculator for forex. Input account balance, risk percentage, and stop loss to calculate standard, mini, and micro lots.

Get Template — $5
Market Analysis Worksheet.pdf
Market Analysis Worksheet
Date: _______________
03/07 AAPL
03/06 TSLA
03/05 NVDA
03/04 AMD
Notes
PDF

Free Market Analysis Worksheet

Structured four-layer top-down market analysis worksheet covering macro conditions, sector rotation, intermarket signals, and stock screener criteria.

Get Template — $5
Monthly Performance Report
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Monthly Performance Report

Download a free monthly trading performance report template for Google Sheets or Excel. Track 7 core metrics, setup-level P&L, and written reflection.

Get Template — $5
Notion Trading Dashboard
Notion Trading Dashboard
Table Board Calendar
DateSymbolSideEntryExitP&L
03/07 AAPL Long $182.40 $184.10 +$340
03/06 TSLA Short $248.60 $250.20 -$160
03/05 NVDA Long $875.30 $882.50 +$720
Notion

Free Notion Trading Dashboard

A ready-to-use Notion trading journal template with three linked databases, copy-paste formulas, and filtered views for P&L, R-multiple, and setup tracking.

Get Template — $5
Options Trading Journal.xlsx
B I U
$ %
fx
DateSymbolTypeStrikeExpP&L
1 03/07 SPY Call $510 03/15 +$680
2 03/06 AAPL Put $180 03/22 -$220
3 03/05 TSLA Call $250 03/15 +$1,240
Excel

Free Options Trading Journal Excel - Download

Download our free options trading journal spreadsheet. Track Greeks, expiration, premium decay, and options-specific metrics.

Get Template — $5
Penny Stock Journal Download.xlsx
B I U
$ %
fx
DateTickerSideSharesAvgP&L
1 03/07 MULN Long 5,000 $0.84 +$420
2 03/06 BBIG Long 3,000 $1.22 -$180
3 03/05 SNDL Long 8,000 $0.56 +$640
Excel

Penny Stock Journal Download

Free penny stock trading journal template. Track catalyst plays, volume spikes, float analysis, and manage risk in volatile small-cap trades.

Get Template — $5
Position Sizing Calculator Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Position Sizing Calculator Spreadsheet

Download a free Excel position sizing calculator with fixed fractional, Kelly criterion, and volatility-based methods. Input risk and get exact share counts.

Get Template — $5
Position Sizing Worksheet
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Position Sizing Worksheet - Download

Download a free position sizing worksheet for stocks, futures, and options. Pre-built formulas calculate exact share count, contract size, and dollar risk.

Get Template — $5
Post-Trade Review
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Post-Trade Review - Download

Download a free post-trade review template with the exact fields that separate improving traders from stagnant ones. Google Sheets and PDF formats included.

Get Template — $5
Pre-Trade Checklist
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Pre-Trade Checklist - Download

Download a free pre-trade checklist template covering the five binary gates every trade must pass before capital is committed. PDF and Google Sheets versions.

Get Template — $5
Prop Firm Trading Journal.xlsx
B I U
$ %
fx
DateSymbolSideRisk%TargetP&L
1 03/07 ES Long 0.5% 2:1 +$480
2 03/06 NQ Short 0.3% 3:1 -$150
3 03/05 GC Long 0.5% 2:1 +$720
Excel

Prop Firm Trading Journal

Free prop firm trading journal template for Excel. Track drawdown limits, daily loss caps, consistency metrics, and evaluation progress.

Get Template — $5
Risk Management Checklist
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Risk Management Checklist - Download

Download a free risk management checklist template with pre-trade, in-trade, and post-trade gates. Includes position sizing formula and prop firm compliance.

Get Template — $5
Risk Management Spreadsheet.xlsx
B I U
$ %
fx
MetricValueTargetStatus
1 Max Daily Loss -$500 -$750 OK
2 Position Size 2.1% 2.0% WARN
3 Win Rate 62% 55% OK
Excel

Free Risk Management Spreadsheet

Download our free risk management spreadsheet for traders. Position sizing calculator, drawdown tracker, and risk metrics dashboard.

Get Template — $5
Risk Reward Calculator Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Risk Reward Calculator Spreadsheet

Download a free Excel risk reward calculator. Input entry, stop loss, and target to get R:R ratio, required win rate, and expected value instantly.

Get Template — $5
Scalping Journal.xlsx
B I U
$ %
fx
TimeSymbolSideSecTicksP&L
1 09:31 ES Long 12s +4 +$200
2 09:33 NQ Short 8s -2 -$100
3 09:35 ES Long 15s +6 +$300
Excel

Free Scalping Journal Excel

Download our free scalping journal spreadsheet. Ultra-fast logging for high-frequency traders with tick-level analysis and rapid review.

Get Template — $5
Spread Betting Journal.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Spread Betting Journal

UK-focused spread betting journal template for Excel. Track £/point stake, overnight funding charges, margin utilisation, and net tax-free P&L in GBP.

Get Template — $5
Swing Trading Journal.xlsx
B I U
$ %
fx
EntrySymbolSideDaysR:RP&L
1 02/28 NVDA Long 5 2.4:1 +$1,820
2 03/01 AAPL Long 3 1.8:1 -$340
3 03/03 AMD Short 4 3.1:1 +$2,150
Excel

Free Swing Trading Journal Excel - Download

Download our free swing trading journal spreadsheet. Track multi-day positions, holding periods, and setup development over time.

Get Template — $5
Trading Account Statement Analyzer.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Trading Account Statement Analyzer

Excel template that auto-calculates Sharpe ratio, profit factor, max drawdown, and holding time from broker CSV exports. No manual entry required.

Get Template — $5
Trading Checklist.pdf
Trading Checklist
Date: _______________
03/07 AAPL
03/06 TSLA
03/05 NVDA
03/04 AMD
Notes
PDF

Free Trading Checklist PDF

Download a free pre-trade and post-trade checklist PDF. Systematic prompts for market conditions, setup confirmation, risk parameters, and trade review.

Get Template — $5
Trading Edge Tracker Spreadsheet.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Trading Edge Tracker Spreadsheet

Free Excel spreadsheet to quantify your trading edge by setup type. Track win rate, expectancy, profit factor, and sample size per strategy.

Get Template — $5
Trading Goals Worksheet
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Trading Goals Worksheet - Download

Annual and quarterly goal-setting worksheet for traders. Set financial targets, process goals, skill milestones, and drawdown tripwires — all in one.

Get Template — $5
Trading Journal Airtable
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Trading Journal Airtable

Download a free Airtable trading journal template with linked strategy records, filtered views, and gallery view for chart screenshots.

Get Template — $5
Trading Journal Obsidian
Trading Journal Obsidian
Table Board Calendar
DateSymbolSideEntryExitP&L
03/07 AAPL Long $182.40 $184.10 +$340
03/06 TSLA Short $248.60 $250.20 -$160
03/05 NVDA Long $875.30 $882.50 +$720
Notion

Free Trading Journal Obsidian

Download a free Obsidian vault template for trading journals — includes Dataview queries, strategy pages, tag taxonomy, and a daily trade log structure.

Get Template — $5
Trading Journal Trello Board
Trading Journal Trello Board
Table Board Calendar
DateSymbolSideEntryExitP&L
03/07 AAPL Long $182.40 $184.10 +$340
03/06 TSLA Short $248.60 $250.20 -$160
03/05 NVDA Long $875.30 $882.50 +$720
Notion

Free Trading Journal Trello Board

A free Trello kanban board template for tracking trades visually. Move cards through Watchlist, Open, and Closed lists with custom fields for entry, stop.

Get Template — $5
Trading Mistake Tracker.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Trading Mistake Tracker - Download

Download a free Excel trading mistake tracker. Log revenge trades, oversizing, FOMO entries, and early exits with dollar costs and corrective actions.

Get Template — $5
Trading Performance Dashboard.xlsx
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Excel

Free Trading Performance Dashboard Excel

Download a free Excel trading dashboard with equity curve, drawdown chart, monthly P&L heatmap, and win rate by setup. No signup required.

Get Template — $5
Trading Plan Worksheet.pdf
Trading Plan Worksheet
Date: _______________
03/07 AAPL
03/06 TSLA
03/05 NVDA
03/04 AMD
Notes
PDF

Free Trading Plan Worksheet - Download

Download a free trading plan worksheet covering goals, risk rules, setup criteria, and daily routine. Fillable PDF and Google Docs format.

Get Template — $5
Trading Psychology & Emotion Tracker.pdf
Trading Psychology & Emotion Tracker
Date: _______________
03/07 AAPL
03/06 TSLA
03/05 NVDA
03/04 AMD
Notes
PDF

Free Trading Psychology & Emotion Tracker PDF

Track pre-trade mood, FOMO triggers, confidence scores, and post-trade reflections with this free printable PDF trading psychology tracker.

Get Template — $5
Trading Rules.pdf
Trading Rules
Date: _______________
03/07 AAPL
03/06 TSLA
03/05 NVDA
03/04 AMD
Notes
PDF

Free Trading Rules - Download

Download a free one-page trading rules template covering market filter, setup criteria, entry trigger, position sizing, exit rules, and post-trade logging.

Get Template — $5
Weekly Trade Review
B I U
$ %
fx
DateSymbolSideEntryExitP&L
1 03/07 AAPL Long $182.40 $184.10 +$340
2 03/06 TSLA Short $248.60 $250.20 -$160
3 03/05 NVDA Long $875.30 $882.50 +$720
Google Sheets

Free Weekly Trade Review - Download

Download a free weekly trade review template for active traders. Includes Execution Quality Score, setup audit, R-multiple tracker, and emotional log.

Get Template — $5

Benefits of a Trading Journal Template

Track All Trades in One Place

Consolidate your trading history across multiple brokers and asset classes into a single, organized spreadsheet.

Calculate Win Rate Automatically

Built-in formulas compute your winning percentage, average profit, and other key performance metrics instantly.

Identify Patterns in Your Trading

Spot recurring mistakes and successful setups by analyzing your historical data over time.

Improve Discipline and Consistency

The habit of logging every trade forces you to slow down and think critically before and after each position.

Free Alternative to Paid Journals

Get started without spending money on subscription software. Upgrade to JournalPlus when you need advanced features.

Works Offline, Own Your Data

Keep your sensitive trading data on your own computer. No cloud accounts required, no privacy concerns.

How to Use a Trading Template

1

Download Your Template

Choose the format that works for you—Excel for powerful formulas, Google Sheets for cloud access, or Notion for flexibility. Click download and open the file.

2

Record Each Trade After Execution

After every trade, log the ticker, entry price, exit price, position size, date, and your reasoning. The more detail you capture, the better your analysis will be.

3

Review Weekly for Patterns

Set aside 30 minutes each weekend to review your trades. Look for recurring mistakes, successful setups, and correlations between your emotions and outcomes.

4

Adjust Your Strategy Based on Data

Use your journal insights to refine entry and exit rules, adjust position sizing, and eliminate setups that consistently lose money.

Frequently Asked Questions

What is a trading journal template?

A trading journal template is a pre-formatted spreadsheet or document designed to help traders log their trades systematically. It typically includes fields for entry/exit prices, position size, profit and loss, date, ticker symbol, and notes about your trading rationale. The template automates calculations like win rate and average return.

How do I use a trading journal spreadsheet?

After each trade, open your spreadsheet and fill in the relevant columns: the asset you traded, when you entered and exited, your position size, and the outcome. Add notes about why you took the trade and how you felt. At the end of each week, review your entries to identify patterns and areas for improvement.

What should I track in my trading journal?

Essential fields include: date and time, ticker or asset name, trade direction (long/short), entry price, exit price, position size, profit or loss, and fees. Advanced journals also track: trade setup or strategy used, emotional state, market conditions, screenshots of charts, and lessons learned.

Is Excel or Google Sheets better for trading journals?

Both work well. Excel offers more powerful formulas and works offline, making it ideal for traders who want privacy and advanced analytics. Google Sheets provides cloud access from any device and easy sharing for accountability partners or mentors. Choose based on whether offline access or cloud sync matters more to you.

How often should I update my trading journal?

Log every trade immediately after execution while details are fresh. For analysis, review your journal weekly to spot patterns and monthly to evaluate overall performance. Consistent logging is more valuable than perfect logging—even basic entries help you learn from your trading history.

What's the difference between a template and trading journal software?

Templates are free, customizable spreadsheets you manage yourself. Trading journal software like JournalPlus offers automatic trade import from brokers, AI-powered insights, advanced analytics, and features no spreadsheet can replicate. Templates are great for beginners; software is better for active traders who want automation.

Can I customize these templates?

Yes. All templates are fully editable. Add or remove columns, change formulas, adjust formatting, and add new sheets for different strategies or accounts. The templates are designed as starting points—modify them to match your specific trading style and the metrics you care about most.

Want More Than a Template?

JournalPlus offers automatic trade import, AI insights, and advanced analytics—things no spreadsheet can do.

7-Day Money-Back
One-Time Payment
Lifetime Updates
4.9/5 (1,287 reviews)