Free trading journal spreadsheet for Excel (.xlsx) and Google Sheets. All formulas included — win rate, P&L, drawdown. Download free or use the full app instead.
No signup needed for template · Free app — no credit card
All formulas pre-built. Just add your trades and the spreadsheet calculates everything automatically.
Auto-calculated win rate updates every time you add a trade row. Broken down by instrument and direction.
Cumulative P&L column with running total. Track in dollars, pips or R-multiples — your choice.
Max drawdown and current drawdown from peak. Built-in formula tracks your equity curve automatically.
Tag each trade with your strategy. Filter by setup to compare win rates across different approaches.
Auto-generated equity curve chart. See your account growth visually as you add more trades.
Separate summary tab with key stats: total trades, win rate, average R:R, best day, worst day.
An Excel trading journal is a spreadsheet where you record every trade you take. It's one of the most common tools traders use to track performance — and for good reason. Excel is powerful, flexible and familiar. The challenge is setting it up correctly with the right formulas from the start.
Add a "Result" column (Win/Loss/BE) and use this formula in a summary cell:
Where column F is your Result column. Format the cell as percentage to get your win rate automatically.
Excel works great when you're starting out. But as your trade history grows, the limitations become painful: no mobile access, no screenshot storage, no automatic breakdown by session, and slow performance with large datasets. Profit Helper solves all of this — with a free plan that has no spreadsheet limits.
Start with the spreadsheet or go straight to the app that automates everything. Your choice.
Start Free App →Free plan forever · No credit card · All devices