Free MT5 trading journal template (Excel and Google Sheets)
A free spreadsheet to log your MetaTrader 5 trades and see your win rate, profit factor, expectancy and drawdown. No sign-up, works offline.
Download the free template (.xlsx)
No email address or sign-up needed. It is a plain spreadsheet that works offline, so your trades stay in a file you own.
What is inside
- Trades: one row per closed trade with date, symbol, direction, lots, entry, exit, stop loss, take profit, profit or loss, the amount you risked, whether you followed your plan, your setup and your notes. R multiple, cumulative P&L and drawdown are calculated for you.
- Dashboard: total trades, win rate, net profit, profit factor, average win and loss, payoff ratio, expectancy, largest win and loss, average R, maximum drawdown, and a cumulative P&L chart. It updates as you add trades.
- Weekly review: ten questions to answer once a week. See the weekly trading review checklist for how to use them.
- Start here: short instructions. The first five rows on the Trades sheet are clearly marked examples to delete.
How to fill it in from MetaTrader 5
- In MT5 open the Toolbox (Ctrl+T) and click the History tab.
- Right-click inside it, choose the period you want, and pick Positions to see one row per closed trade.
- Copy each trade into a new row on the Trades sheet. The only column the Dashboard strictly needs is Profit / loss, so start there.
- Enter the amount you risked in the optional column to get R multiples, and mark each trade Yes or No for following your plan.
Enter the real (net) profit of each trade in your account currency: the Profit figure with commission and swap already deducted, so the number you record is what you actually kept.
Using it in Google Sheets
Upload the file to Google Drive and open it with Google Sheets, or use File > Import. The formulas and drop-downs carry over. If the chart does not, select the Cumulative P&L column and insert a line chart.
What the numbers mean
Win rate, profit factor and expectancy tell you different things, and each can mislead on its own. The guide Win rate, profit factor and expectancy explained shows how to read them together with a worked example.
Limits of a spreadsheet journal
- You type every trade. That is the part people stop doing. A journal with gaps misleads you.
- It holds 500 trades as supplied (you can extend it).
- No screenshots or rich notes next to each trade, which a Notion journal gives you.
If you would rather not type trades in
AI Trading Journal reads your closed trades from your own MetaTrader 5 and saves each one in your own journal on your PC (with an optional copy in your own Notion workspace) automatically, so the Trades sheet fills itself in. It is a Windows app with a 7-day free trial and a one-time $19.99 price. See what an MT5 trading journal should record or the four ways to track trades automatically.
This template is for record keeping and review. It is not trading or investment advice.
A filled-in example (hypothetical trades)
Here is how three rows look once the Trades sheet is filled in. The numbers are invented to show the calculations. R is the profit divided by the amount you risked.
| Symbol | Direction | Lots | Risked | Profit / loss | R multiple | Plan followed | Setup |
|---|---|---|---|---|---|---|---|
| EURUSD | Buy | 0.50 | $100 | +$200 | +2.0R | Yes | Pullback |
| GBPUSD | Sell | 0.30 | $100 | -$100 | -1.0R | Yes | Breakout |
| XAUUSD | Buy | 0.10 | $80 | -$120 | -1.5R | No | Moved the stop |
The third row shows why the plan-followed column matters. A loss of 1.5R on a trade with a risk of 1R means something went wrong that is not about the market. Over a month, adding up the cost of the No rows tells you what rule-breaking is costing you.
How the main numbers are worked out
- Win rate: winning trades divided by all trades.
- Profit factor: total profit from winners divided by total loss from losers.
- Expectancy: average profit per trade, or in R if you fill in the risked amount.
- Maximum drawdown: the largest fall in cumulative profit from a previous peak.
If you want to see the formulas with worked numbers, read win rate, profit factor and expectancy explained, and test your own figures in the expectancy calculator.
Fixing common problems
- The dashboard shows zeros or errors. Check that the Profit / loss cells hold numbers and not text. Numbers pasted from an MT5 report with a space as a thousands separator are read as text; remove the space.
- Example rows are still in the totals. The first five rows on the Trades sheet are examples. Delete them before you start.
- Plan followed shows nothing. The drop-down expects Yes or No. Leave it blank only for trades you cannot judge.
- You have more than 500 trades. Copy the formulas in the last row down as far as you need, and extend the ranges that the dashboard uses.
- The file is slow or corrupt. Keep a dated copy each month so you can fall back to the last good version.
Getting more from it
- Fill in the weekly review sheet every week, even when it feels repetitive. Patterns appear in the repetition.
- Use one line of notes per trade, written at the time. A note written days later is guesswork.
- Split the file by account if you trade more than one, so the statistics do not mix.
- After 50 trades, look at your results by setup and by day of the week before you change anything.
If you prefer Notion, the free Notion trading journal template gives you a CSV with similar columns to import, and exporting MT5 history shows how to get the trades out of MetaTrader 5 before you paste them in.
A last tip: save the file with a dated name at the end of each month, and keep the previous month's copy. If a formula breaks or a paste goes wrong, you can always return to a version that was correct.
Column ideas for your template: the magic number or an EA/manual tag and the planned lot size from this lot size guide.
Related guides
- A local trading journal for MT5
- P&L calendar for MT5
- Trade notes, ratings and screenshots
- Trading progress and goals
- Back up your journal and move it to a new PC
- An offline trading journal for Windows
- How to set monthly trading goals
- Import your whole MT5 history
- How to tag trades
- Trade screenshots for your journal
- All trading journal comparisons
Want your trades logged for you?
Free for 7 days, no card required. After that, a one-time $19.99 purchase. No subscription. Also on the Microsoft Store.
One-time $19.99, no monthly fee · your MT5 login never leaves your PC · trades go into your own journal on your PC, not through our servers.
Start free 7-day trial