CapeTools Storage




Welcome | Documentation format | QuantTools Groups | QuantTools Categories | Licence

Key TAGs | Excel Index | API Index


http://www.QuantTools.com

In total there are 41 functions present within the CapeTools Storage category of functions.


General Description

Functions that price vanilla and Exotic options using variations of the black-scholes model. These functions create portfolio objects. The benefit of these functions is that there are external functions to sort and group deals. You can mix option contracts from different currencies and finally you can price the whole portfolio a selection of the portfolio in any currency (via an FX manager object).

In addition, each parameter has a range object (excel range) as an input parameter. You can input a single-valued number in a range and if the function detects that the size of the other input ranges are longer, the function will automatically expand the single range to the same size. Every cell will contain the same constant number. This is used heavily within our examples.

You can commit the trades (portfolio) to disk via the numerous range-to XML and XML to range functions present within the 'CapeTools Utils' category of functions.

Once a portfolio has been created, the 'CapeTools Exotic Options Tools' category of functions is responsible for selecting, grouping and pricing these portfolios.

The SubOptionBook() function is responsible for selecting trades via an SQL type criteria and creating a new portfolio object.

The GroupOptionBook() function is responsible for grouping trades via an SQL type criteria and creating a new portfolio object.

The DisplayOptionGroups() function will display the unique columns of the grouped portfolio

The DisplayGRPOptionBook() function will display the trades within the selected group. A list of possible groups can be determined via the said DisplayOptionGroups() function.

The DisplayOptionBook() function will display the trades within a portfolio, sorted on a list of columns.

The PriceOptionBook() function will price the portfolio. This function holds a 'Greek' parameter and this parameter taylors what number are generated.

When priced, you can request the price for the total portfolio, the price of each trade. In addition you can request detailed information for each trade.

All of the functions implemented here have been taken from : 'The Complete Guide To OPTION PRICING FORMULAS' by Espen Gaarder Haug. This book provides an in-depth analysis of every function described here. We have just implemented these functions in C++ and extended their functionality to include risk-numbers.




Function list.

Copyright (c) 2003-2007 CapeTools - All Rights Reserved.