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

How to fill it in from MetaTrader 5

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

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.

SymbolDirectionLotsRiskedProfit / lossR multiplePlan followedSetup
EURUSDBuy0.50$100+$200+2.0RYesPullback
GBPUSDSell0.30$100-$100-1.0RYesBreakout
XAUUSDBuy0.10$80-$120-1.5RNoMoved 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

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

Getting more from it

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

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