MT5 trade history by weekday: build the table and read it honestly

Which day of the week works for you? Group by close date, count the trades and keep the sample size in view.

Many traders suspect that some days of the week treat them better than others. Monday starts after a weekend gap, Wednesday may carry a triple swap, Friday brings position squaring before the close. Your MetaTrader 5 history can answer the question for your own account, but only if you group the trades sensibly. This page shows how to split closed trades by the weekday they finished, which clock to use, and how to avoid drawing a conclusion from three trades on a Tuesday.

Choose the date that defines the day

A position has an open time and a close time, and they can fall on different days. For a daily review the close time is the usual choice, because that is the day the result became real. It is also how a journal files a trade. The terminal shows times on the broker's server clock, not on your local clock, so a trade you closed late on Friday evening where you live might be dated Friday or Saturday depending on the offset. See server time vs local time before you trust a weekday count.

Build the table

Open the History tab, set the period with the controls described in history period and custom date range, and copy the rows into a spreadsheet, as explained in sorting, filtering and copying rows. Add a column that returns the weekday name of the close time, then build a summary with one row per weekday and these columns:

ColumnHow to calculate it
TradesCount of positions closed on that weekday
Net resultSum of profit plus commission plus swap
Average tradeNet result divided by trades
Win rateShare of trades with a net result above zero
Biggest lossThe most negative single net result that day

A worked example (hypothetical)

The following figures are invented for illustration. They come from an imaginary account over ten weeks.

WeekdayTradesNet resultAverage tradeWin rate
Monday14-22.00-1.5736%
Tuesday21+40.00+1.9057%
Wednesday19+8.00+0.4247%
Thursday17+15.00+0.8853%
Friday9-30.00-3.3333%

Read this carefully. Friday has the worst average, but nine trades is a small sample, and one large loss would explain the entire figure. Tuesday looks best with 21 trades, which is more convincing, yet ten weeks cover a single market mood. A pattern like this is a reason to write a note and keep watching, not a reason to ban a weekday on the spot.

Pitfalls

Turning the numbers into a habit

The point of a weekday table is not to find a magic day. It is to notice that your behaviour changes through the week. Perhaps you trade smaller on Mondays out of caution and larger on Fridays to make up ground. Perhaps most of your rule breaks land on one day. Write the finding as a question in your journal, for instance whether Friday trades follow the plan as often as Tuesday trades, and check it again after the next month. If you track plan adherence, the comparison across weekdays is more telling than the profit comparison; see positions vs deals counts to be sure you are counting the same unit each time.

How the journal app helps

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 dashboard has a P&L calendar that colours each day by its result, and the Export Report to Excel button writes a Summary tab with net P&L by close hour, weekday and symbol, built with live formulas. Entries are dated by the last exit on the broker's server clock, matching the method above. 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

Which date should I use, open or close?
Most reviews use the close date because that is when the result is realised. Pick one and use it consistently.
Why does my Friday evening trade show a Saturday date?
The terminal uses the broker's server clock, which can be ahead of your local time. Check the offset in your terminal.
How many weeks of data do I need?
There is no fixed rule. More trades per weekday make the average more reliable; ten weeks of a few trades a day is thin.
Does the app show results by weekday?
The Excel report's Summary tab includes net P&L by weekday, and the dashboard has a P&L calendar.
Should I stop trading my worst weekday?
That is your decision. The data only shows what happened; it does not say what will happen.

Related guides

See your results by weekday in a calendar: 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