Slippage Spreadsheet Template: Requested vs Filled Price by Hour
Posted: Fri Oct 09, 2026 12:35 pm
Measuring slippage does not need special software. A simple spreadsheet built from your trade history shows a lot.
Columns:
Have you built a slippage log, and which hour showed the worst results?
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.
- 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.
Have you built a slippage log, and which hour showed the worst results?