Free Trading Journal Template
Log your trades right here and get win rate, profit factor and R automatically. Download it any time for Excel or Google Sheets.
How to use this trading journal template
Add a row for every trade with your entry, stop, exit, size and result. The template calculates R for each trade and updates your win rate, profit factor, average R and plan compliance as you type. Your entries are saved in this browser.
R = (Exit − Entry) ÷ (Entry − Stop)
Measuring every trade in R lets you compare results fairly as your position size changes. A +2R trade made twice your initial risk; a −1R trade lost exactly what you planned to risk.
Download for Excel or Google Sheets
Click Download CSV to save your journal. The file opens directly in Excel or Numbers, and in Google Sheets through File → Import, so you can keep adding trades or build your own charts.
What every journal entry should include
At minimum: date, symbol, direction, entry, stop, exit, size and result, plus the setup you traded and whether you followed your plan. That last column is where most of the learning happens, because it separates good losses from bad ones.
When to move beyond a template
A template works well for a few trades a week. As your trade count grows, manual entry becomes the reason traders stop journaling. Clarity Tracking imports trades automatically from MT4, MT5, TradeLocker, cTrader, Tradovate and NinjaTrader and calculates every metric for you.
