Futures and cash basis convergence P&L · Calculation guide

Calculate the result on long physical inventory hedged with short futures.

Calculation guide

Equal units in both legs, same quote currency and multiplier already applied. Deduct total carrying and trading costs once. Basis is cash minus futures.

pnl = qty*(cashout-cashin+futin-futout)-cost · basisin = cashin-futin · basisout = cashout-futout

Inputs

Initial cash price

Example entry 98 (in the selected currency).

Final cash price

Example entry 103 (in the selected currency).

Initial futures price

Example entry 102 (in the selected currency).

Final futures price

Example entry 104 (in the selected currency).

Order quantity

Example entry 100.

Total carry and fees

Example entry 30 (in the selected currency).

Worked example

InputValue
Initial cash price98
Final cash price103
Initial futures price102
Final futures price104
Order quantity100
Total carry and fees30
ResultValue
Profit · Hedged position270
Opening basis-4
Closing basis-1

Calculation steps

Net hedged result = ((Order quantity × (((Final cash price − Initial cash price) + Initial futures price) − Final futures price)) − Total carry and fees)

((100 × (((103 − 98) + 102) − 104)) − 30) = 270

Opening basis = (Initial cash price − Initial futures price)

(98 − 102) = -4

Closing basis = (Final cash price − Final futures price)

(103 − 104) = -1

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Initial cash price98108Net result · Hedged position270-730
Final cash price103113Profit · Hedged position2701,270
Initial futures price102112Profit · Hedged position2701,270
Final futures price104114Net result · Hedged position270-730
Order quantity100110Profit · Hedged position270300
Total carry and fees3033Profit · Hedged position270267
Futures and cash basis convergence P&L →

Sources