LMMNextPath Example VBNET

VB.NET Example - LMMNextPath![]() ![]() ![]() ![]() ![]() ' ################################################################################## ' The first function here LMMNextPath(), contains a series of ' function calls leading upto the main function call, the second function ' within this file ( LMMNextPathPart() ). ' 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. ' ################################################################################## ![]() Imports 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.![]() Imports 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. Global nCTLMMProcessSimGlobal As Integer ' 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 Global oEmptyRange As CTQL.CTRangeData Public Function VB_EX_LMMNextPath() As CTRangeData![]() nCTLMMProcessSimGlobal = nCTLMMProcessSimGlobal + 1 ![]() Dim szErrorMsg As String Try![]() ![]() ' UK date calendar used within the UK stock exchange.![]() Dim MyCALUKExchange As String MyCALUKExchange = _ CALUKExchangePart()![]() ![]() ![]() ' EURO calendar used for holiday adjustments.![]() Dim MyEuroCal As String MyEuroCal = _ CALEUROPart()![]() ![]() ![]() ' Creates a centralized valuation date object.![]() Dim MyValuationDate As String MyValuationDate = _ ValueDateObjPart()![]() ![]() ![]() ' Creates a Deposit template which is almost identical to a Libor ' Index, but without the YieldCurve information. Dim MyDepoTPL As String 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. Dim MySwapTPL As String MySwapTPL = _ CreateSwapTemplatePart( _ MyEuroCal, _ MyDepoTPL)![]() ![]() ![]() ' Creates a yield curve using market rates (No cross-currency ' Swaps). Dim MyMiniYC As String MyMiniYC = _ MKTYC_D__3Part( _ MyValuationDate, _ MyDepoTPL, _ MySwapTPL)![]() ![]() ![]() ' Creates a new Index code. Dim MyNewIndex2 As String MyNewIndex2 = _ CreateIndex__2Part( _ MyCALUKExchange, _ MyEuroCal, _ MyMiniYC)![]() ![]() ![]() ' Creates a Libor Forward Model Process container object. Dim MyLMMProcess2 As String MyLMMProcess2 = _ LMMProcess2Part( _ MyNewIndex2)![]() ![]() ![]() ' Creates a an extended linear-exponential volatility model for ' the libor market model. Dim My3rdLMMLinearExpVolModel2 As String My3rdLMMLinearExpVolModel2 = _ LMMLinearExpVolModel2__3Part( _ MyLMMProcess2)![]() ![]() ![]() ' Creates an extended exponential correlation model for the libor ' market model. Dim My2ndLMMLinearExpCorrModel2 As String My2ndLMMLinearExpCorrModel2 = _ LMMLinearExpCorrModel2__2Part( _ MyLMMProcess2)![]() ![]() ![]() ' Given volatility and correlation specification objects, creates ' a Libor Forward Market Simulation Process object to be used ' within the 'CapeTools LMM Process Simulation' or 'CapeTools ' Generic IR LMM MonteCarlo Pricer' category of functions. Dim MyLMMSimProcess As String MyLMMSimProcess = _ LMMSimProcessPart( _ MyLMMProcess2, _ My3rdLMMLinearExpVolModel2, _ My2ndLMMLinearExpCorrModel2)![]() ![]() ![]() ' Generates a new random path based on the LMM model. Dim resLMMNextPath As CTRangeData resLMMNextPath = _ LMMNextPathPart( _ MyLMMSimProcess)![]() ' This is the result we are looking for. VB_EX_LMMNextPath = resLMMNextPath![]() Catch e As Exception szErrorMsg = e.Message Throw e Catch e As System.ApplicationException szData = e.Message End Try End Function ![]() ![]() ' ///////////////////////////////////////////////////////////////////![]() Private Function LMMNextPathPart( _ MyLMMSimProcess As String) As CTRangeData![]() ' Used by functions returning a range value. Via the szRangeDescription variable, you can inspect the results Dim _nRows As Integer Dim _nCols As Integer Dim szRangeDescription As String![]() ![]() ![]() ' Excel function call is : "CT.PRO.LMMNextPath()"![]() ' Generates a new random path based on the LMM model. Dim rLMMNextPath As CTRangeData Dim oCTLMMProcessSim As New CTQL.CTLMMProcessSim rLMMNextPath = CType(CTQL.CTLMMProcessSimSA.LMMNextPath( _ MyLMMSimProcess), CTRangeData)![]() ![]() _nRows = rLMMNextPath.GetRows() _nCols = rLMMNextPath.GetCols() szRangeDescription = rLMMNextPath.ToMatrixString()![]() ![]() LMMNextPathPart = rLMMNextPath End Function ![]() ![]() ![]() ![]() |