O'Reilly logo

FX Derivatives Trader School by Giles Jewitt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Practical F

Constructing a Volatility Smile in Excel

Constructing a volatility smile using the Malz smile model builds understanding of the volatility surface market instruments. The Black-Scholes framework can then be used to calculate strikes for different deltas to show how the market instruments impact strike placement within the volatility smile.

Task A: Set Up the Malz Smile Model

Recall the Malz formula for implied volatility at a given (positive) delta put from Chapter 12:

equation

This formula can be coded up in Excel:

bappfuf001

Check that practf-math-0002 and the 25% put delta and 25% call delta (75% put delta) implied volatility matches up with the standard approximations:

  • practf-math-0003
  • practf-math-0004

Task B: Plot Implied Volatility versus Delta and Investigate Parameters

The function output can be extended to generate a full volatility smile from 0% to 100% delta:

bappfuf002

The volatility smile can then be plotted:

Check that the volatility ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required