CreateVegaReport Example CS

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;![]() // |