RiskGetYCVCSenLegs Example CS

C# Example - RiskGetYCVCSenLegs![]() ![]() ![]() ![]() ![]() // ################################################################################## // The first function here RiskGetYCVCSenLegs(), contains a series of // function calls leading upto the main function call, the second function // within this file ( RiskGetYCVCSenLegsPart() ). // 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 nCTQryIRRiskGlobal; // 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 CTRangeData CS_EX_RiskGetYCVCSenLegs() { nCTQryIRRiskGlobal += 1; string szErrorMsg = "";![]() try {![]() ![]() // 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 yield curve using market rates (No cross-currency // Swaps). string MyMiniYC; MyMiniYC = MKTYC_D__3Part( MyValuationDate, MyDepoTPL, MySwapTPL); ![]() ![]() // 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 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); ![]() ![]() // Given a Structure object key, Returns a list of Legs within // the structure that are sensitive to the indicated YieldCurve // and VolCurve. CTRangeData resRiskGetYCVCSenLegs; resRiskGetYCVCSenLegs = RiskGetYCVCSenLegsPart( MyStructure, MyMiniYC, MySABRVolCurve); // This is the result we are looking for. return resRiskGetYCVCSenLegs; ![]() } catch(Exception e) { szErrorMsg = e.Message; throw e; } } ![]() ![]() // ///////////////////////////////////////////////////////////////////![]() private CTRangeData RiskGetYCVCSenLegsPart( string MyStructure, string MyMiniYC, string MySABRVolCurve) { // Used by functions returning a range value. Via the szRangeDescription variable, you can inspect the results int _nRows, _nCols; string szRangeDescription;![]() ![]() ![]() // Excel function call would be this - "CT.RSK.RiskGetYCVCSenLegs()"![]() // Given a Structure object key, Returns a list of Legs within // the structure that are sensitive to the indicated YieldCurve // and VolCurve. CTRangeData rRiskGetYCVCSenLegs; rRiskGetYCVCSenLegs = (CTRangeData)CTQL.CTQryIRRiskSA.RiskGetYCVCSenLegs( MyStructure, MyMiniYC, MySABRVolCurve);![]() _nRows = rRiskGetYCVCSenLegs.GetRows(); _nCols = rRiskGetYCVCSenLegs.GetCols(); szRangeDescription = rRiskGetYCVCSenLegs.ToMatrixString();![]() ![]() ![]() return rRiskGetYCVCSenLegs; } ![]() ![]() ![]() // ///////////////////////////////////////////////////////////////////![]() 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(nCTQryIRRiskGlobal);![]() // 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 MKTYC_D__3Part( string MyValuationDate, string MyDepoTPL, string MySwapTPL) {![]() // Create example range for parameter MKTYC_D__3_oTenorsRates CTQL.CTRangeData MKTYC_D__3_oTenorsRates = new CTQL.CTRangeData(); System.Text.StringBuilder MKTYC_D__3_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_D__3_oTenorsRates_builder.Append("{"); MKTYC_D__3_oTenorsRates_builder.Append("'7D' | 3.48 | True ;"); MKTYC_D__3_oTenorsRates_builder.Append("'14D' | 3.49 | True ;"); MKTYC_D__3_oTenorsRates_builder.Append("'1M' | 3.5 | True ;"); MKTYC_D__3_oTenorsRates_builder.Append("'3M' | 3.7 | True ;"); MKTYC_D__3_oTenorsRates_builder.Append("'6M' | 3.9 | True"); MKTYC_D__3_oTenorsRates_builder.Append("}"); MKTYC_D__3_oTenorsRates.RangeFromStr ( MKTYC_D__3_oTenorsRates_builder.ToString() ); // Create example range for parameter MKTYC_D__3_oRange2 CTQL.CTRangeData MKTYC_D__3_oRange2 = new CTQL.CTRangeData(); System.Text.StringBuilder MKTYC_D__3_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_D__3_oRange2_builder.Append("{"); MKTYC_D__3_oRange2_builder.Append("'9M' | 4.1 | True ;"); MKTYC_D__3_oRange2_builder.Append("'12M' | 4.3 | True"); MKTYC_D__3_oRange2_builder.Append("}"); MKTYC_D__3_oRange2.RangeFromStr ( MKTYC_D__3_oRange2_builder.ToString() ); // Create example range for parameter MKTYC_D__3_oRange3 CTQL.CTRangeData MKTYC_D__3_oRange3 = new CTQL.CTRangeData(); System.Text.StringBuilder MKTYC_D__3_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_D__3_oRange3_builder.Append("{"); MKTYC_D__3_oRange3_builder.Append("'2Y' | 4.5 | True ;"); MKTYC_D__3_oRange3_builder.Append("'5Y' | 4.7 | True ;"); MKTYC_D__3_oRange3_builder.Append("'10Y' | 4.9 | True"); MKTYC_D__3_oRange3_builder.Append("}"); MKTYC_D__3_oRange3.RangeFromStr ( MKTYC_D__3_oRange3_builder.ToString() ); // Create example range for parameter MKTYC_D__3_oRange4 CTQL.CTRangeData MKTYC_D__3_oRange4 = new CTQL.CTRangeData(); System.Text.StringBuilder MKTYC_D__3_oRange4_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_D__3_oRange4_builder.Append("{"); MKTYC_D__3_oRange4_builder.Append("'15Y' | 5.3 | True ;"); MKTYC_D__3_oRange4_builder.Append("'20Y' | 5.4 | True ;"); MKTYC_D__3_oRange4_builder.Append("'25Y' | 5.5 | True ;"); MKTYC_D__3_oRange4_builder.Append("'30Y' | 5.6 | True ;"); MKTYC_D__3_oRange4_builder.Append("'35Y' | 5.7 | True ;"); MKTYC_D__3_oRange4_builder.Append("'40Y' | 5.8 | True"); MKTYC_D__3_oRange4_builder.Append("}"); MKTYC_D__3_oRange4.RangeFromStr ( MKTYC_D__3_oRange4_builder.ToString() ); ![]() ![]() // Key value to use as a handle for the created object string MyMiniYC = "MyMiniYC" + "_" + System.Convert.ToString(nCTQryIRRiskGlobal);![]() // 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 = "MyMiniYC";![]() // Interpolation methodology to utilise when interpolating for // discount factors. CTIEnums.InterpEnum InterpMethod = CTIEnums.InterpEnum.Interp_LOGLINEAR;![]() // An optional flat spread value that will be added to all tenors. 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_D()"![]() // Creates a yield curve using market rates (No cross-currency // Swaps). string rMKTYC_D__3; rMKTYC_D__3 = CTQL.CTCurvesSA.MKTYC_D( MyMiniYC, Reload, CurveName, MyValuationDate, MKTYC_D__3_oTenorsRates, MKTYC_D__3_oRange2, MKTYC_D__3_oRange3, MKTYC_D__3_oRange4, InterpMethod, Spread, DayCount, DepoOvrWrtFuts, FutsOvrWrtSwps, MyDepoTPL, MySwapTPL, Extrapolate);![]() ![]() return rMKTYC_D__3; } ![]() ![]() ![]() // ///////////////////////////////////////////////////////////////////![]() 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(nCTQryIRRiskGlobal);![]() // 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 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(nCTQryIRRiskGlobal);![]() // 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
|