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.
Windows 95/98/Me/2000/XP, MS Excel 97
Like it? Share with your friends!
Other Windows Software of Developer «ExcelQuant»:
Portfolio Designer XP Use Excel XP & Portfolio Designer to diagnose your existing stock and mutual fund holdings, allocate new investments, combine your equity portfolio with a fixed income product, protect your portfolio value, and back test your portfolio against a benchmark.
Funds Selector Find out which mutual funds have a good chance of beating an index using Microsoft Excel and the Funds Selector. The Funds Selector quantifies the probability of mutual funds beating a benchmark index of your choice based on the funds' performance. It tell