Free Trading Journal Template
Copy our 2019 v2 Google Sheet in one click—the spreadsheet thousands of traders used before TradeJournal became an app. Export to Excel anytime.
No signup for the sheet · Stocks, options, forex & crypto · 15+ built-in metrics
Google Sheet templates
No account needed. In Google Sheets: File → Make a copy, or File → Download → Excel. Optional: auto-import with TradeJournal.
Why Traders Love Us
A simple sheet helps you see patterns, cut mistakes, and stick to your rules.
Know what pays
Win rate and P&L by setup—not gut feel.
Stop repeat mistakes
Catch tilt and revenge trades early.
Build discipline
Weekly reviews turn rules into habits.
Improve faster
Data beats memory for costly patterns.
What's inside the template
Four tabs in your copy—each one has a job. Formulas are already wired.
-
Trade log
Daily entryOne row per trade—entry, exit, size, fees, setup tags, and notes.
You get: auto P&L per row, running totals, no manual math.
-
Performance dashboard
At a glanceWin rate, profit factor, average win vs. loss, monthly rollups.
You get: 15+ metrics that update as you log trades.
-
Strategy breakdown
By setupP&L grouped by setup name—see what actually pays.
You get: best/worst sessions and pattern notes for review.
-
Setup guide
Start hereCopy instructions, weekly review checklist, common journaling mistakes.
You get: a repeatable review rhythm in about 15 minutes a week.
How to use it (4 steps)
About 15 minutes to copy, customize, and log your first trades.
Make a copy
Open the sheet above and choose File → Make a copy.
Customize
Rename setup types to match your playbook.
Log trades
One row per trade; formulas handle the math.
Review weekly
Use the dashboard tab to cut losing setups.
Spreadsheet vs. TradeJournal.co
The template is a great start. Here's when traders upgrade.
Template works well for
- Learning what to track
- $0 budget & full control
- Low trade frequency
You'll feel the limits when
- 15–20 min/day of manual entry adds up
- Formulas break after edits
- Mobile logging is painful
- No broker sync or AI pattern flags
| Feature | Free template | TradeJournal.co |
|---|---|---|
| Manual entry time | ~15 min/day | 0 min |
| Broker auto-import | 50+ brokers | |
| AI pattern detection | ||
| Chart screenshots | Unlimited | |
| Pro trader onboarding call | $300 value |
Ready to stop typing trades?
14-day free trial · Free $300 mentorship call with subscription
Where this template came from
Our founder started journaling on paper in 2011, then spent two years building a public Google Sheet to organize every trade and surface statistics—years before TradeJournal.co became an app.
That sheet helped students and mentors review real data together. When manual entry couldn't keep up, we built the platform: same discipline, with automatic imports and analytics.
Read our full storyFAQ
Keep the template—or automate everything
Use the free sheet as long as you like. When you're ready for broker sync, AI analytics, and mentorship, TradeJournal.co picks up where spreadsheets stop.
14-day free trial · Cancel anytime · $300 pro trader call included with subscription