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.

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.

ColumnHow to calculateWhy it is there
TradesCount of closed positions in the monthContext for everything else
Net resultSum of profit, swap and commissionThe bottom line for the month
Average per tradeNet result divided by tradesLets quiet and busy months compare
Win rateWinners divided by tradesContext only; it ignores size
Largest lossMinimum net result in the monthShows whether one trade defined the month
CostsSum of swap and commissionShows 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.

MonthTradesNet resultAverageWin rateLargest lossCosts
Month 138+120.00+3.1655%-22.00-14.00
Month 221-65.00-3.1043%-48.00-9.00
Month 364+18.00+0.2850%-19.00-31.00
Month 430+75.00+2.5053%-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

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

Frequently asked questions

How do I see my monthly profit in MT5?
Choose a custom period in the History tab for the month, then add profit, swap and commission for the closed positions. A spreadsheet pivot on a year-and-month helper column does this for every month at once.
Which date decides the month of a trade?
Most people use the close time. The key is to apply one rule to every month. History times are on the broker's server clock.
Why does my total differ from my balance change?
The balance also moves with deposits, withdrawals and credits, which are not trades. Compare trade results only.
Should swap and commission be included?
Yes. The bottom line of a trade is profit plus swap plus commission.
Does the journal app build a months table?
Yes. The Progress page has a months table and growth curve, and the Excel report adds Summary, Daily and Trades tabs.

Related guides

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