XSWBKDisplayLeg

XSWBKDisplayLeg

http://www.QuantTools.com
CapeTools XCcy Swap Portfolio function list

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

Returns a range of information (regarding a swap leg) given a swap object.

The function requires the input of a xccy swap portfolio (against the dollar) object which must have been constructed via the XCcySwapPortfolio() function.

This function would have returned a string 'KEY' which is to be passed to the 'SWBookKey' parameter of this function.

Note: Within Excel, the function is named - CT.BOOK.XSWBKDisplayLeg

High level graphic of XSWBKDisplayLeg() function with parameters. Blue square node is the actual function with the parameters ordered.

Parameter Description

SWBookKey parameter

Key Handle to an already constructed XCcy Swap Portfolio (Book) object.
SWDealID parameter

The XCcy Swap deal ID to query for.

Extended information

Function Syntax

Parameter data types

ArgName	ArgType	IsKey
SWBookKey	String	TRUE
SWDealID	String	FALSE

Example Inputs

ArgName	IsOptional (Excel only)	Example
SWBookKey	FALSE	SWBookKeyNAME.EXTTAG.TICKER (from a function call)
SWDealID	FALSE	XSW-123456

Example function usage

The C# example below contains all the sub-function calls leading up to this function call. As a result, the example can contain a lot of code.

The VB.NET, J#, C++.NET, Java, Excel VBA, Visual Basic 6 (via COM) and C++ examples below contain function code stubs for the calls leading up to this function call. However, the function call for this function is displayed.
You can easily reproduce the stub functions code from the C# example.

If you are accessing this functrion via the MiniXL libraries, this function is present within the CT.QL.IRPortfolio20 MiniXL Excel Addin.

Within our Excel Example Addin Generator, we have used the following QuantTools sub-functions in order to prepare the arguments needed to call the XSWBKDisplayLeg() function. If you are executing this function via the MiniXL libraries, the module addin name, (in brackets, to the right of the sub-functions listed below), indicates the MiniXL library in which the sub-function is held. You will need to load this library into your Excel session (along with any other libraries that the sub-function call within the addin requires (ie - CT.QT.Utils20 addin in almost all cases) in order for the example to compute successfully.

These are the financial QuantTools sub-function calls that are used within the examples :

CALUKExchange() ( CT.QL.Curves20 )
CALEURO() ( CT.QL.Curves20 )
ValueDateObj() ( CT.QL.Utils20 )
CALUKSettlement() ( CT.QL.Curves20 )
CALTARGET() ( CT.QL.Curves20 )
CreateDepoTemplate() ( CT.QL.Curves20 )
CreateSwapTemplate() ( CT.QL.Curves20 )
MKTYC_XCCY_D() ( CT.QL.Curves20 )
SABRVolCurve() ( CT.QL.Curves20 )
CreateIndex() ( CT.QL.Curves20 )
CreateSwapIndex() ( CT.QL.Curves20 )
MKTYC_D() ( CT.QL.Curves20 )
IDXGBPLibor() ( CT.QL.Curves20 )
GroupedIndex() ( CT.QL.Curves20 )
XCcySwapPortfolio() ( CT.QL.IRPortfolio20 )
XSWBKDisplayLeg() ( CT.QL.IRPortfolio20 )

The objects generated by these sub-functions are inter-connected in the following way :

The following four examples demostrate calling this function within a Microsoft .NET environment

The following four examples demostrate calling this function within a non .NET environment

The following is a sample output from executing the XSWBKDisplayLeg() function call

Example
Gearing	Notional (EUR)	FixingDate	PeriodStartDate	PeriodEndDate	PayDate	IndexStartDate	IndexEndDate	Coverage	Fixings	Gearing*Fixings+Margins	DCF
1	5e+007	40743	40745	40837	40837	40745	40837	0.252055	0.0394146	0.0396146	0.788066
1	5e+007	40835	40837	40931	40931	40837	40931	0.257534	0.0394188	0.0396188	0.780211
1	5e+007	40927	40931	41022	41022	40931	41022	0.249315	0.0394125	0.0396125	0.772681
1	5e+007	41018	41022	41113	41113	41022	41113	0.249315	0.0394125	0.0396125	0.765224
1	5e+007	41109	41113	41204	41204	41113	41205	0.249315	0.0394146	0.0396146	0.757838
1	5e+007	41200	41204	41295	41295	41204	41296	0.249315	0.0394146	0.0396146	0.750524
1	5e+007	41291	41295	41386	41386	41295	41386	0.249315	0.0394125	0.0396125	0.743281
1	5e+007	41382	41386	41477	41477	41386	41477	0.249315	0.0394125	0.0396125	0.736108
1	5e+007	41473	41477	41568	41568	41477	41569	0.249315	0.0394146	0.0396146	0.729003
1	5e+007	41564	41568	41660	41660	41568	41660	0.252055	0.0394146	0.0396146	0.721891
1	5e+007	41656	41660	41751	41751	41660	41751	0.249315	0.0394125	0.0396125	0.714924
1	5e+007	41745	41751	41841	41841	41751	41842	0.246575	0.0394125	0.0396125	0.708099
1	5e+007	41837	41841	41933	41933	41841	41933	0.252055	0.0394146	0.0396146	0.701191
1	5e+007	41929	41933	42025	42025	41933	42025	0.252055	0.0394146	0.0396146	0.69435
1	5e+007	42023	42025	42115	42115	42025	42115	0.246575	0.0394104	0.0396104	0.687722
1	5e+007	42111	42115	42206	42206	42115	42206	0.249315	0.0394125	0.0396125	0.681084
1	5e+007	42202	42206	42298	42298	42206	42298	0.252055	0.0480863	0.0482863	0.672967
1	5e+007	42296	42298	42390	42390	42298	42390	0.252055	0.0480863	0.0482863	0.664946
1	5e+007	42388	42390	42481	42481	42390	42481	0.249315	0.0480831	0.0482831	0.657107
1	5e+007	42479	42481	42572	42572	42481	42572	0.249315	0.0480831	0.0482831	0.64936