SwaptionPortfolio Example CS

High level view of the code structure (resulting in the final function call to SwaptionPortfolio() )
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 | |