Forex tracking means recording every trade with enough context to find patterns in your own behaviour. Most traders log entry, exit and profit, then wonder why the journal never tells them anything useful.
Those three fields can't answer the only question worth asking, which is what you're doing repeatedly that costs you money. A profit column tells you the score. It doesn't tell you whether you took the trade because your plan said to, or because you were annoyed about the last one.
This article covers both halves: the metrics that actually change how you trade, and how to pull a full history out of MT5 and cTrader so you have something to work with.
Key Takeaways
- Entry, exit and P&L can't diagnose behaviour. Every one of those fields describes the market, not you.
- Expectancy beats win rate as a measure. A 40% win rate can outperform a 70% one.
- R-multiples keep results comparable as your account size changes.
- Session and setup splits are where most traders find their real leak.
- Annual spread, swap and commission often exceed the worst losing month.
- Track whether a trade followed the plan separately from whether it won.
Why Most Trading Logs Teach You Nothing
Open any trading journal a beginner has built and you'll usually find six columns: date, pair, direction, entry, exit, profit.
That's a record of what happened. It isn't a diagnostic tool, because every field describes the market rather than the trader.
The Problem With Market-Only Fields
You can stare at a thousand rows like that and never discover that 80% of your losses came between 3pm and 5pm on Fridays, or that one particular setup has been quietly bleeding money for eight months while three profitable ones mask it in the aggregate.
The fix isn't better software. It's more fields, chosen deliberately, recorded at the moment of entry rather than reconstructed later from memory. Reconstruction is where honesty goes to die.
Fast Fact
- A setup can win 58% of the time and still lose money. That trade survives indefinitely in a journal that tracks win rate and nothing else.
The Metrics That Change Behaviour
Not every number is worth calculating. These four are, and each answers a question the others can't.
Expectancy Versus Win Rate
Win rate is the most quoted and least useful figure in trading. It tells you how often you're right, which is unrelated to how much you make.
Expectancy is what actually matters:
Expectancy = (Win% × Average Win) − (Loss% × Average Loss)
Run two illustrative traders through it. Trader A wins 70% of the time but takes profit at half his risk, losing a full unit when wrong. Trader B wins only 40% but lets winners run to three times risk.
Trader B is wrong more often and produces twelve times the expectancy. Trader A feels better after every session and gets nowhere. If your journal tracks win rate but not expectancy, you're optimising for the wrong feeling.
R-Multiples
An R-multiple expresses each result as a multiple of what you risked. Risk $200, make $600, that's +3R. Risk $50, lose it, that's −1R.
This matters because raw dollar figures aren't comparable across a year in which your account changed size.
The June trade produced more dollars than January but represented a worse decision. Only the R column shows that.
Drawdown and Time to Recovery
Maximum drawdown is the largest peak-to-trough fall in your equity curve. Most traders track the depth and ignore the duration, which is the more useful half.
A 15% drawdown that recovers in three weeks is a different experience from one that takes nine months, and the second is what makes people abandon strategies that work.
Profit Factor
Gross profit divided by gross loss. Above 1.0 means you're net positive. It's a quick health check that catches the situation where one outsized win carries an otherwise unprofitable set of trades.
Worth running with and without your single largest winner. If profit factor drops below 1.0 when you exclude it, you don't have an edge yet. You had a good trade.
The Leaks You Only Find by Splitting Data
Aggregate numbers hide everything. The value of proper tracking comes from slicing it.
By Session and Hour
Forex runs across three main sessions, each with different volatility and liquidity.
Tag every trade with the session and the hour, then run the numbers separately. The pattern that shows up most often in retail data is a trader who's solidly profitable in one session and gives it all back in another. Usually because they're running a strategy built for volatility during a quiet stretch, or trading tired at the end of a long day. Neither shows up in a combined P&L.
By Setup Type
This one takes discipline, because setup tags have to be applied at entry. Reconstruct them later and you'll label winners generously and losers vaguely.
Once you have six months tagged, the aggregate almost always conceals dispersion. Here's what a typical breakdown looks like once you actually run it. Figures illustrative.
Setup D is the interesting one. It wins more than half the time and still loses money, which is exactly the trade that survives in a journal tracking win rate alone.
Cost Drag
Here's the calculation almost nobody runs. Add up what spread, commission and swap took out of your account across a full year.
Figures illustrative. For plenty of retail accounts that annual number exceeds the worst single losing month. Most traders obsess over the losing month and have never calculated the other one.
Checking the spread and commission structure on the instruments you actually trade is a five-minute exercise with a measurable result.
Adherence: The Field Almost Nobody Tracks
Add one column to your log. Did this trade follow your plan? Yes or no. Track it separately from whether the trade won.
Why a Winning Trade Can Be a Failure
A winning trade taken against the plan isn't a success. It's a rewarded mistake, and getting rewarded for a mistake is how the mistake becomes a habit.
If you moved your stop, doubled size out of frustration, or took a setup that wasn't in your plan and it happened to work, that trade belongs in the "did not follow plan" bucket no matter what the P&L says.
The Statistic That Follows
Over a few hundred trades, the adherence column produces the most uncomfortable and useful number in the journal: your expectancy on plan-following trades against your expectancy on everything else.
Revenge trading, overtrading and size creep all become visible in that comparison, and nowhere else. If the gap is large, you don't have a strategy problem. You have an execution problem, and those are fixed differently.
A Worked Example: Ten Trades, Two Logs
Figures below are illustrative.
Take ten trades that netted a small profit.
Same ten trades. The basic log says decent month, keep going. The full log says stop trading the New York afternoon, size down, and your edge lives in one specific setup you should be taking more of.
Note what the two oversized winners did. They inflated the month's P&L while confirming a habit that will eventually produce an oversized loser.
How to Export Your Trade History
None of this works without data, and the journal tools dominating search results can't tell you how to get it, because they aren't your broker.
Menu wording shifts between platform builds, so treat the following as the shape of the process rather than exact clicks.
MetaTrader 5
Open the Toolbox with Ctrl+T and select the History tab. Right-click inside the history area and set the period first, choosing a custom range if you want the full account rather than the default window.
Right-click again and open the Report submenu. MT5 offers HTML and Open XML (.xlsx). The XLSX opens straight into Excel, which is usually what you want for building a sheet. HTML is the more standard interchange format if you're feeding a third-party tool.
MT5 doesn't export CSV natively from the History tab. If you need it, open the XLSX and save-as, leaving column headers untouched.
Commission and swap are the two most traders discard, which is exactly how cost drag stays invisible.
cTrader
Go to the History tab in the Trade Watch panel. Right-click inside the trade list to choose which fields to include, since only checked columns get exported.
cTrader's default field set is richer than MT5's, carrying opening and closing direction, entry and closing price, filled quantity and volume in USD. In the web app, the Statement button generates a downloadable report for the selected range.
The API Route
For anyone running automated strategies, manual exports get old fast. Pulling history programmatically lets you append closed positions to a database or sheet on a schedule, with your own tagging logic applied at write time rather than after the fact.
That's a good reason to generate a demo API key and build the pipeline against virtual funds before pointing it at a live account.
Building the Sheet
Once the data is out, structure matters more than formatting.
The split matters. Everything the platform gives you can be automated. The four fields that make the journal useful are the ones you have to enter yourself, and three of them have to be entered before you know the outcome.
Review Cadence
Different questions belong on different clocks, and mixing them up is how traders end up rewriting a strategy because of one bad week.
Weekly, review process only. Did every trade follow the plan? Was sizing consistent? Are there entries you can't justify in writing after the fact? Ignoring P&L here is deliberate, because a profitable week can easily hide a week of bad decisions, and those compound quietly.
Monthly, look at the metrics. Expectancy, profit factor, drawdown depth and recovery time, plus the session and setup splits. One month rarely gives you enough data to conclude anything, but it's enough to notice a trend forming and flag it for the next review.
Quarterly, review the strategy itself. Is the edge still there? Have conditions shifted enough that a setup no longer works? Should a sizing rule change, or a setup be retired outright? This is the only cadence where changing the strategy makes sense. Anything shorter and you're reacting to noise.
Start With the Habit, Not the Tool
The hard part of forex tracking isn't building the sheet. It's filling in the setup tag and the adherence column honestly on a trade you already know went badly.
Building that habit on virtual funds costs nothing and removes the emotional pressure that makes people skip fields. A demo account gives you a full MT5 or cTrader environment to practise the export workflow and populate a journal properly before capital is at risk. Developers can generate a demo API key and build automated logging against the same environment.
Conclusion
The hard part isn't building the sheet. It's filling in the setup tag and the adherence column honestly on a trade you already know went badly. That's where most journals quietly die, three weeks in, when the fields that matter stop getting filled.
Start smaller than you think you need to. Planned risk in R, setup tag, session, and whether you followed the plan. Add the reasoning note once the habit holds, and give it a hundred trades before drawing conclusions, because below that the splits are noise.
FAQ
What should a forex trading journal include?
Timestamps, position size, risk in R, setup tag, session, plan adherence, spread and commission, and your reasoning at entry.
How do I export trade history from MT5?
Toolbox, History tab, right-click to set the period, right-click again and choose Report. HTML and XLSX both work.
What is expectancy in trading?
(Win% × Average Win) minus (Loss% × Average Loss). It tells you the average expected result per trade.
How often should I review my trades?
Weekly for process, monthly for metrics, quarterly for strategy.
Is a spreadsheet enough?
Usually yes. Software mainly saves time on import and charting, not on thinking.
