EXOTICS XL
|
EXOTICS XL is a Microsoft Excel add-in program that allows you to value non-standard option and derivative contracts. The types of contracts that may be valued using EXOTICS XL are Average Price and Rate ("Asian"), Barrier ("knockouts and knockins"), Binary, Chooser, Compound, Currency-Translated, Lookback, Portfolio, Rainbow and Spread options. To achieve the company's goal of remaining at the leading edge of option and derivative analytics, Montgomery Investment Technology, Inc. will develop new functions and pricing models to meet market demand. Specialty applications and functions can be created on a custom basis to meet your in-house needs. |
|
Average Price/Rate ("Asian") and Strike |
|
|
Knock-out/in with rebate capability |
|
|
Binary Barrier, All-Or-None and Gap |
|
|
Option to choose a call or put in the future |
|
|
Option to buy an option in the future |
|
|
FX Translated Options, "Quanto" |
|
|
Option exercise determined by Min / Max price |
|
|
Option on portfolio of two assets |
|
|
Option on minimum or maximum of two assets |
|
|
Option on 2 asset spread (e.g. "Crack" or "Spark") |
|
American and European-style knock-out/in options with rebate (binomial) |
|
|
American and European-style knock-out/in options with rebate (flexible binomial) |
|
|
Average, Barrier, Lookback, Standard contracts |
|
|
Implied Binomial Tree |
Based on research by Goldman (Derman) or Rubinstein (UC Berkeley) |
|
Finite Difference |
Finite Difference |
|
Modified Black-Scholes |
Price-diffusion for short-term options |
|
Cox-Ross-Rubinstein |
Price-diffusion for short-term options |
|
Rendleman and Bartter |
Yield-diffusion for short- to long-term options |
|
Hull-White |
Yield-diffusion for long-term options with mean reversion |
Exotics Calculator