This spreadsheet demonstrates how to delta hedge an option to expiration.

I wrote it to demonstrate why having a view of the average volatility over a period is not enough to correctly delta hedge to expiration, even if your estimate of the average volatility is correct!

This page last modified on