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.

Use the profit figure as MT5 shows it, in your account currency, so commission and swap are already included.

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 writes each one into 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.

Related guides

Want your trades logged for you?

Free for 7 days, no card required. After that, a one-time $19.99 purchase. No subscription.

Start free 7-day trial