CreateVegaReport Example CS





http://www.QuantTools.com
CapeTools IR Risk function list
CreateVegaReport function

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

Key TAGs | Excel Index | API Index



Example C# Driver function. Preparing the parameters, sub-function calls and the final function call (the result).

High level view of the code structure (resulting in the final function call to CreateVegaReport() )

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





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




C# Example - CreateVegaReport





    //     ##################################################################################
    //     The first function here CreateVegaReport(), contains a series of
    //     function calls leading upto the main function call, the second function
    //     within this file ( CreateVegaReportPart() ).
    //     which contains the answer that we are looking for.

    //     The first function here is simply an example of how to construct the parameters 
    //     in order acquire either a string Key (that is to be passed to other functions) 
    //     or a computed result.

    //     If you are viewing this source code from the chm or web help file you can use the
    //     outlining features to collapse certain sections of the code for better readability. 
    //     ##################################################################################
    

using System;

// Optional using instruction. We will use a mix of utilising fully qualified names (in the case of the financial objects)
// and using the reduced version (in the case of declaring enumerations).
// This is just to demostrate both types of coding.

using CTQL; // You need to add a reference to the QuantToolsNET.v2.dll also

// Some global parameter in order to append to user defined keys.
// We use it here to ensure that we have unique Keys (in the case several of our examples
// use the same key-name)
// In normal use, a user defined string will be used and so this variable will be pointless.
static int nCTIRRiskGlobal;
    
// Used by function parameters that take an optional range value. 
// In Excel we simply omit the value, within the API functions, 
// we pass an empty range object
static CTQL.CTRangeData oEmptyRange = new CTQL.CTRangeData();
    
public string CS_EX_CreateVegaReport()
{
    nCTIRRiskGlobal += 1;
            
    string szErrorMsg = "";

    try
    {


    //    Loads a FX table from a range object into a Exchange Rate Manager 
    //    object.
    

    string MyFXManager;
    MyFXManager = 
        CreateFXManagerPart();
    
    


    //    EURO calendar used for holiday adjustments.
    

    string MyEuroCal;
    MyEuroCal = 
        CALEUROPart();
    
    


    //    UK date calendar used within the UK stock exchange.
    

    string MyCALUKExchange;
    MyCALUKExchange = 
        CALUKExchangePart();
    
    


    //    Creates a centralized valuation date object.
    

    string MyValuationDate;
    MyValuationDate = 
        ValueDateObjPart();
    
    


    //    Generates a schedule of start and end dates, given the initial 
    //    start date and unadjusted final end dates.
    
    string MySchedule;
    MySchedule = 
        MakeSchedulePart(
        MyEuroCal);
    
    


    //    Creates a Deposit template which is almost identical to a Libor 
    //    Index, but without the YieldCurve information.
    
    string MyDepoTPL;
    MyDepoTPL = 
        CreateDepoTemplatePart(
        MyCALUKExchange,
        MyEuroCal);
    
    


    //    Creates a Swap template which is almost identical to the definition 
    //    of the parameters of a swap contract, but without the swap duration, 
    //    buysell, and YieldCurve information.
    
    string MySwapTPL;
    MySwapTPL = 
        CreateSwapTemplatePart(
        MyEuroCal,
        MyDepoTPL);
    
    


    //    Creates a SABR curve to model the dynamics of the volatility 
    //    curve (smile).
    
    string MySABRVolCurve;
    MySABRVolCurve = 
        SABRVolCurvePart(
        MyValuationDate,
        MyDepoTPL,
        MySwapTPL);
    
    


    //    Creates an amortisation object to be used within the amortisation 
    //    fixed and floating rate leg objects.
    
    string MyCreateAmortObj;
    MyCreateAmortObj = 
        CreateAmortObjPart(
        MySchedule);
    
    


    //    Creates a yield curve using market rates (No cross-currency 
    //    Swaps).
    
    string MyMiniYC;
    MyMiniYC = 
        MKTYC_D__3Part(
        MyValuationDate,
        MyDepoTPL,
        MySwapTPL);
    
    


    //    Creates a new Index code.
    
    string MyNewIndex2;
    MyNewIndex2 = 
        CreateIndex__2Part(
        MyCALUKExchange,
        MyEuroCal,
        MyMiniYC);
    
    


    //    Creates a market object which is an aggregate of interest rate 
    //    market objects (Discounting curve and Interest rate volatility 
    //    curve (volcurve)).
    
    string MyMarket4;
    MyMarket4 = 
        CreateMKT__4Part(
        MyMiniYC,
        MySABRVolCurve);
    
    


    //    Creates a floating rate leg.
    
    string MyCreateFloatLeg3;
    MyCreateFloatLeg3 = 
        CreateFloatLeg__3Part(
        MySchedule,
        MyNewIndex2,
        MyMarket4);
    
    


    //    Creates an amortised floating rate leg.
    
    string MyCreateAmortFloatLeg2;
    MyCreateAmortFloatLeg2 = 
        CreateAmortFloatLeg__2Part(
        MyCreateAmortObj,
        MyNewIndex2,
        MyMarket4);
    
    


    //    Creates a Fixed rate leg.
    
    string MyCreateFixedRateLeg3;
    MyCreateFixedRateLeg3 = 
        CreateFixedRateLeg__3Part(
        MySchedule,
        MyMarket4);
    
    


    //    This floating leg (or FRN) only provide one payoff.
    
    string MyCreateZCFloatLeg2;
    MyCreateZCFloatLeg2 = 
        CreateZCFloatLeg__2Part(
        MySchedule,
        MyNewIndex2,
        MyMarket4);
    
    


    //    Creates an amortised fixed rate leg.
    
    string MyCreateAmortFixLeg2;
    MyCreateAmortFixLeg2 = 
        CreateAmortFixLeg__2Part(
        MyCreateAmortObj,
        MyMarket4);
    
    


    //    Creates a porfolio of caplet or floorlet options from this floating 
    //    Rate Leg.
    
    string MyCreateCapFLTLeg2;
    MyCreateCapFLTLeg2 = 
        CreateCapFLTLeg__2Part(
        MyCreateFloatLeg3,
        MySABRVolCurve);
    
    


    //    Creates a Structure object (which is really a portfolio of leg 
    //    objects).
    
    string MyStructure;
    MyStructure = 
        CreateStructurePart(
        MyCreateAmortFloatLeg2,
        MyCreateFixedRateLeg3,
        MyCreateZCFloatLeg2,
        MyCreateAmortFixLeg2,
        MyCreateCapFLTLeg2);
    
    


    //    Creates a Vega report object given a Structure object and a 
    //    shift parameter.
    
    string MyVegaReport;
    MyVegaReport = 
        CreateVegaReportPart(
        MyStructure,
        MySABRVolCurve,
        MyFXManager);
    
    // This is the result we are looking for.
    return MyVegaReport;
    

    }
    catch(Exception e)
    {
        szErrorMsg = e.Message;
        throw e;
    }
                        
}                
        


// ///////////////////////////////////////////////////////////////////

private string CreateVegaReportPart(
    string MyStructure,
    string MySABRVolCurve,
    string MyFXManager)
{



    //    Key value to use as a handle for the created object
        string MyVegaReport = "MyVegaReport" + "_" + System.Convert.ToString(nCTIRRiskGlobal);

    //    When creating this object for the first time, set this parameter 
    //    to a positive value.
        int Reload = 1;

    //    The shift that you wish to apply to all points within the VolCurve 
    //    in percent.
        int VolShift = 1;

    //    Currency code that you wish the risk report values to be stored 
    //    in.
        CTIEnums.CCYEnum ReportPVCcy = CTIEnums.CCYEnum.CCY_EUR;

                    
    //  Excel function call would be this - "CT.RSK.CreateVegaReport()"

    //    Creates a Vega report object given a Structure object and a 
    //    shift parameter.
        string rCreateVegaReport;
                                        
        rCreateVegaReport = CTQL.CTIRRiskSA.CreateVegaReport(
                MyVegaReport,
                Reload,
                MyStructure,
                MySABRVolCurve,
                VolShift,
                MyFXManager,
                ReportPVCcy);


    return rCreateVegaReport;
}        



// ///////////////////////////////////////////////////////////////////

private string CreateStructurePart(
    string MyCreateAmortFloatLeg2,
    string MyCreateFixedRateLeg3,
    string MyCreateZCFloatLeg2,
    string MyCreateAmortFixLeg2,
    string MyCreateCapFLTLeg2)
{

        //  Create example range for parameter CreateStructure_Legs
        CTQL.CTRangeData CreateStructure_Legs;    
        

        string[] arrBCreateStructure_Legs = { 
            MyCreateAmortFloatLeg2, 
            MyCreateFixedRateLeg3, 
            MyCreateZCFloatLeg2, 
            MyCreateAmortFixLeg2, 
            MyCreateCapFLTLeg2  //  Array Data
        
        };
        
        CTQL.StringVector arrCreateStructure_Legs = 
            new  CTQL.StringVector(arrBCreateStructure_Legs);
    
        // Second parameter determines whether the array is a column array (false) or a row array (true)
        CreateStructure_Legs = new  CTQL.CTRangeData(arrCreateStructure_Legs, false);
            


    //    Key value to use as a handle for the created object
        string MyStructure = "MyStructure" + "_" + System.Convert.ToString(nCTIRRiskGlobal);

    //    When creating this object for the first time, set this parameter 
    //    to a positive value.
        int Reload = 1;

                    
    //  Excel function call would be this - "CT.LEG.CreateStructure()"

    //    Creates a Structure object (which is really a portfolio of leg 
    //    objects).
        string rCreateStructure;
                                        
        rCreateStructure = CTQL.CTQryLegsSA.CreateStructure(
                MyStructure,
                Reload,
                CreateStructure_Legs);


    return rCreateStructure;
}        



// ///////////////////////////////////////////////////////////////////

private string SABRVolCurvePart(
    string MyValuationDate,
    string MyDepoTPL,
    string MySwapTPL)
{

        //  Create example range for parameter SABRVolCurve_ATMRange
        CTQL.CTRangeData SABRVolCurve_ATMRange = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder SABRVolCurve_ATMRange_builder = 
            new System.Text.StringBuilder(100);
                         
        // We could set the value for each cell individually, but for display
        // purposes, this is quicker and more informative.
        SABRVolCurve_ATMRange_builder.Append("{");
        SABRVolCurve_ATMRange_builder.Append("'Opt\\Und'     | '3M'     | '6M'     | '9M'     | '12M'     | '2Y'     | '4Y'     | '6Y'     | '8Y'     | '10Y'     | '12Y'     | '14Y'     | '16Y' ;");
        SABRVolCurve_ATMRange_builder.Append("'3M'     | 18     | 18.01     | 18.02     | 18.02     | 18.03     | 18.04     | 18.05     | 18.06     | 18.07     | 18.07     | 18.08     | 18.09 ;");
        SABRVolCurve_ATMRange_builder.Append("'6M'     | 18.1     | 18.11     | 18.12     | 18.12     | 18.13     | 18.14     | 18.15     | 18.16     | 18.17     | 18.17     | 18.18     | 18.19 ;");
        SABRVolCurve_ATMRange_builder.Append("'9M'     | 18.19     | 18.2     | 18.21     | 18.22     | 18.22     | 18.23     | 18.24     | 18.25     | 18.26     | 18.26     | 18.27     | 18.28 ;");
        SABRVolCurve_ATMRange_builder.Append("'12M'     | 18.29     | 18.29     | 18.3     | 18.31     | 18.32     | 18.32     | 18.33     | 18.34     | 18.34     | 18.35     | 18.36     | 18.37 ;");
        SABRVolCurve_ATMRange_builder.Append("'2Y'     | 18.37     | 18.38     | 18.39     | 18.4     | 18.41     | 18.42     | 18.42     | 18.43     | 18.44     | 18.44     | 18.45     | 18.46 ;");
        SABRVolCurve_ATMRange_builder.Append("'4Y'     | 18.46     | 18.47     | 18.48     | 18.48     | 18.49     | 18.5     | 18.5     | 18.51     | 18.52     | 18.53     | 18.53     | 18.54 ;");
        SABRVolCurve_ATMRange_builder.Append("'6Y'     | 18.55     | 18.55     | 18.56     | 18.57     | 18.57     | 18.58     | 18.59     | 18.6     | 18.6     | 18.61     | 18.62     | 18.62 ;");
        SABRVolCurve_ATMRange_builder.Append("'8Y'     | 18.63     | 18.64     | 18.64     | 18.65     | 18.66     | 18.66     | 18.67     | 18.68     | 18.69     | 18.69     | 18.7     | 18.71 ;");
        SABRVolCurve_ATMRange_builder.Append("'10Y'     | 18.71     | 18.72     | 18.73     | 18.74     | 18.75     | 18.75     | 18.76     | 18.77     | 18.78     | 18.79     | 18.79     | 18.8 ;");
        SABRVolCurve_ATMRange_builder.Append("'12Y'     | 18.81     | 18.81     | 18.82     | 18.83     | 18.84     | 18.84     | 18.85     | 18.86     | 18.87     | 18.87     | 18.88     | 18.88 ;");
        SABRVolCurve_ATMRange_builder.Append("'14Y'     | 18.89     | 18.9     | 18.91     | 18.92     | 18.92     | 18.93     | 18.94     | 18.95     | 18.96     | 18.96     | 18.97     | 18.98 ;");
        SABRVolCurve_ATMRange_builder.Append("'16Y'     | 18.99     | 18.99     | 19     | 19.01     | 19.02     | 19.03     | 19.04     | 19.05     | 19.05     | 19.06     | 19.07     | 19.07 ;");
        SABRVolCurve_ATMRange_builder.Append("'18Y'     | 19.08     | 19.08     | 19.09     | 19.1     | 19.11     | 19.11     | 19.12     | 19.13     | 19.13     | 19.14     | 19.15     | 19.16 ;");
        SABRVolCurve_ATMRange_builder.Append("'20Y'     | 19.16     | 19.17     | 19.18     | 19.18     | 19.19     | 19.2     | 19.21     | 19.21     | 19.22     | 19.22     | 19.23     | 19.24 ;");
        SABRVolCurve_ATMRange_builder.Append("'22Y'     | 19.25     | 19.26     | 19.26     | 19.27     | 19.28     | 19.29     | 19.29     | 19.3     | 19.31     | 19.32     | 19.32     | 19.33");
        SABRVolCurve_ATMRange_builder.Append("}");
        
        SABRVolCurve_ATMRange.RangeFromStr
        (
            SABRVolCurve_ATMRange_builder.ToString()
        );
                     
        //  Create example range for parameter SABRVolCurve_ALPHARange
        CTQL.CTRangeData SABRVolCurve_ALPHARange = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder SABRVolCurve_ALPHARange_builder = 
            new System.Text.StringBuilder(100);
                         
        // We could set the value for each cell individually, but for display
        // purposes, this is quicker and more informative.
        SABRVolCurve_ALPHARange_builder.Append("{");
        SABRVolCurve_ALPHARange_builder.Append("'Opt\\Und'     | '3M'     | '6M'     | '9M'     | '12M'     | '2Y'     | '4Y'     | '6Y'     | '8Y'     | '10Y'     | '12Y'     | '14Y'     | '16Y' ;");
        SABRVolCurve_ALPHARange_builder.Append("'3M'     | 0.4     | 0.4     | 0.4     | 0.4     | 0.41     | 0.41     | 0.41     | 0.41     | 0.41     | 0.41     | 0.41     | 0.42 ;");
        SABRVolCurve_ALPHARange_builder.Append("'6M'     | 0.42     | 0.42     | 0.42     | 0.42     | 0.42     | 0.42     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43 ;");
        SABRVolCurve_ALPHARange_builder.Append("'9M'     | 0.43     | 0.44     | 0.44     | 0.44     | 0.44     | 0.44     | 0.44     | 0.45     | 0.45     | 0.45     | 0.45     | 0.45 ;");
        SABRVolCurve_ALPHARange_builder.Append("'12M'     | 0.45     | 0.45     | 0.46     | 0.46     | 0.46     | 0.46     | 0.46     | 0.46     | 0.46     | 0.47     | 0.47     | 0.47 ;");
        SABRVolCurve_ALPHARange_builder.Append("'2Y'     | 0.47     | 0.47     | 0.47     | 0.47     | 0.48     | 0.48     | 0.48     | 0.48     | 0.48     | 0.48     | 0.49     | 0.49 ;");
        SABRVolCurve_ALPHARange_builder.Append("'4Y'     | 0.49     | 0.49     | 0.49     | 0.49     | 0.49     | 0.49     | 0.5     | 0.5     | 0.5     | 0.5     | 0.5     | 0.5 ;");
        SABRVolCurve_ALPHARange_builder.Append("'6Y'     | 0.51     | 0.51     | 0.51     | 0.51     | 0.51     | 0.51     | 0.52     | 0.52     | 0.52     | 0.52     | 0.52     | 0.52 ;");
        SABRVolCurve_ALPHARange_builder.Append("'8Y'     | 0.52     | 0.53     | 0.53     | 0.53     | 0.53     | 0.53     | 0.53     | 0.53     | 0.54     | 0.54     | 0.54     | 0.54 ;");
        SABRVolCurve_ALPHARange_builder.Append("'10Y'     | 0.54     | 0.54     | 0.54     | 0.55     | 0.55     | 0.55     | 0.55     | 0.55     | 0.55     | 0.55     | 0.56     | 0.56 ;");
        SABRVolCurve_ALPHARange_builder.Append("'12Y'     | 0.56     | 0.56     | 0.56     | 0.56     | 0.56     | 0.57     | 0.57     | 0.57     | 0.57     | 0.57     | 0.57     | 0.57 ;");
        SABRVolCurve_ALPHARange_builder.Append("'14Y'     | 0.57     | 0.58     | 0.58     | 0.58     | 0.58     | 0.58     | 0.58     | 0.58     | 0.59     | 0.59     | 0.59     | 0.59 ;");
        SABRVolCurve_ALPHARange_builder.Append("'16Y'     | 0.59     | 0.59     | 0.59     | 0.6     | 0.6     | 0.6     | 0.6     | 0.6     | 0.6     | 0.6     | 0.61     | 0.61 ;");
        SABRVolCurve_ALPHARange_builder.Append("'18Y'     | 0.61     | 0.61     | 0.61     | 0.61     | 0.61     | 0.62     | 0.62     | 0.62     | 0.62     | 0.62     | 0.62     | 0.62 ;");
        SABRVolCurve_ALPHARange_builder.Append("'20Y'     | 0.63     | 0.63     | 0.63     | 0.63     | 0.63     | 0.63     | 0.64     | 0.64     | 0.64     | 0.64     | 0.64     | 0.64 ;");
        SABRVolCurve_ALPHARange_builder.Append("'22Y'     | 0.65     | 0.65     | 0.65     | 0.65     | 0.65     | 0.65     | 0.65     | 0.65     | 0.66     | 0.66     | 0.66     | 0.66");
        SABRVolCurve_ALPHARange_builder.Append("}");
        
        SABRVolCurve_ALPHARange.RangeFromStr
        (
            SABRVolCurve_ALPHARange_builder.ToString()
        );
                     
        //  Create example range for parameter SABRVolCurve_BETARange
        CTQL.CTRangeData SABRVolCurve_BETARange = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder SABRVolCurve_BETARange_builder = 
            new System.Text.StringBuilder(100);
                         
        // We could set the value for each cell individually, but for display
        // purposes, this is quicker and more informative.
        SABRVolCurve_BETARange_builder.Append("{");
        SABRVolCurve_BETARange_builder.Append("'Opt\\Und'     | '3M'     | '6M'     | '9M'     | '12M'     | '2Y'     | '4Y'     | '6Y'     | '8Y'     | '10Y'     | '12Y'     | '14Y'     | '16Y' ;");
        SABRVolCurve_BETARange_builder.Append("'3M'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'6M'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'9M'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'12M'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'2Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'4Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'6Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'8Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'10Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'12Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'14Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'16Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'18Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'20Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7 ;");
        SABRVolCurve_BETARange_builder.Append("'22Y'     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7     | 0.7");
        SABRVolCurve_BETARange_builder.Append("}");
        
        SABRVolCurve_BETARange.RangeFromStr
        (
            SABRVolCurve_BETARange_builder.ToString()
        );
                     
        //  Create example range for parameter SABRVolCurve_RHORange
        CTQL.CTRangeData SABRVolCurve_RHORange = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder SABRVolCurve_RHORange_builder = 
            new System.Text.StringBuilder(100);
                         
        // We could set the value for each cell individually, but for display
        // purposes, this is quicker and more informative.
        SABRVolCurve_RHORange_builder.Append("{");
        SABRVolCurve_RHORange_builder.Append("'Opt\\Und'     | '3M'     | '6M'     | '9M'     | '12M'     | '2Y'     | '4Y'     | '6Y'     | '8Y'     | '10Y'     | '12Y'     | '14Y'     | '16Y' ;");
        SABRVolCurve_RHORange_builder.Append("'3M'     | 0.3     | 0.3     | 0.3     | 0.31     | 0.31     | 0.31     | 0.31     | 0.31     | 0.31     | 0.31     | 0.31     | 0.32 ;");
        SABRVolCurve_RHORange_builder.Append("'6M'     | 0.32     | 0.32     | 0.32     | 0.32     | 0.32     | 0.32     | 0.33     | 0.32     | 0.32     | 0.33     | 0.33     | 0.33 ;");
        SABRVolCurve_RHORange_builder.Append("'9M'     | 0.33     | 0.33     | 0.32     | 0.33     | 0.32     | 0.33     | 0.33     | 0.33     | 0.33     | 0.33     | 0.33     | 0.33 ;");
        SABRVolCurve_RHORange_builder.Append("'12M'     | 0.33     | 0.34     | 0.33     | 0.33     | 0.33     | 0.33     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34 ;");
        SABRVolCurve_RHORange_builder.Append("'2Y'     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.34     | 0.35     | 0.35 ;");
        SABRVolCurve_RHORange_builder.Append("'4Y'     | 0.35     | 0.35     | 0.36     | 0.36     | 0.36     | 0.36     | 0.36     | 0.36     | 0.36     | 0.36     | 0.36     | 0.36 ;");
        SABRVolCurve_RHORange_builder.Append("'6Y'     | 0.37     | 0.36     | 0.37     | 0.37     | 0.37     | 0.37     | 0.37     | 0.37     | 0.37     | 0.37     | 0.37     | 0.37 ;");
        SABRVolCurve_RHORange_builder.Append("'8Y'     | 0.38     | 0.38     | 0.38     | 0.37     | 0.37     | 0.37     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38 ;");
        SABRVolCurve_RHORange_builder.Append("'10Y'     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.37     | 0.38     | 0.37     | 0.38     | 0.38     | 0.38 ;");
        SABRVolCurve_RHORange_builder.Append("'12Y'     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.38     | 0.39     | 0.39     | 0.39     | 0.39 ;");
        SABRVolCurve_RHORange_builder.Append("'14Y'     | 0.39     | 0.39     | 0.39     | 0.39     | 0.39     | 0.39     | 0.4     | 0.39     | 0.39     | 0.39     | 0.4     | 0.4 ;");
        SABRVolCurve_RHORange_builder.Append("'16Y'     | 0.4     | 0.4     | 0.4     | 0.4     | 0.4     | 0.4     | 0.4     | 0.4     | 0.4     | 0.4     | 0.41     | 0.41 ;");
        SABRVolCurve_RHORange_builder.Append("'18Y'     | 0.41     | 0.41     | 0.41     | 0.41     | 0.41     | 0.41     | 0.42     | 0.42     | 0.41     | 0.42     | 0.42     | 0.42 ;");
        SABRVolCurve_RHORange_builder.Append("'20Y'     | 0.42     | 0.42     | 0.42     | 0.43     | 0.43     | 0.43     | 0.42     | 0.43     | 0.42     | 0.43     | 0.43     | 0.43 ;");
        SABRVolCurve_RHORange_builder.Append("'22Y'     | 0.42     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43     | 0.43");
        SABRVolCurve_RHORange_builder.Append("}");
        
        SABRVolCurve_RHORange.RangeFromStr
        (
            SABRVolCurve_RHORange_builder.ToString()
        );
                     


    //    Key value to use as a handle for the created object
        string MySABRVolCurve = "MySABRVolCurve" + "_" + System.Convert.ToString(nCTIRRiskGlobal);

    //    When creating this object for the first time, set this parameter 
    //    to a positive value.
        int Reload = 1;

    //    A tag used to identify this curve (case insensitive) if placed 
    //    within a Volatility curve collection ( via the GroupedVolCurves() 
    //    function ).
        string CurveName = "MySABRVolCurve";

    //    Number of days between the Exercise date of the options and 
    //    the STARTDATE of the instrument.
        int SettleDays = 2;

    //    Is the input volatility entered as a percentage value (true), 
    //    or the raw volatility value (false).
        bool DivideVolBy100 = true;

    //    DayCounter for converting dates into year fractions.
        CTIEnums.DayCountEnum DayCount = CTIEnums.DayCountEnum.DayCount_30360;

    //    Interpolation method to use when interpolating the curve for 
    //    vols, - LINEAR, LOGLINEAR, CUBIC.
        CTIEnums.InterpEnum InterpType = CTIEnums.InterpEnum.Interp_LINEAR;

                    
    //  Excel function call would be this - "CT.CRV.SABRVolCurve()"

    //    Creates a SABR curve to model the dynamics of the volatility 
    //    curve (smile).
        string rSABRVolCurve;
                                        
        rSABRVolCurve = CTQL.CTVolatiltyCurvesSA.SABRVolCurve(
                MySABRVolCurve,
                Reload,
                CurveName,
                MyValuationDate,
                SettleDays,
                SABRVolCurve_ATMRange,
                SABRVolCurve_ALPHARange,
                SABRVolCurve_BETARange,
                SABRVolCurve_RHORange,
                DivideVolBy100,
                MyDepoTPL,
                MySwapTPL,
                DayCount,
                InterpType);


    return rSABRVolCurve;
}        



// ///////////////////////////////////////////////////////////////////

private string CreateFXManagerPart()
{

        //  Create example range for parameter CreateFXManager_FXRange
        CTQL.CTRangeData CreateFXManager_FXRange = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder CreateFXManager_FXRange_builder = 
            new System.Text.StringBuilder(100);
                         
        // We could set the value for each cell individually, but for display
        // purposes, this is quicker and more informative.
        CreateFXManager_FXRange_builder.Append("{");
        CreateFXManager_FXRange_builder.Append("'EUR'     | 'GBP'     | 1.56 ;");
        CreateFXManager_FXRange_builder.Append("'EUR'     | 'USD'     | 1.3 ;");
        CreateFXManager_FXRange_builder.Append("'JPY'     | 'GBP'     | 100.5 ;");
        CreateFXManager_FXRange_builder.Append("'EUR'     | 'CHF'     | 1.6 ;");
        CreateFXManager_FXRange_builder.Append("'DKK'     | 'GBP'     | 35.35");
        CreateFXManager_FXRange_builder.Append("}");
        
        CreateFXManager_FXRange.RangeFromStr
        (
            CreateFXManager_FXRange_builder.ToString()
        );
                     


    //    Key that will be associated with this new object (the key will 
    //    be used internally to keep track of this object).
        string MyFXManager = "MyFXManager" + "_" + System.Convert.ToString(nCTIRRiskGlobal);

    //    When creating this object for the first time, set this parameter 
    //    to a positive value.
        int Reload = 1;

                    
    //  Excel function call would be this - "CT.FX.CreateFXManager()"

    //    Loads a FX table from a range object into a Exchange Rate Manager 
    //    object.
        string rCreateFXManager;
                                        
        rCreateFXManager = CTQL.CTCurrencySA.CreateFXManager(
                MyFXManager,
                Reload,
                CreateFXManager_FXRange);


    return rCreateFXManager;
}        



// ///////////////////////////////////////////////////////////////////

private string CreateAmortFloatLeg__2Part(
    string MyCreateAmortObj,
    string MyNewIndex2,
    string MyMarket4)
{

        //  Create example range for parameter CreateAmortFloatLeg__2_Margin
        CTQL.CTRangeData CreateAmortFloatLeg__2_Margin;    
        

        double[] arrBCreateAmortFloatLeg__2_Margin = { 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002, 
            0.0002  //  Array Data
        
        };
        
        CTQL.DoubleVector arrCreateAmortFloatLeg__2_Margin = 
            new  CTQL.DoubleVector(arrBCreateAmortFloatLeg__2_Margin);
    
        // Second parameter determines whether the array is a column array (false) or a row array (true)
        CreateAmortFloatLeg__2_Margin = new  CTQL.CTRangeData(arrCreateAmortFloatLeg__2_Margin, false);
            


    //    Key value to use as a handle for the created object
        string MyCreateAmortFloatLeg2 = "MyCreateAmortFloatLeg2" + "_" + System.Convert.ToString(nCTIRRiskGlobal);

    //    When creating this object for the first time, set this parameter 
    //    to a positive value.
        int Reload = 1;

    //    Whether you would like to PAY or REC this leg.
        CTIEnums.PAYRECEnum PayRec = CTIEnums.PAYRECEnum.PAYREC_REC;

    //    A positive factor value you wish to multiply the Floating-Reset 
    //    Rate/Fixed-Coupon Rate by (Usually 1).
        int Gearing = 1;

    //    Currency of the Notional amount.
        CTIEnums.CCYEnum Ccy = CTIEnums.CCYEnum.CCY_EUR;

    //    Payment Business Day Convention.
        CTIEnums.BDCEnum BusDayConv = CTIEnums.BDCEnum.BDC_modifiedfollowing;

    //    Payment DayCounter.
        CTIEnums.DayCountEnum DayCount = CTIEnums.DayCountEnum.DayCount_actual365_fixed;

    //    Whether you wish to exchange the principal amount(s) at the 
    //    start and termination of the leg contract.
        bool ExchangePrincipal = false;

    //    If a CMS index is specified (within the parameter 'IndexKey') 
    //    and the 'CMSAlgo' parameter within this CMS Index has been set 
    //    to 'Hull' then the correlation between swap rates and fwd rates 
    //    is required.
        double SMPFWDRho = 0.8;

                    
    //  Excel function call would be this - "CT.LEG.CreateAmortFloatLeg()"

    //    Creates an amortised floating rate leg.
        string rCreateAmortFloatLeg__2;
                                        
        rCreateAmortFloatLeg__2 = CTQL.CTLegsSA.CreateAmortFloatLeg(
                MyCreateAmortFloatLeg2,
                Reload,
                PayRec,
                Gearing,
                MyCreateAmortObj,
                Ccy,
                BusDayConv,
                DayCount,
                MyNewIndex2,
                CreateAmortFloatLeg__2_Margin,
                ExchangePrincipal,
                MyMarket4,
                SMPFWDRho);


    return rCreateAmortFloatLeg__2;
}        



// ///////////////////////////////////////////////////////////////////

private string CreateFixedRateLeg__3Part(
    string MySchedule,
    string MyMarket4)
{

        //  Create example range for parameter CreateFixedRateLeg__3_Notional
        CTQL.CTRangeData CreateFixedRateLeg__3_Notional;    
        

        int[] arrBCreateFixedRateLeg__3_Notional = { 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000, 
            5000000  //  Array Data
        
        };
        
        CTQL.IntVector arrCreateFixedRateLeg__3_Notional = 
            new  CTQL.IntVector(arrBCreateFixedRateLeg__3_Notional);
    
        // Second parameter determines whether the array is a column array (false) or a row array (true)
        CreateFixedRateLeg__3_Notional = new  CTQL.CTRangeData(arrCreateFixedRateLeg__3_Notional, false);
            
        //  Create example range for parameter CreateFixedRateLeg__3_PrincipalPayments
        CTQL.CTRangeData CreateFixedRateLeg__3_PrincipalPayments;    
        

        int[] arrBCreateFixedRateLeg__3_PrincipalPayments = { 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0, 
            0  //  Array Data
        
        };
        
        CTQL.IntVector arrCreateFixedRateLeg__3_PrincipalPayments = 
            new  CTQL.IntVector(arrBCreateFixedRateLeg__3_PrincipalPayments);
    
        // Second parameter determines whether the array is a column array (false) or a row array (true)
        CreateFixedRateLeg__3_PrincipalPayments = new  CTQL.CTRangeData(arrCreateFixedRateLeg__3_PrincipalPayments, false);
            
        //  Create example range for parameter CreateFixedRateLeg__3_Coupon
        CTQL.CTRangeData CreateFixedRateLeg__3_Coupon;    
        

        double[] arrBCreateFixedRateLeg__3_Coupon = { 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05, 
            0.05  //  Array Data
        
        };
        
        CTQL.DoubleVector arrCreateFixedRateLeg__3_Coupon = 
            new  CTQL.DoubleVector(arrBCreateFixedRateLeg__3_Coupon);
    
        // Second parameter determines whether the array is a column array (false) or a row array (true)
        CreateFixedRateLeg__3_Coupon = new  CTQL.CTRangeData(arrCreateFixedRateLeg__3_Coupon, false);
            


    //    Key value to use as a handle for the created object
        string MyCreateFixedRateLeg3 = "MyCreateFixedRateLeg3" + "_" + System.Convert.ToString(nCTIRRiskGlobal);

    //    When creating this object for the first time, set this parameter 
    //    to a positive value.
        int Reload = 1;

    //    Whether you would like to PAY or REC this leg.
        CTIEnums.PAYRECEnum PayRec = CTIEnums.PAYRECEnum.PAYREC_PAY;

    //