Advertisement IC Markets

Slippage Spreadsheet Template: Requested vs Filled Price by Hour

Compare ECN/Raw spread brokers, analyze execution speeds, report slippage, and evaluate commission structures for high-frequency traders.
Post Reply
FXS Prop Desk
Posts: 1689
Joined: Wed Oct 07, 2026 9:52 am

Slippage Spreadsheet Template: Requested vs Filled Price by Hour

Post by FXS Prop Desk »

Measuring slippage does not need special software. A simple spreadsheet built from your trade history shows a lot.

Columns:
  • Time (server and local).
  • Symbol and direction.
  • Order type (market, stop, limit).
  • Requested price (from your order or the stop level).
  • Filled price.
  • Slippage in pips: positive if better than requested, negative if worse.
Analysis:
  • Average slippage by hour of the day.
  • Average slippage by order type: stops typically slip more than market orders.
  • Distribution: share of positive, zero and negative fills.
  • Slippage on news minutes vs normal minutes.
MT5 shows the requested price in the order history for some order types; for others, recording it at entry is necessary.

Have you built a slippage log, and which hour showed the worst results?
FXS Official Team | The Idea Lab & Strategy
Recommended broker for automated trading & scalping IC Markets
Shadow Trader
Posts: 5594
Joined: Wed Sep 09, 2026 5:19 pm

Re: Slippage Spreadsheet Template: Requested vs Filled Price by Hour

Post by Shadow Trader »

I built the slippage sheet from MT5 history with requested price, fill, hour, and order type. Stops at the London open averaged about 0.4 pips worse than market orders on EURUSD across a 300 trade block.

The hourly view changed my schedule more than any blog post. 08:00 to 08:20 and the first minute after US data were the clear losers; mid morning fills were close to zero slip.
img_13732_r1.png
img_13732_r1.png (28.26 KiB) Viewed 102 times
The illustration shows average requested versus filled slip by London hour for my last sample. Bars above the zero line are adverse fill; the open spike is why I cut size in the first twenty minutes.

Limit orders trimmed some entry cost yet left stop fills untouched. I still widen the stop budget on news minutes rather than pretending the sheet will stay flat.

Which hour was worst in your log? Mine is still the London open by a wide margin, so I treat that window as a separate cost regime.
Shadow Trader
Posts: 5594
Joined: Wed Sep 09, 2026 5:19 pm

Re: Slippage Spreadsheet Template: Requested vs Filled Price by Hour

Post by Shadow Trader »

Averages by hour can mislead badly when the buckets are small. In my 300 trade block the 13:00 London bucket held only 11 trades, and a single 2.8 pip fill on a data release dragged its average to the worst of the day.

So the sheet now shows three numbers per hour: count, median slip and the 90th percentile. The median for that 13:00 bucket was flat zero, and the 90th percentile is the figure I actually budget my stops with.

The other column I added is spread at send. A market order can show zero slippage and still cost more than a slipped one if the spread at that moment was 1.6 pips instead of 0.3.

For market orders MT5 often has no requested price to compare against, so a small script records the bid and ask the instant I click. Before that I was measuring fills against the M1 close, which is not the price I actually saw.

How many trades do you require in an hour bucket before you trust it? I use 30 and grey out anything below that.
Shadow Trader
Posts: 5594
Joined: Wed Sep 09, 2026 5:19 pm

Re: Slippage Spreadsheet Template: Requested vs Filled Price by Hour

Post by Shadow Trader »

Most discussions of slippage focus on the painful side, where a fill lands worse than the requested price. Price improvement, where the fill lands better, is the other half of the picture and deserves equal attention when evaluating a broker.

In a symmetric execution model, positive and negative slippage should occur at roughly similar frequency and size. In an asymmetric model, negative slippage is passed on to the client while positive slippage is withheld or capped. Over hundreds of scalp trades, even a fraction of a pip of asymmetry becomes a serious drag on expectancy.

A simple audit is possible with a spreadsheet. Record requested price, filled price, and direction for every trade over a month. Separate the results into favorable and unfavorable slippage, then compare averages and counts. A large imbalance in either direction points to the execution model, not luck. This one comparison often explains why live results lag behind expectations built on clean historical data.
Post Reply