SwaptionPortfolio Example CS





http://www.QuantTools.com
CapeTools Swaption Portfolio function list
SwaptionPortfolio 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 SwaptionPortfolio() )

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 - SwaptionPortfolio





    //     ##################################################################################
    //     The first function here SwaptionPortfolio(), contains a series of
    //     function calls leading upto the main function call, the second function
    //     within this file ( SwaptionPortfolioPart() ).
    //     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 nCTOSPortfolioGlobal;
    
// 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_SwaptionPortfolio()
{
    nCTOSPortfolioGlobal += 1;
            
    string szErrorMsg = "";

    try
    {


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

    string MyCALUKExchange;
    MyCALUKExchange = 
        CALUKExchangePart();
    
    


    //    EURO calendar used for holiday adjustments.
    

    string MyEuroCal;
    MyEuroCal = 
        CALEUROPart();
    
    


    //    Creates a centralized valuation date object.
    

    string MyValuationDate;
    MyValuationDate = 
        ValueDateObjPart();
    
    


    //    UK date calendar.
    

    string MyCALUKSettlement;
    MyCALUKSettlement = 
        CALUKSettlementPart();
    
    


    //    TARGET calendar used for holiday adjustments.
    

    string MyTargetCal2;
    MyTargetCal2 = 
        CALTARGET__2Part();
    
    


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


    //    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 MyGBPSwapTPL;
    MyGBPSwapTPL = 
        CreateSwapTemplate__4Part(
        MyCALUKSettlement,
        MyGBPDepoTPL);
    
    


    //    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 yield curve using market rates and cross currency 
    //    swaps (against the dollar).
    
    string MyYC_XCCY_DCF;
    MyYC_XCCY_DCF = 
        MKTYC_XCCY_DPart(
        MyValuationDate,
        MyDepoTPL,
        MySwapTPL);
    
    


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


    //    Creates a new Index code.
    
    string My1MIndex;
    My1MIndex = 
        CreateIndex__5Part(
        MyCALUKExchange,
        MyEuroCal,
        MyYC_XCCY_DCF);
    
    


    //    Creates a new Index code.
    
    string My2MIndex;
    My2MIndex = 
        CreateIndex__6Part(
        MyCALUKExchange,
        MyEuroCal,
        MyYC_XCCY_DCF);
    
    


    //    Creates a new Index code.
    
    string My3MIndex;
    My3MIndex = 
        CreateIndex__7Part(
        MyCALUKExchange,
        MyEuroCal,
        MyYC_XCCY_DCF);
    
    


    //    Creates a new Index code.
    
    string My6MIndex;
    My6MIndex = 
        CreateIndex__8Part(
        MyCALUKExchange,
        MyEuroCal,
        MyYC_XCCY_DCF);
    
    


    //    Creates a new Index code.
    
    string My12MIndex;
    My12MIndex = 
        CreateIndex__9Part(
        MyCALUKExchange,
        MyEuroCal,
        MyYC_XCCY_DCF);
    
    


    //    Creates a new Index based on SWAP details.
    
    string MyCMS5Y;
    MyCMS5Y = 
        CreateSwapIndex__2Part(
        MyTargetCal2,
        My3MIndex);
    
    


    //    Creates a new Index based on SWAP details.
    
    string MyCMS10Y;
    MyCMS10Y = 
        CreateSwapIndex__3Part(
        MyTargetCal2,
        My3MIndex);
    
    


    //    Creates a yield curve using market rates (No cross-currency 
    //    Swaps).
    
    string MyGBPYC;
    MyGBPYC = 
        MKTYC_D__4Part(
        MyValuationDate,
        MyGBPDepoTPL,
        MyGBPSwapTPL);
    
    


    //    GBPLibor, Pound Sterling LIBOR fixed by BBA.
    
    string MyGBPIndex;
    MyGBPIndex = 
        IDXGBPLiborPart(
        MyGBPYC);
    
    


    //    Creates a container to hold a group of Index objects.
    
    string MyGroupedIndex;
    MyGroupedIndex = 
        GroupedIndexPart(
        My1MIndex,
        My2MIndex,
        My3MIndex,
        My6MIndex,
        My12MIndex,
        MyGBPIndex,
        MyCMS5Y,
        MyCMS10Y);
    
    


    //    Creates a Swaption portfolio object.
    
    string MySwaptionPortfolio;
    MySwaptionPortfolio = 
        SwaptionPortfolioPart(
        MyGroupedIndex,
        MyYC_XCCY_DCF,
        MySABRVolCurve);
    
    // This is the result we are looking for.
    return MySwaptionPortfolio;
    

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


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

private string SwaptionPortfolioPart(
    string MyGroupedIndex,
    string MyYC_XCCY_DCF,
    string MySABRVolCurve)
{

        //  Create example range for parameter SwaptionPortfolio_SwaptionRange
        CTQL.CTRangeData SwaptionPortfolio_SwaptionRange = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder SwaptionPortfolio_SwaptionRange_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.
        SwaptionPortfolio_SwaptionRange_builder.Append("{");
        SwaptionPortfolio_SwaptionRange_builder.Append("SwaptionName     | Position     | PayRec     | ExerciseDate     | StartDate     | EndDate     | Notional     | Coupon     | FixBDC     | FixDayCount     | FixFreq     | IndexCode     | Margin ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS-123456     | short     | reciever     | #19/Jul/2011#     | #21/Jul/2011#     | #21/Jul/2016#     | 50000000     | 5.17     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR3M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2012 / 5.31%     | short     | reciever     | #19/Jul/2012#     | #21/Jul/2012#     | #21/Jul/2017#     | 50000000     | 5.31     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR1M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2013 / 5.47%     | short     | reciever     | #19/Jul/2013#     | #21/Jul/2013#     | #21/Jul/2018#     | 50000000     | 5.47     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR1M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2014 / 5.59%     | short     | reciever     | #19/Jul/2014#     | #21/Jul/2014#     | #21/Jul/2019#     | 50000000     | 5.59     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR6M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2015 / 5.74%     | short     | reciever     | #19/Jul/2015#     | #21/Jul/2015#     | #21/Jul/2020#     | 50000000     | 5.74     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR6M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2016 / 5.92%     | long     | payer     | #19/Jul/2016#     | #21/Jul/2016#     | #21/Jul/2021#     | 10000000     | 5.92     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR12M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2017 / 6.06%     | long     | payer     | #19/Jul/2017#     | #21/Jul/2017#     | #21/Jul/2022#     | 10000000     | 6.06     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR12M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2018 / 6.23%     | long     | payer     | #19/Jul/2018#     | #21/Jul/2018#     | #21/Jul/2023#     | 10000000     | 6.23     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR3M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2019 / 6.38%     | long     | payer     | #19/Jul/2019#     | #21/Jul/2019#     | #21/Jul/2024#     | 10000000     | 6.38     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR3M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2020 / 6.51%     | long     | payer     | #19/Jul/2020#     | #21/Jul/2020#     | #21/Jul/2025#     | 10000000     | 6.51     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR6M     | 0.0002 ;");
        SwaptionPortfolio_SwaptionRange_builder.Append("OS : 19-Jul-2021 / 6.69%     | long     | payer     | #19/Jul/2021#     | #21/Jul/2021#     | #21/Jul/2026#     | 10000000     | 6.69     | Modifiedfollowing     | ACT365F     | S     | EURLIBOR6M     | 0.0002");
        SwaptionPortfolio_SwaptionRange_builder.Append("}");
        
        SwaptionPortfolio_SwaptionRange.RangeFromStr
        (
            SwaptionPortfolio_SwaptionRange_builder.ToString()
        );
                     


    //    Key Handle to be used for the new Portfolio object.
        string MySwaptionPortfolio = "MySwaptionPortfolio" + "_" + System.Convert.ToString(nCTOSPortfolioGlobal);

    //    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.BOOK.SwaptionPortfolio()"

    //    Creates a Swaption portfolio object.
        string rSwaptionPortfolio;
                                        
        rSwaptionPortfolio = CTQL.CTOSPortfolioSA.SwaptionPortfolio(
                MySwaptionPortfolio,
                Reload,
                MyGroupedIndex,
                MyYC_XCCY_DCF,
                MySABRVolCurve,
                SwaptionPortfolio_SwaptionRange);


    return rSwaptionPortfolio;
}        



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

private string GroupedIndexPart(
    string My1MIndex,
    string My2MIndex,
    string My3MIndex,
    string My6MIndex,
    string My12MIndex,
    string MyGBPIndex,
    string MyCMS5Y,
    string MyCMS10Y)
{

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

        string[] arrBGroupedIndex_Indexes = { 
            My1MIndex, 
            My2MIndex, 
            My3MIndex, 
            My6MIndex, 
            My12MIndex, 
            MyGBPIndex, 
            MyCMS5Y, 
            MyCMS10Y  //  Array Data
        
        };
        
        CTQL.StringVector arrGroupedIndex_Indexes = 
            new  CTQL.StringVector(arrBGroupedIndex_Indexes);
    
        // Second parameter determines whether the array is a column array (false) or a row array (true)
        GroupedIndex_Indexes = new  CTQL.CTRangeData(arrGroupedIndex_Indexes, false);
            


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

    //    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.IDX.GroupedIndex()"

    //    Creates a container to hold a group of Index objects.
        string rGroupedIndex;
                                        
        rGroupedIndex = CTQL.CTIndexesSA.GroupedIndex(
                MyGroupedIndex,
                Reload,
                GroupedIndex_Indexes);


    return rGroupedIndex;
}        



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

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

        //  Create example range for parameter MKTYC_XCCY_D_oTenorsRates
        CTQL.CTRangeData MKTYC_XCCY_D_oTenorsRates = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder MKTYC_XCCY_D_oTenorsRates_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.
        MKTYC_XCCY_D_oTenorsRates_builder.Append("{");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'7D'     | 3.5     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'14D'     | 3.51     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'1M'     | 3.53     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'2M'     | 3.55     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'3M'     | 3.57     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'4M'     | 3.59     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'5M'     | 3.62     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'6M'     | 3.63     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'7M'     | 3.66     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'8M'     | 3.68     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'9M'     | 3.71     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'10M'     | 3.73     | True ;");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("'11M'     | 3.75     | True");
        MKTYC_XCCY_D_oTenorsRates_builder.Append("}");
        
        MKTYC_XCCY_D_oTenorsRates.RangeFromStr
        (
            MKTYC_XCCY_D_oTenorsRates_builder.ToString()
        );
                     
        //  Create example range for parameter MKTYC_XCCY_D_oRange2
        CTQL.CTRangeData MKTYC_XCCY_D_oRange2 = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder MKTYC_XCCY_D_oRange2_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.
        MKTYC_XCCY_D_oRange2_builder.Append("{");
        MKTYC_XCCY_D_oRange2_builder.Append("'1Y'     | 3.75     | True ;");
        MKTYC_XCCY_D_oRange2_builder.Append("'2Y'     | 3.8     | True ;");
        MKTYC_XCCY_D_oRange2_builder.Append("'5Y'     | 3.85     | True ;");
        MKTYC_XCCY_D_oRange2_builder.Append("'10Y'     | 3.9     | True ;");
        MKTYC_XCCY_D_oRange2_builder.Append("'15Y'     | 4.15     | True");
        MKTYC_XCCY_D_oRange2_builder.Append("}");
        
        MKTYC_XCCY_D_oRange2.RangeFromStr
        (
            MKTYC_XCCY_D_oRange2_builder.ToString()
        );
                     
        //  Create example range for parameter MKTYC_XCCY_D_oRange3
        CTQL.CTRangeData MKTYC_XCCY_D_oRange3 = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder MKTYC_XCCY_D_oRange3_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.
        MKTYC_XCCY_D_oRange3_builder.Append("{");
        MKTYC_XCCY_D_oRange3_builder.Append("'25Y'     | 4.3     | True ;");
        MKTYC_XCCY_D_oRange3_builder.Append("'30Y'     | 4.45     | True ;");
        MKTYC_XCCY_D_oRange3_builder.Append("'35Y'     | 4.6     | True ;");
        MKTYC_XCCY_D_oRange3_builder.Append("'40Y'     | 4.9     | True");
        MKTYC_XCCY_D_oRange3_builder.Append("}");
        
        MKTYC_XCCY_D_oRange3.RangeFromStr
        (
            MKTYC_XCCY_D_oRange3_builder.ToString()
        );
                     
        //  Create example range for parameter MKTYC_XCCY_D_XCCYSwaps
        CTQL.CTRangeData MKTYC_XCCY_D_XCCYSwaps = 
            new CTQL.CTRangeData();
             
        System.Text.StringBuilder MKTYC_XCCY_D_XCCYSwaps_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.
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("{");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'1Y'     | -3.5     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'2Y'     | -3     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'3Y'     | -3.25     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'4Y'     | -3.25     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'5Y'     | -3.25     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'7Y'     | -3.25     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'10Y'     | -3.25     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'15Y'     | -3     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'20Y'     | -2.75     | True ;");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("'30Y'     | -2.75     | True");
        MKTYC_XCCY_D_XCCYSwaps_builder.Append("}");
        
        MKTYC_XCCY_D_XCCYSwaps.RangeFromStr
        (
            MKTYC_XCCY_D_XCCYSwaps_builder.ToString()
        );
                     


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

    //    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 Yieldcurve collection ( via the GroupedCurves() function 
    //    ).
        string CurveName = "MyYC_XCCY_DCF";

    //    Interpolation methodology to utilise when interpolating for 
    //    discount factors.
        CTIEnums.InterpEnum InterpMethod = CTIEnums.InterpEnum.Interp_LOGLINEAR;

    //    Interpolation methodology to utilise when interpolating the 
    //    forward spread curve (generated from the cross-currency basis 
    //    swaps).
        CTIEnums.InterpEnum SpreadInterp = CTIEnums.InterpEnum.Interp_FORWARDSTEP;

    //    An optional flat spread value that will be added to all tenors 
    //    (not the cross-currency swaps)).
        double Spread = 0.000;

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

    //    If a cash (deposit) tenor's end date is after the earliest futures 
    //    expiry date within the curve, do we discard the cash tenor (false) 
    //    or keep it (true).
        bool DepoOvrWrtFuts = false;

    //    If a futures tenor's end date is after the earliest swap tenor's 
    //    end date within the curve, do we discard the futures tenor (false) 
    //    or keep it (true).
        bool FutsOvrWrtSwps = true;

    //    Whether the yieldCurve data should be extrapolated if a calculation 
    //    request that uses a date that is beyond the end date of the 
    //    yieldCurve (ie - a request for a 40 year discount factor, but 
    //    the curve is only built up to 30 years.) If false an error will 
    //    be returned.
        bool Extrapolate = true;

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

    //    Creates a yield curve using market rates and cross currency 
    //    swaps (against the dollar).
        string rMKTYC_XCCY_D;
                                        
        rMKTYC_XCCY_D = CTQL.CTXCCYCurvesSA.MKTYC_XCCY_D(
                MyYC_XCCY_DCF,
                Reload,
                CurveName,
                MyValuationDate,
                MKTYC_XCCY_D_oTenorsRates,
                MKTYC_XCCY_D_oRange2,
                MKTYC_XCCY_D_oRange3,
                MKTYC_XCCY_D_XCCYSwaps,
                InterpMethod,
                SpreadInterp,
                Spread,
                DayCount,
                DepoOvrWrtFuts,
                FutsOvrWrtSwps,
                MyDepoTPL,
                MySwapTPL,
                Extrapolate);


    return rMKTYC_XCCY_D;
}        



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

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     |