The execution price is only one part of what an order costs. The shares that were not bought and the price they moved to are also part of the bill.
A client orders 500,000 shares at an arrival price of $40.00. The desk fills 400,000 at an average of $40.1773 and stops, with the stock closing at $40.52. The implementation shortfall is $128,900, or 64.5 basis points of the $20,000,000 paper value of the order. 40.3% of it is the cost of the 100,000 shares that were never bought, a cost an execution-price report does not show.
| Item | Value |
|---|---|
| Order | Buy 500,000 shares |
| Arrival price (the price when the order reaches the desk) | $40.00 |
| Paper value of the order | $20,000,000 (500,000 × $40.00) |
| Fill 1 | 150,000 at $40.06 |
| Fill 2 | 120,000 at $40.18 |
| Fill 3 | 130,000 at $40.31 |
| Unfilled when the order is cancelled | 100,000 shares |
| Closing price on the day | $40.52 |
| Commission | $0.015 a share filled |
Implementation shortfall compares what the client holds at the end with what it would have held had the whole order been done at the arrival price. It has three parts: what was paid above the arrival price, what the missed shares have since gained, and the commission.
Average price = (150,000 × 40.06 + 120,000 × 40.18 + 130,000 × 40.31) / 400,000 = $40.1773
Execution cost = (40.1773 − 40.00) × 400,000 = $70,900
Excel: =(SUMPRODUCT(Shares,Price)/SUM(Shares)-Arrival)*SUM(Shares)
Unfilled = 500,000 − 400,000 = 100,000 shares
Opportunity cost = 100,000 × (40.52 − 40.00) = $52,000
Excel: =(Order-SUM(Shares))*(Close-Arrival)
| Component | $ | Basis points of paper value |
|---|---|---|
| Execution cost on 400,000 shares | 70,900 | 35.5 |
| Opportunity cost on 100,000 shares | 52,000 | 26.0 |
| Commission | 6,000 | 3.0 |
| Implementation shortfall | 128,900 | 64.5 |
The execution price alone, 35.5 basis points, is 55.0% of the total. A report that stopped there would leave out the cost of stopping after 80% of the order.
| Closing price | Opportunity cost, $ | Shortfall, $ | Basis points |
|---|---|---|---|
| $40.10 | 10,000 | 86,900 | 43.5 |
| $40.30 | 30,000 | 106,900 | 53.5 |
| $40.40 | 40,000 | 116,900 | 58.5 |
| $40.52 | 52,000 | 128,900 | 64.5 |
| $40.80 | 80,000 | 156,900 | 78.5 |
The shortfall rises by $10,000 for every 10 cents of closing price, because 100,000 shares are missing. The opportunity cost equals the execution cost when the stock closes at $40.71; below that, the part of the order that was done costs more than the part that was not.
The difference between the result of the order as a paper trade, executed in full at the arrival price, and its actual result: execution cost, opportunity cost on any unfilled shares, and commission. Here $128,900, or 64.5 basis points of $20,000,000.
Multiply the unfilled shares by the move from the arrival price to the closing price. 100,000 shares × ($40.52 − $40.00) = $52,000.
VWAP depends on the trading that happens after the order starts and can make a delayed or partly filled order look cheap. In this example the fills are $25,100 better than VWAP but the order still cost $128,900 against the arrival price.
The free companion files for The Equity Sales and Trading Professional rebuild a fictional equities desk's year, with commissions, trading cost, execution quality and the desk's profit and loss. The order in this article is invented and is not in them. No account and no email address.
Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →