Exporting MT5 deals into a slippage workbook
Posted: Mon Oct 19, 2026 10:18 am
MT5 records every deal with requested price (for pending orders and stops) and executed price. Exporting this into a spreadsheet lets you measure slippage properly instead of relying on impressions.
Steps:
1. In MT5, open History, right-click, select the period, then "Report" or save as HTML/XLSX depending on version.
2. Import into a spreadsheet.
3. For each stop and limit order, calculate: slippage = executed price - requested price (adjusted for direction).
4. For market orders, compare execution price with the price on the chart at click time (harder, as the requested price isn't always stored).
Useful columns to add:
- Session (Asia, London, NY).
- Order type.
- Pair.
- Minutes since last major news.
Pivot tables then show average slippage by session, order type and pair. Over a few hundred trades, patterns become clear: perhaps stop orders on GBPJPY at 08:00 slip 0.8 pips on average while limits fill at the requested price.
Has anyone built a reusable template for this? It would be a useful community resource.
Steps:
1. In MT5, open History, right-click, select the period, then "Report" or save as HTML/XLSX depending on version.
2. Import into a spreadsheet.
3. For each stop and limit order, calculate: slippage = executed price - requested price (adjusted for direction).
4. For market orders, compare execution price with the price on the chart at click time (harder, as the requested price isn't always stored).
Useful columns to add:
- Session (Asia, London, NY).
- Order type.
- Pair.
- Minutes since last major news.
Pivot tables then show average slippage by session, order type and pair. Over a few hundred trades, patterns become clear: perhaps stop orders on GBPJPY at 08:00 slip 0.8 pips on average while limits fill at the requested price.
Has anyone built a reusable template for this? It would be a useful community resource.