BasisSwapPortfolio Example CPPNET

C++.NET Example - BasisSwapPortfolio![]() ![]() ![]() ![]() ![]() // ################################################################################## // The first function here BasisSwapPortfolio(), contains a series of // function calls leading upto the main function call, the second function // within this file ( BasisSwapPortfolioPart() ). // 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 <mscorlib.dll>![]() ![]() // If you add a reference via the Visual Studio project, // then the following line is not needed. #using <QuantToolsNET.v2.dll> ![]() using namespace System;![]() // 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 nCTBSWPortfolioGlobal = 0; // 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* CPPNET_EX_BasisSwapPortfolio() { nCTBSWPortfolioGlobal += 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 basis swap portfolio (same currency) object.![]() String* MyBasisSwapPortfolio; MyBasisSwapPortfolio = BasisSwapPortfolioPart( MyGroupedIndex, MyYC_XCCY_DCF, MySABRVolCurve); // This is the result we are looking for. return MyBasisSwapPortfolio; ![]() } catch(Exception e) { szErrorMsg = e.Message; throw e; } } ![]() ![]() // ///////////////////////////////////////////////////////////////////![]() private: String* BasisSwapPortfolioPart( String* MyGroupedIndex, String* MyYC_XCCY_DCF, String* MySABRVolCurve) {![]() // Create example range for parameter BasisSwapPortfolio_SwapRange CTQL::CTRangeData* BasisSwapPortfolio_SwapRange = new CTQL::CTRangeData();![]() System::Text::StringBuilder* BasisSwapPortfolio_SwapRange_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. BasisSwapPortfolio_SwapRange_builder->Append(S"{"); BasisSwapPortfolio_SwapRange_builder->Append(S"SwapName | PayRec | StartDate | EndDate | Notional | PrincipalExchange | IndexCode1 | InArrears1 | Margin1 | CMSRho1 | IndexCode2 | InArrears2 | Margin2 | CMSRho2 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW-123456 | reciever | #21/Jul/2011# | #21/Jul/2016# | 50000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR1M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2012 - EURLIBOR1M | reciever | #21/Jul/2012# | #21/Jul/2017# | 50000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR1M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2013 - EURLIBOR1M | reciever | #21/Jul/2013# | #21/Jul/2018# | 50000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR1M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2014 - EURLIBOR1M | reciever | #21/Jul/2014# | #21/Jul/2019# | 50000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR1M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2015 - EURLIBOR6M | reciever | #21/Jul/2015# | #21/Jul/2020# | 50000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR6M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2016 - EURLIBOR6M | payer | #21/Jul/2016# | #21/Jul/2021# | 10000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR6M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2017 - EURLIBOR6M | payer | #21/Jul/2017# | #21/Jul/2022# | 10000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR6M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2018 - EURLIBOR12M | payer | #21/Jul/2018# | #21/Jul/2023# | 10000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR12M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2019 - EURLIBOR12M | payer | #21/Jul/2019# | #21/Jul/2024# | 10000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR12M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2020 - EURLIBOR12M | payer | #21/Jul/2020# | #21/Jul/2025# | 10000000 | False | EURLIBOR3M | False | 0.0002 | 0 | EURLIBOR12M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2021 - EURLIBOR12M | payer | #21/Jul/2021# | #21/Jul/2026# | 10000000 | False | EURLIBOR3M | True | 0.0002 | 0 | EURLIBOR12M | False | 0.0002 | 0 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2022 - EURCMS5Y | payer | #21/Jul/2022# | #21/Jul/2027# | 10000000 | False | EURLIBOR3M | True | 0.0002 | 0 | EURCMS5Y | False | 0.0002 | 0.8 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2023 - EURCMS5Y | payer | #21/Jul/2023# | #21/Jul/2028# | 10000000 | False | EURLIBOR3M | True | 0.0002 | 0 | EURCMS5Y | False | 0.0002 | 0.8 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2024 - EURCMS10Y | payer | #21/Jul/2024# | #21/Jul/2029# | 10000000 | False | EURLIBOR3M | True | 0.0002 | 0 | EURCMS10Y | False | 0.0002 | 0.8 ;"); BasisSwapPortfolio_SwapRange_builder->Append(S"BSW : 21-Jul-2025 - EURCMS10Y | payer | #21/Jul/2025# | #21/Jul/2030# | 10000000 | False | EURLIBOR3M | True | 0.0002 | 0 | EURCMS10Y | False | 0.0002 | 0.8"); BasisSwapPortfolio_SwapRange_builder->Append(S"}"); BasisSwapPortfolio_SwapRange->RangeFromStr ( BasisSwapPortfolio_SwapRange_builder->ToString() );![]() ![]() ![]() // Key Handle to be used for the new Portfolio object. String* MyBasisSwapPortfolio = String::Format(S"{0}_{1}", S"MyBasisSwapPortfolio", System::Convert::ToString(nCTBSWPortfolioGlobal));![]() ![]() // 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.BasisSwapPortfolio()"![]() // Creates a basis swap portfolio (same currency) object. String* rBasisSwapPortfolio; rBasisSwapPortfolio = CTQL::CTBSWPortfolioSA->BasisSwapPortfolio( MyBasisSwapPortfolio, Reload, MyGroupedIndex, MyYC_XCCY_DCF, MySABRVolCurve, BasisSwapPortfolio_SwapRange);![]() ![]() return rBasisSwapPortfolio; } ![]() ![]() ![]() ![]() |