You should check-out the Freeware Excel Add-in I put out a few years back, available at:
http://www.webcabcomponents.com/office/index.shtmlwith a number of standard Exotic and Vanilla Options contracts which are evaluated in accordance with the Black-Scholes model using either Monte Carloand/or Finite Differencing PDE pricing techniques. In particular, it offers the following contract pricing models: * Asian Options - Evaluate the present value using Monte Carlo or Finite Differencing pricing techniques. * Lookback Options - Evaluate the present value using Monte Carlo or Finite Differencing pricing techniques. * Barrier Options - Evaluate the present value using a Monte Carlo approach. * Parisian Options - Evaluate the present value using a Monte Carlo approach. * Parasian Options - Evaluate the present value using a Monte Carlo approach. * European (Vanilla) Options - Evaluate the present value using a Monte Carlo or Finite Differencing PDE pricing techniques * Binary Options (in particular, cash-or-nothing Binary Option) - Evaluate the present value using Monte Carlo or Finite Differencing PDE pricing techniques. The direct function doc link is:
http://www.webcabcomponents.com/office/ ... es.htmlits got a bunch of other stuff to, most useful for options being implied vol.I wanted to put something out for the community to use but naturally cannot offer much support and do not expect updates any timesoon since I have a cue forming for parties who all want J2EE based enterprise risk management systems (surprise, surprise).