Download the free trading journal template
Download the trading journal template (CSV). It opens in Excel, Google Sheets or Numbers, and includes one example row you can delete.
Which columns should a trading journal have?
| Column | Why it matters |
|---|---|
| Date in / date out | Shows how long you actually hold |
| Stock | Name or code |
| Timeframe | Short, mid or long-term: never mix their results |
| Reason to buy | The setup or fundamentals, written before buying |
| Entry price | What you paid per share |
| Stop-loss | Where the idea is wrong |
| Target | Where you plan to take profit |
| Lots | Position size (1 lot = 100 shares) |
| Fees | Brokerage, clearing fee and stamp duty, both sides |
| Exit price | What you sold at |
| Result (RM) | After all fees |
| Followed plan? | Yes or no: the honest column |
| Lesson | One line you can use next time |
How do you review your journal?
Once a month, work out four numbers from the closed trades:
- Win rate = winning trades ÷ all closed trades
- Average win and average loss, in RM
- Profit factor = total RM won ÷ total RM lost (after fees). Above 1 means winners paid for losers.
- Fees paid: if it’s a big share of your results, you may be trading too often.
Then read the Followed plan? column. Trades where you broke your own rules usually explain most of the damage. The How my system works page explains these numbers in more detail.
What’s the fastest way to start?
- Practise in the paper trading simulator, which tracks win rate, profit factor and fees for you.
- Export your paper trades with Download CSV and paste them into the template.
- Use the position size calculator and fees calculator to fill in lots and fees before each real trade.
The XpertStocks stock tracking dashboard (coming soon) will keep this journal for you automatically. Join the waitlist for early access.
This guide is education only. It is not a recommendation to buy or sell any security.