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:
| Column | How to calculate it |
|---|---|
| Trades | Count of positions closed on that weekday |
| Net result | Sum of profit plus commission plus swap |
| Average trade | Net result divided by trades |
| Win rate | Share of trades with a net result above zero |
| Biggest loss | The 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.
| Weekday | Trades | Net result | Average trade | Win rate |
|---|---|---|---|---|
| Monday | 14 | -22.00 | -1.57 | 36% |
| Tuesday | 21 | +40.00 | +1.90 | 57% |
| Wednesday | 19 | +8.00 | +0.42 | 47% |
| Thursday | 17 | +15.00 | +0.88 | 53% |
| Friday | 9 | -30.00 | -3.33 | 33% |
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
- Different trade counts: compare averages, not totals, and always show the count beside them.
- Swap on the heavy weekday can make positions closed the next day look worse; see triple swap on Wednesday.
- Public holidays shorten the week and shift activity; see broker holiday hours.
- Brokers that offer Sunday sessions on some symbols may show a Sunday row; decide whether to merge it with Monday and say so in your notes.
- A change of strategy or lot size midway makes the weekday figures incomparable; split the table at the change.
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
- Weekday analysis describes the past and does not predict anything.
- Small samples dominate; do not act on fewer than a few dozen trades per bucket, and even then treat it as a hint.
- Server-clock dates may differ from your local calendar.
- Example numbers are hypothetical; this is not trading advice.
Frequently asked questions
Which date should I use, open or close?
Why does my Friday evening trade show a Saturday date?
How many weeks of data do I need?
Does the app show results by weekday?
Should I stop trading my worst weekday?
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
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