MT5 monthly results: build a month-by-month table from your trade history
Which date counts, how to include costs and how to read twelve monthly totals without fooling yourself.
Most traders think in months: a monthly target, a monthly loss limit, a monthly review. MetaTrader 5 does not hand you a tidy month-by-month table, but the closed-trade history has everything needed to build one. The catch is in the details. Which clock decides the month? Does a trade that opened on the 31st and closed on the 2nd belong to the old month or the new one? Are swap and commission inside the figure? This page walks through building a monthly results table from your own history, and how to read it without turning twelve numbers into false certainty.
Decide the rules before you add anything up
A monthly total is only meaningful if the same rules are applied to every month. Write three of them down first.
- Which date counts. The common choice is the close time, so a trade belongs to the month in which it ended. Using the open time is also valid, but it means a month can change after the fact when a long trade finally closes. Pick one and keep it.
- Which clock. History times follow your broker's server clock, not your local time. A trade closed late on the last evening of the month in your country might already be the next month on the server. See server time explained before you worry that a trade is in the wrong month.
- Which amount. Use profit plus swap plus commission for each position. A month that looks positive before costs can be flat after them; the breakdown is in trading costs in your history.
Get the right rows
Work from positions, where each row is one trade from open to close, rather than deals, where one trade produces at least two rows. Counting deals inflates the number of trades and mixes in entry rows that carry no profit; the difference is explained in positions versus deals. To pull a whole calendar month, use the custom period in the History tab described in history period and custom date range, then copy the rows as shown in sorting, filtering and copying history rows. Menu wording can vary between builds, so check your own terminal.
Build the table
In a spreadsheet, add a helper column that turns each close time into a year-and-month label, then build a pivot table with that label as rows. Put the following measures in the values area.
| Column | How to calculate | Why it is there |
|---|---|---|
| Trades | Count of closed positions in the month | Context for everything else |
| Net result | Sum of profit, swap and commission | The bottom line for the month |
| Average per trade | Net result divided by trades | Lets quiet and busy months compare |
| Win rate | Winners divided by trades | Context only; it ignores size |
| Largest loss | Minimum net result in the month | Shows whether one trade defined the month |
| Costs | Sum of swap and commission | Shows what trading itself cost |
A worked example (hypothetical)
The figures below are invented to show how to read the table. They are not from any real account and are not a benchmark.
| Month | Trades | Net result | Average | Win rate | Largest loss | Costs |
|---|---|---|---|---|---|---|
| Month 1 | 38 | +120.00 | +3.16 | 55% | -22.00 | -14.00 |
| Month 2 | 21 | -65.00 | -3.10 | 43% | -48.00 | -9.00 |
| Month 3 | 64 | +18.00 | +0.28 | 50% | -19.00 | -31.00 |
| Month 4 | 30 | +75.00 | +2.50 | 53% | -20.00 | -12.00 |
Read across, not just down the Net result column. Month 1 and Month 4 look similar, but Month 3 is the interesting one: sixty-four trades, a result close to zero and the highest costs of the four. Nothing about that month says the setups failed; it says that activity rose, the average per trade fell to almost nothing and costs ate a large share of what was gained. Month 2 has the fewest trades and the largest single loss, which points to a different question, namely whether one oversized or unplanned trade did the damage. Compare with profit concentration, which asks the same question of the best and worst trades, and with position size changes.
Month boundaries and the trade that straddles them
A position opened on the last day of one month and closed in the next is the classic source of confusion. If you assign by close time, its entire result, including swap accumulated during the earlier month, lands in the new month. That is fine as long as you apply it consistently, but be aware that a month can look better or worse because of a trade whose real work was done earlier. If it matters to you, keep a short note beside the month listing any trades that crossed the boundary. Overnight costs on such trades are covered in overnight positions and rollover.
What a monthly table can and cannot tell you
- It can show whether results are stable or lurch from month to month, which is more useful than any single total.
- It can show whether your month-end result is driven by many ordinary trades or by one or two large ones.
- It cannot predict next month. A few observations are a thin basis for any rule, and a good month is not proof of a good method.
- It cannot tell you why a month went the way it did. That is what notes, tags and screenshots are for.
Pair the numbers with a short review
After the table, spend ten minutes writing three sentences per month: what was different about how you traded, what you would repeat, and what you would change. The numbers tell you where to look; your own words record what was going on at the time. A structured version of this habit is in the monthly trading performance report, and if you work to a monthly target or loss limit, setting monthly trading goals explains how to define them so they do not push you into forcing trades.
AI Trading Journal is a Windows app for MetaTrader 5 only. It reads closed trades from the terminal on your PC, adds new ones every 5 minutes, and keeps the journal in a file in your Documents folder. The Progress page shows a months table and a growth curve, you can set a monthly profit target and loss limit that are stored in the journal, and Export Report to Excel writes Summary, Daily and Trades tabs with live formulas, so the monthly table does not have to be rebuilt by hand. The app is read-only: it never places, modifies or closes a trade, and it gives no trading advice. The 7-day trial needs no card, and the full version is $19.99 once, with no subscription.
Limits
- Month assignment follows the broker's server clock; your own calendar may differ by a few hours.
- Open positions are not in the closed history, so a month that ends with floating losses looks better than it will once they close.
- Deposits, withdrawals and credits are balance operations, not trades, and should be excluded from a trading result.
- Nothing here is trading advice, and past months do not predict future ones.
Frequently asked questions
How do I see my monthly profit in MT5?
Which date decides the month of a trade?
Why does my total differ from my balance change?
Should swap and commission be included?
Does the journal app build a months table?
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
Track your months: free for 7 days
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