Best time to trade forex: find your own hours from your MT5 trades

Generic guides tell you when the market is busy. Your own trades tell you when you trade well. A step-by-step way to group your results by hour without fooling yourself.

The best time to trade is the best time for you

Search for the best time to trade forex and almost every result tells you the same thing: the London and New York overlap is the busiest window, because two big financial centres are open at once. That is useful for knowing when the market is liquid. It does not tell you when you trade well. Your results depend on your strategy, your instruments, your attention and your life, and the only way to find your own best hours is to look at your own trades.

This guide shows how to do that with the data you already have in MetaTrader 5, step by step, with a spreadsheet or with the Excel report from AI Trading Journal, and how to avoid the main traps: broker time, small samples and acting on a pattern that is only noise.

Step 1: get every trade with a time

You need one row per closed trade with a time and a net result. MetaTrader 5 gives you both in the History tab: choose the period, save a report and open it in a spreadsheet. The MT5 history export guide shows how.

If you use AI Trading Journal, Export Report builds the workbook for you. Its Trades sheet has one row per closed position with the open time, the close time and the net result, and its Summary sheet already includes charts of net P&L by close hour and net P&L by weekday built from live formulas. Those two charts answer the first version of the question in one click. The rest of this guide goes a level deeper.

AI Trading Journal Excel report Summary sheet on sample data with charts including net P&L by close hour
The Excel report on sample data: the Summary sheet includes charts of net P&L by close hour and by weekday.

Step 2: settle the clock

MetaTrader 5 stamps every trade with the broker’s server clock, which is often two or three hours ahead of UTC and may change when daylight saving time starts or ends in the country your broker follows. Decide on one convention and keep it:

ConventionGood forWatch out for
Broker server time as shownMatching the History tab and the calendar exactly. It is what the journal and the Excel report useSessions appear to move by an hour when the broker changes its clock
Convert to your own timeThinking in your own dayYou must convert every row the same way, and handle daylight saving yourself
Convert to UTCComparing with session open times worldwideA bit more work. Subtract your broker’s offset

The simplest and safest choice is to analyse in server time and translate the answer at the end: “my best hours are 10:00 to 12:00 broker time, which is early London for me.”

Step 3: bucket by hour

Add a helper column with the hour of the open time, =HOUR(F2) if the open time is in column F, or of the close time. Then count the trades and add up the results per hour. In a spreadsheet the formulas are:

Per hourFormula (hour in H1)
Number of trades=COUNTIF(hourRange,H1)
Net result=SUMIF(hourRange,H1,resultRange)
Win rate=COUNTIFS(hourRange,H1,resultRange,">0")/COUNTIF(hourRange,H1)
Average result per trade=AVERAGEIF(hourRange,H1,resultRange)

A pivot table gives you the same in a few clicks: rows are the hour, values are the count and the sum of the result. Pick the open hour if you want to know when your entries work, and the close hour if you want to know when your results arrive. The two are not the same for trades that run for hours. The chart in the Excel report is based on the close hour, which is the hour the result was booked.

Step 4: respect the sample size

This is where most people go wrong. A bucket with five trades in it tells you nothing: one big loss or one big win decides the whole hour. Treat any bucket with fewer than a few dozen trades as a hint to collect more data, not as a result. If your history is short, widen the buckets, for example morning, midday and afternoon, or compare only two groups, such as “inside my planned session” and “outside it”.

What a result might look like (hypothetical)

Window (broker time)TradesNet resultAverage per trade
07:00 to 09:0042+$118+$2.81
09:00 to 12:0096+$365+$3.80
12:00 to 15:0058-$74-$1.28
15:00 to 18:0071-$210-$2.96
After 18:0019-$41-$2.16

These numbers are invented. If real figures looked like this, the question would not be “should I stop trading after noon” but “why do I trade differently after noon?” Tiredness, a different market, a different strategy and a revenge trade after a morning loss are all possible. Open the trades from the weak window in the Journal page and read your notes before you decide.

Step 5: cross-check before you act

The tagging guide shows how to mark these cuts as you trade so that the comparison is one filter later.

Step 6: test the change forward

Suppose the evidence is clear enough to act. Do not rewrite your schedule on the strength of old data alone. Make one change, for example a smaller size or no new trades in the weak window, and keep journaling for a month or a fixed number of trades. If the weak window stays weak on new data, you have a result. If it does not, it was noise, which is also useful to know.

Honest limits

For a routine that fits the hours you choose, see the forex trading daily routine, and for the weekly view of the same habit, the weekly review checklist. The Excel report guide lists every chart the report builds.

For a gold-specific version with session tags and an example table, see gold trading sessions in your journal.

To see when the sessions open where you live, use the forex session times converter, or read the pages for the UAE, Pakistan, India and South Africa. For gold, see gold trading hours.

Scheduled releases are part of 'when'. The Market Watch pages list central bank decisions and major US data each week, so you can mark those days when you compare your results by hour.

Frequently asked questions

What is the best time of day to trade forex?
Generally the busiest window is the London and New York overlap, but the best time for you depends on your strategy and results. The reliable way to find it is to group your own trades by hour.
How do I analyse my trades by hour?
Put each closed trade with its open or close time and net result in a spreadsheet, add an hour column, and count the trades and add up the results per hour with COUNTIF and SUMIF or a pivot table.
Which time zone does MetaTrader 5 use?
The broker’s server clock, often a few hours ahead of UTC, which may change with daylight saving time. Choose one convention and keep it for every row.
How many trades do I need before an hour means anything?
More than a few dozen per bucket. With fewer, widen the buckets or collect more history, because one trade can decide a small bucket.
Does AI Trading Journal show results by hour?
The Excel report has a chart of net P&L by close hour and by weekday on its Summary sheet. The Trades sheet has the open and close times if you want to analyse by open hour.

Related guides

Get your hour and weekday charts automatically: 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