Implied Dividend Calculator

This article teaches you how to calculate the implied dividend of an option via put-call parity, illustrated with an Excel spreadsheet.

Option Pricing with Skew and Kurtosis

Learn about the Corrado & Su (1996) model for pricing options with excess skew and kurtosis, and get a pricing spreadsheet.

Mirror Options

Mirror options let investors change their view of the direction of the underlying stock, but without additional transaction costs. Get a pricing spreadsheet here.

Probability of a Successful Option Trade

Calculate the probability of making money in an option trade with this free Excel spreadsheet.

Roll-Geske-Whaley Method to Price American Options

Learn how to price American call options with the Roll-Geske-Whaley method, and get an Excel spreadsheet.

Calculate Implied Volatility with the Bisection Method

Get an Excel spreadsheet & VBA to calculate implied volatility with the bisection method. Discover how numerical bisection works, its advantages and disadvantages

Pricing Bond Options with a Binomial Tree

This Excel spreadsheet calculates the price of a Bond option with a binomial tree. Bond options give the purchaser the …

Monte Carlo Option Pricing with Excel

Learn how to price options with the Monte Carlo method, and get a pricing spreadsheet for European, Asian, Barrier and Lookback options.

Garman Kohlhagen Model and VBA

Get VBA and an Excel spreadsheet for the Garman Kohlhagen model, a method of pricing European foreign exchange options.

Black-Scholes and Greeks in VBA

Get VBA and an Excel spreadsheet for Black-Scholes and the Greeks (Delta, Gamma, Vega, Theta, Rho) here. You can easily use the VBA in your own option pricing spreadsheets.

Pricing Double Barrier Options

Double Barrier options are path-dependent options. They have two pre-defined barriers, one higher and one lower than the current asset …