XOPTION

 XOPTION is an option pricing function that you can call from any worksheet cell.  Using XOPTION, you can price both American and European stock options, stock index options, and currency options.  Furthermore, you can also compute implied volatility of European options.  XOPTION provides you with all the “Greeks” (Delta, Gamma, Theta, Vega, and Rho) you need to hedge your American and European options.  XOPTION uses Crank-Nicolson numerical method for solving American options, hence the function is unconditionally stable and convergent.  Because XOPTION is just like any other worksheet functions, you can easily incorporate it into your worksheet model. 

Release 1.0 Features

• Pricing for both American and European stock options, stock index options, and currency options.

• Crank-Nicolson numerical method for unconditional stability and convergence in solving American options.

• Variable price and time grids for flexibility to optimize between speed and accuracy.

• Complete "Greeks" (Delta, Gamma, Theta, Vega, and Rho) for optimum hedging strategy.

• Implied volatility for European options.

• Converts into unexpired version with purchased license.

• Comprehensive helps to get you started right away.

• 15 days full version free trial.

Requirements

• Excel 97, or later.

• Windows 95, or later.