Articles

How is implementation shortfall calculated on a partly filled order?

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.

The assumptions

Illustrative buy order, invented figures
ItemValue
OrderBuy 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 1150,000 at $40.06
Fill 2120,000 at $40.18
Fill 3130,000 at $40.31
Unfilled when the order is cancelled100,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.

Step 1: the execution cost on the shares that were bought

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)

Step 2: the opportunity cost of the shares that were not bought

Unfilled = 500,000 − 400,000 = 100,000 shares

Opportunity cost = 100,000 × (40.52 − 40.00) = $52,000

Excel: =(Order-SUM(Shares))*(Close-Arrival)

Step 3: the total

Implementation shortfall
Component$Basis points of paper value
Execution cost on 400,000 shares70,90035.5
Opportunity cost on 100,000 shares52,00026.0
Commission6,0003.0
Implementation shortfall128,90064.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.

What if: the close is different

Shortfall at different closing prices, same fills
Closing priceOpportunity cost, $Shortfall, $Basis points
$40.1010,00086,90043.5
$40.3030,000106,90053.5
$40.4040,000116,90058.5
$40.5252,000128,90064.5
$40.8080,000156,90078.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 common mistakes

Takeaway

Questions readers ask

What is implementation shortfall?

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.

How is the opportunity cost of an unfilled order calculated?

Multiply the unfilled shares by the move from the arrival price to the closing price. 100,000 shares × ($40.52 − $40.00) = $52,000.

Why is implementation shortfall better than comparing with VWAP?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 10 paperbacks by Julian R. Sterling on tax and incentives, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →