An Excel 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.
What's new in version 1.0
ReleaseNovember 8, 2008
Date AddedMarch 24, 2003
Operating SystemsWindows 95, Windows 2000, Windows 98, Windows Me, Windows, Windows XP
Additional RequirementsWindows 95/98/Me/2000/XP, MS Excel 97