Advertisement IC Markets

A spreadsheet for tracking R by hour of day

Document your personal trading journey. Track daily equity curves, review winning and losing streaks, share trade screenshots, and get constructive feedback.
Post Reply
FXS London Scalper
Posts: 975
Joined: Sun Oct 18, 2026 12:25 pm

A spreadsheet for tracking R by hour of day

Post by FXS London Scalper »

Calculating R by hour of day is easy in a spreadsheet, and it's one of the more useful views of a trade log.

Columns in the trade log:
  • Entry time in London time, result in R, setup tag.
  • A helper column that extracts the hour: =HOUR(entry time).
Then a pivot table with hour as rows and sum, average and count of R as values.

What to look for in the output:
  • Whether one hour carries most of the profit. For London scalpers that's often the 08:00 hour.
  • Hours with an average near zero, which are paying only for costs.
  • Late-morning hours that are negative except on US data days, which is worth splitting out.
The count column matters more than people think. An hour with five trades and a high average means nothing. As a rough guide, don't draw conclusions from fewer than 30 trades in a cell.

You can also split by setup tag to see if some setups work at different hours.

Make sure all times are in the same time zone. Broker statements often use server time, usually set two or three hours ahead of London; convert first. Daylight saving changes are an easy source of off-by-one-hour errors.

Does anyone use a different breakdown, like minutes since the open?
FXS Official Team | London Session Desk
Recommended broker for automated trading & scalping IC Markets
Shadow Trader
Posts: 5594
Joined: Wed Sep 09, 2026 5:19 pm

Re: A spreadsheet for tracking R by hour of day

Post by Shadow Trader »

The point about the count column is the one I'd underline. A pivot table makes every hour look equally solid, and it's easy to read a big average from five trades as a discovery. Adding a column for the standard deviation of R, or even just the number of winners and losers, helps show which hours have enough data to say anything.

A couple of additions that can make this view more useful:

Split the hours by day type. As you mention, late-morning hours can look negative overall but fine on US data days. The same split works the other way too: the first London hour might be strong on most days and poor on days with a major release at 09:30 or 10:00 London time, because the open gets squeezed by traders waiting for the number.

Look at exits as well as entries. Grouping by entry hour shows when the good setups appear, but grouping by exit hour can show where trades tend to go wrong, for example trades opened at 11:50 that drift into the lunch lull and get stopped.

Be careful with daylight saving. If the log uses server time, and the broker shifts its clock on the US schedule, the hours will be off by one for a few weeks a year. Converting everything to London time first, as suggested, avoids that.

The best outcome from this kind of table is usually not a new rule but a clearer sense of which hours deserve full attention, and which ones are better spent away from the screen.
Post Reply