Advertisement IC Markets

Slippage tracking in a plain spreadsheet

Share, develop, and backtest custom MQL4/MQL5 Expert Advisors, Python data-scraping scripts, trading bots, and automated market alert systems.
Post Reply
Fairman
Posts: 6955
Joined: Tue Jul 21, 2026 7:11 am
Location: Abuja

Slippage tracking in a plain spreadsheet

Post by Fairman »

Slippage tracking in a plain spreadsheet

The most useful tool a scalper can build costs nothing. A spreadsheet with a few columns: time, pair, side, requested price, filled price, order type, spread at entry, and the market condition.

After a few hundred trades, patterns appear that no one notices in the moment. Slippage is worse at certain hours. Some pairs fill cleanly and others do not. Limit orders and market orders behave differently. News periods stand out sharply.

The data also gives something concrete to bring to a broker. A statement like "average negative slippage of 0.4 pips on EURUSD market orders between 13:00 and 14:00" is harder to dismiss than a general complaint.

Beyond slippage, tracking spread at entry shows how much of the trading edge is eaten by costs. Many traders are surprised by how large it is.

It takes about thirty seconds per trade to fill in, or seconds with an automated export from the platform history.

A good addition is a column for how the trade felt, a simple tag such as calm, rushed, or chased. After a month, filtering the slippage by that column often shows that the rushed trades are the expensive ones.

What patterns have turned up in slippage data, and did any change behaviour?
It’s Fairman :geek:
Recommended broker for automated trading & scalping IC Markets
FXS London Scalper
Posts: 976
Joined: Sun Oct 18, 2026 12:25 pm

Re: Slippage tracking in a plain spreadsheet

Post by FXS London Scalper »

Fairman wrote: A spreadsheet with a few columns: time, pair, side, requested price, filled price, order type, spread at entry, and the market condition.
Requested price, filled price, spread at entry and market condition in one sheet is enough. After a month, a pivot table of slippage by hour and by order type usually shows where the costs concentrate, often around the London open and US data.
FXS Official Team | London Session Desk
Fairman
Posts: 6955
Joined: Tue Jul 21, 2026 7:11 am
Location: Abuja

Re: Slippage tracking in a plain spreadsheet

Post by Fairman »

A pivot by hour and order type is a good first cut, but I would treat the London open and US-data windows as hypotheses until the sample counts are large enough. Those periods can also coincide with wider spreads and changing volatility, so tagging the spread and whether a scheduled release is near helps separate timing from market conditions.

It may also help to split slippage into favorable and adverse rather than averaging them together. A near-zero average can hide frequent poor fills offset by a few positive ones. For each bucket, keep the trade count and compare the median with a higher percentile, such as the 90th, alongside the mean. Then check whether the pattern persists by pair and direction. Market orders and limits should be evaluated differently too: a limit that avoids negative slippage but misses many valid entries has a different cost than a market order that fills reliably at a worse price. That turns the spreadsheet from a list of complaints into a decision aid, while keeping the conclusions proportional to the data.
It’s Fairman :geek:
Amanhasnoname
Posts: 2060
Joined: Fri Oct 30, 2026 9:45 am

Re: Slippage tracking in a plain spreadsheet

Post by Amanhasnoname »

I built almost exactly that sheet and the first pattern that jumped out was hour-of-day on market orders. On my broker, EURUSD adverse slip averaged close to half a pip between 12:30 and 13:30 London on data days, versus about one tenth in the quiet mid-morning. GBPJPY was worse in the first twenty minutes of the Tokyo open, where I had been forcing trades out of boredom.

Tagging each entry calm, rushed, or chased made the second pattern obvious. The rushed and chased rows carried nearly twice the average slip of the calm ones, even in the same hour. That changed behaviour more than any broker complaint. I stopped trading the Tokyo open entirely and I force a one-line checklist before any order during the US data window.

I did take a month of numbers to support once, and they engaged more seriously than when I had only a vague complaint. The practical win was still my own filter, not a concession from them.
Post Reply