ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Slippage Audit Ledger for Paper Trading — v0.1 DRAFT
2
Education only; not investment advice. Example rows are HYPOTHETICAL and use made-up symbols. Replace them with your own records.
3
4
Sheets
5
Ledger: one row per order. Fill the yellow cells; grey/blue cells calculate. Rows 6–55.
6
Summary: totals, averages and a split by order type. Reads the Ledger.
7
Benchmarks: one fill measured against the best quote on your side, the midpoint and a trigger price.
8
Backtest Sensitivity: results under no slippage and three hypothetical allowances you choose.
9
Tests: the cases this draft was checked against (formulas calculated by a spreadsheet engine and compared with an independent model).
10
11
Convention
12
Buy: adverse slippage per unit = fill price − reference price. Sell: adverse slippage per unit = reference price − fill price.
13
A POSITIVE number is a COST. A NEGATIVE number is a FAVOURABLE fill. Many people say 'positive slippage' for a better fill; this workbook does not.
14
Cash impact = slippage per unit × quantity × multiplier (leave multiplier blank for shares; for derivatives use the contract multiplier you have confirmed).
15
Basis points = slippage per unit ÷ reference price × 10,000.
16
Fees are recorded in their own column and are NOT part of slippage. Spread, slippage and fees are different costs.
17
A blank fill price means the order did not fill. It is counted as a non-fill, not as zero slippage.
18
19
Limits
20
Pick ONE reference benchmark per row and state it in the 'Reference source' column. Mixing benchmarks in one average gives a number that answers no single question.
21
Paper or backtest fills are simulated. A low number here does not show what live execution would be.
22
Draft not yet opened by a person in Excel or Google Sheets. Check the formulas before relying on them.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100