#KACE Page Script ######Client see last entry ######## ####################################### Create The curves ####################################### # Cash curves for Cash arbitrage system CalcRef=CashCurve(Bid,USD,Deposits) CalcRef=CashCurve(Ask,USD,Deposits) CalcRef=CashCurve(Bid,USD,LiveOIS) CalcRef=CashCurve(Ask,USD,LiveOIS) CalcRef=CashCurve(Bid,MXN,Deposits) CalcRef=CashCurve(Ask,MXN,Deposits) CalcRef=CashCurve(Bid,MXN,LiveOIS) CalcRef=CashCurve(Ask,MXN,LiveOIS) # Standard medium term curve for all currencies CalcRef=DFC-SpreadOverBond(Bid,USD,1) CalcRef=DFC-SpreadOverBond(Ask,USD,1) CalcRef=DFC-SpreadOverBond(Last,USD,1) ## Copies curve config settings into the std structure for ref by Swaps and other calcs that ## have refs accross curve boundary (Parameters required - Currency,Curve name) #CalcRef=SOBCompatibilityCalc(USD,1,Bid) #CalcRef=SOBCompatibilityCalc(USD,1,Ask) #CalcRef=SOBCompatibilityCalc(USD,1,Last) CalcRef=Mid-DFC(USD) CalcRef=Mid-DFC2(USD) CalcRef=Mid-1YSwaps(USD) CalcRef=InFraLibors(USD) CalcRef=InSwapLibors(USD) CalcRef=InFraLibors(MXN) CalcRef=InSwapLibors(MXN) CalcRef=InForwards(Bid,MXN) CalcRef=InForwards(Ask,MXN) CalcRef=GenericLiveData() ### RC 09Aug05 Added the ability to bring in Basis and TIIE from a live source ### not required on Client... #CalcRef=InMxnTIIE(Bid,MXN) #CalcRef=InMxnTIIE(Ask,MXN) #CalcRef=InMxnBasis(Bid,MXN) #CalcRef=InMxnBasis(Ask,MXN) CalcRef=TIIEARB_UseLiveTIIEorBasis() CalcRef=TIIEARB_LongDatesUseSpreads() ###################### RC 07Oct04 Little extra calc to put ON/TN/SN etc into libors ### CalcRef=MXNAddShortDatesToLibor() ####################################### Money market calculations ####################################### # slot 1 = Fras # slot 2 = Swaps + IMM Fras # slot 3 = Synthetic Swaps # slot 4 = OIS # slot 5 = Swaps Modeller (AM curve) # slot 6 = FwdFwd Calculator (AM curve) # slot 7 = Swap Tearup (AM curve) # slot 8 = FFOIS # slot 9 = Swaps Hedge Calculator # Generate the forwards and their dates #CalcRef=InterpFwds(Bid,USD) #CalcRef=InterpFwds(Ask,USD) #CalcRef=InterpFwds(Bid,MXN) #CalcRef=InterpFwds(Ask,MXN) ### Interpolating TIIE-Implied Arbed FX Fwds, with Snapshot CalcRef=SnapshotTIIEImpdFwds(Bid) CalcRef=SnapshotTIIEImpdFwds(Ask) ### RC 23Feb05 ### Forwards calcs that will let you choose a forward source CalcRef=MXNFX-CopyChosenFwds(Bid,MXN) CalcRef=MXNFX-CopyChosenFwds(Ask,MXN) ### RC 23Feb05 ### Calcs for Weighting the Forwards CalcRef=MXNFX-CopyWeightedFwds(Weight1,Bid,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight2,Bid,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight3,Bid,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight4,Bid,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight1,Ask,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight2,Ask,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight3,Ask,MXN) CalcRef=MXNFX-CopyWeightedFwds(Weight4,Ask,MXN) #CalcRef=MXNFXDates(MXN,FxInput,Dates) #CalcRef=MXNFXDates(USD,FxInput,Dates) #### Server side?? # Basis swaps for the required currencies #CalcRef=InBasis(MXN,Bid) #CalcRef=InBasis(MXN,Ask) # Dummy calculations to add access to popup configuration pages CalcRef=CFG_Curve-Config() CalcRef=CFG_Turn-Premia() CalcRef=CFG_Live-Data() ################## RC Aug04 Use for creating the dates ###################### CalcRef=MXNChooseDatePairType(Start,1,1..36,MXNDetails) CalcRef=MXNChooseDatePairType(End,1,1..36,MXNDetails) CalcRef=MXNChooseDatePairType(Start,1,0..8,MXNBrokenDetails) CalcRef=MXNChooseDatePairType(End,1,0..8,MXNBrokenDetails) CalcRef=MXNChooseDatePairType-2(Start,1,1..4,BrokenTIIE) CalcRef=MXNChooseDatePairType-2(End,1,1..4,BrokenTIIE) ############### MG 05Aug04 >>>>>>>>>>> ###################### CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(Start,Bid,BS,InputBS,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(Start,Ask,BS,InputBS,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(End,Bid,BS,InputBS,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(End,Ask,BS,InputBS,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(Start,Bid,TIIE,InputTIIE,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(Start,Ask,TIIE,InputTIIE,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(End,Bid,TIIE,InputTIIE,MXN) CalcRef=TIIEARB_GenericIntrpTIIEDateGrid(End,Ask,TIIE,InputTIIE,MXN) CalcRef=TIIEARB_USDSwapFromDFC(Mid,1,UserDates) ############### <<<<<<<<<<< MG 05Aug04 ###################### CalcRef=TIIEARB_StdIntrp(Start,ArbCCY2DF-Bid,*,UserDates) CalcRef=TIIEARB_StdIntrp(Start,ArbCCY2DF-Ask,*,UserDates) CalcRef=TIIEARB_StdIntrp(Start,BPVCCY2-Bid,*,UserDates) CalcRef=TIIEARB_StdIntrp(Start,BPVCCY2-Ask,*,UserDates) CalcRef=TIIEARB_StdIntrp(Start,BPVCCY1,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,ArbCCY2DF-Bid,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,ArbCCY2DF-Ask,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,BPVCCY2-Bid,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,BPVCCY2-Ask,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,BPVCCY1,*,UserDates) ############### MG 05Aug04 ###################### CalcRef=TIIEARB_StdIntrp(Start,FwdPoints-Bid,*,UserDates) CalcRef=TIIEARB_StdIntrp(Start,FwdPoints-Ask,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,FwdPoints-Bid,*,UserDates) CalcRef=TIIEARB_StdIntrp(End,FwdPoints-Ask,*,UserDates) ########### Broken Dates Calculator (can increase) ########### CalcRef=TIIEARB_USDSwapFromDFC(Mid,1,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,ArbCCY2DF-Bid,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,ArbCCY2DF-Ask,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,BPVCCY2-Bid,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,BPVCCY2-Ask,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,BPVCCY1,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,ArbCCY2DF-Bid,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,ArbCCY2DF-Ask,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,BPVCCY2-Bid,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,BPVCCY2-Ask,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,BPVCCY1,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,FwdPoints-Bid,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(Start,FwdPoints-Ask,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,FwdPoints-Bid,*,BrokenTIIE) CalcRef=TIIEARB_StdIntrp(End,FwdPoints-Ask,*,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Bid,BS,InputBS,1,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Ask,BS,InputBS,1,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Bid,BS,InputBS,1,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Ask,BS,InputBS,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,InBSv1m,InBSv1m,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,InBSv1m,InBSv1m,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,InBSv1m,InBSv1m,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,InBSv1m,InBSv1m,1,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(Start,BasisNudge,BasisNudge,1,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(End,BasisNudge,BasisNudge,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,TIIE,InputTIIE,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,TIIE,InputTIIE,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,TIIE,InputTIIE,1,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,TIIE,InputTIIE,1,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Bid,BS,InputBS,2,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Ask,BS,InputBS,2,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Bid,BS,InputBS,2,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Ask,BS,InputBS,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,InBSv1m,InBSv1m,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,InBSv1m,InBSv1m,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,InBSv1m,InBSv1m,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,InBSv1m,InBSv1m,2,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(Start,BasisNudge,BasisNudge,2,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(End,BasisNudge,BasisNudge,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,TIIE,InputTIIE,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,TIIE,InputTIIE,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,TIIE,InputTIIE,2,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,TIIE,InputTIIE,2,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Bid,BS,InputBS,3,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Ask,BS,InputBS,3,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Bid,BS,InputBS,3,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Ask,BS,InputBS,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,InBSv1m,InBSv1m,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,InBSv1m,InBSv1m,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,InBSv1m,InBSv1m,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,InBSv1m,InBSv1m,3,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(Start,BasisNudge,BasisNudge,3,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(End,BasisNudge,BasisNudge,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,TIIE,InputTIIE,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,TIIE,InputTIIE,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,TIIE,InputTIIE,3,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,TIIE,InputTIIE,3,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Bid,BS,InputBS,4,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(Start,Ask,BS,InputBS,4,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Bid,BS,InputBS,4,MXN,BrokenTIIE) #CalcRef=TIIEARB_GenericIntrp(End,Ask,BS,InputBS,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,InBSv1m,InBSv1m,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,InBSv1m,InBSv1m,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,InBSv1m,InBSv1m,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,InBSv1m,InBSv1m,4,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(Start,BasisNudge,BasisNudge,4,MXN,BrokenTIIE) CalcRef=TIIEARB_OneSideGenericIntrp(End,BasisNudge,BasisNudge,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Bid,TIIE,InputTIIE,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(Start,Ask,TIIE,InputTIIE,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Bid,TIIE,InputTIIE,4,MXN,BrokenTIIE) CalcRef=TIIEARB_GenericIntrp(End,Ask,TIIE,InputTIIE,4,MXN,BrokenTIIE) CalcRef=TIIEARB_CalcTightFwdInputTIIE(BrokenTIIE) ############# RC 24Aug04 Generic Calcs ##################### CalcRef=TIIEARB_ImpliedFwdFwdPoints(Bid,UserDates) CalcRef=TIIEARB_ImpliedFwdFwdPoints(Ask,UserDates) CalcRef=TIIEARB_ImpliedFwdTIIE(Bid,UserDates) CalcRef=TIIEARB_ImpliedFwdTIIE(Ask,UserDates) CalcRef=TIIEARB_ImpliedFwdBS-Bid(UserDates) CalcRef=TIIEARB_ImpliedFwdBS-Ask(UserDates) CalcRef=TIIEARB_TIIEFromBasis_Bid(UserDates) CalcRef=TIIEARB_TIIEFromBasis_Ask(UserDates) ##### RC this is to replace TIIEARB_BasisFromTIIE_Ask() ###### CalcRef=TIIEARB_CalcFwdInputTIIE-Bid(UserDates) CalcRef=TIIEARB_CalcFwdInputTIIE-Ask(UserDates) ################ RC 23Aug04 - Choose between the type of FWD/Basis to display ######## CalcRef=TIIEARB_ChooseArbOrSpread(UserDates,Bid,1) CalcRef=TIIEARB_ChooseArbOrSpread(UserDates,Ask,1) ################ MG 23Aug04 - To provide the none arbed prices ################# CalcRef=TIIEARB_WIDE_ImpliedFwdBS(UserDates) CalcRef=TIIEARB_WIDE_ImpliedFwdFwdPoints(UserDates) ########### RC 24Aug04/MG 09Feb09 Broken Date Calcs for TIIE ################### CalcRef=TIIEARB_CalcFwdInputTIIE-Bid(BrokenTIIE) CalcRef=TIIEARB_CalcFwdInputTIIE-Ask(BrokenTIIE) CalcRef=TIIEARB_ImpliedFwdFwdPoints(Bid,BrokenTIIE) CalcRef=TIIEARB_ImpliedFwdFwdPoints(Ask,BrokenTIIE) CalcRef=TIIEARB_ImpliedFwdTIIE(Bid,BrokenTIIE) CalcRef=TIIEARB_ImpliedFwdTIIE(Ask,BrokenTIIE) CalcRef=TIIEARB_ImpliedFwdBS-Bid(BrokenTIIE) CalcRef=TIIEARB_ImpliedFwdBS-Ask(BrokenTIIE) CalcRef=BrokenTIIEARB_TIIEFromBasis_Bid(BrokenTIIE) CalcRef=BrokenTIIEARB_TIIEFromBasis_Ask(BrokenTIIE) CalcRef=TIIEARB_WIDE_ImpliedFwdBS(BrokenTIIE) CalcRef=TIIEARB_WIDE_ImpliedFwdFwdPoints(BrokenTIIE) CalcRef=TIIEARB_ChooseArbOrSpread(BrokenTIIE,Bid,1) CalcRef=TIIEARB_ChooseArbOrSpread(BrokenTIIE,Ask,1) CalcRef=BrokenTIIEArb_ImpBSv1m() CalcRef=TIIEARB_DayCount(BrokenTIIE,Start,End,1) ########## MG 04Nov04 - To calculate MXN DFC from Input TIIEs; and Fwd Start TIIEs from that ########## CalcRef=MXNMidAltFwdTIIE(FwdStartTIIE,1..4,1) ######### Because function fails if dates not in order ########## ######### Need set for each Broken Date ########## CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Input,1,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Copy,1,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Input,2,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Copy,2,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Input,3,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Copy,3,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Input,4,BrokenTIIE) CalcRef=TIIEARB_ConvertUSDSwapToDFSingle(Copy,4,BrokenTIIE) ############ Generic Calcs ######################## CalcRef=TIIEARB_ConvertUSDSwapToDFTIIEDateGrid(Input,UserDates) CalcRef=TIIEARB_ConvertUSDSwapToDFTIIEDateGrid(Copy,UserDates) ########## RC 12Aug04 MXN FX ########## CalcRef=MXN_MidSpot() CalcRef=InterpFwdsMXN(Bid,MXN) CalcRef=InterpFwdsMXN(Ask,MXN) #CalcRef=InterpFwdsMXN(Bid,1,USD,MXNDetails) #CalcRef=InterpFwdsMXN(Ask,1,USD,MXNDetails) #CalcRef=MXNCopySpotAndDatesFX(Bid,MXN) #CalcRef=MXNCopySpotAndDatesFX(Ask,MXN) #### Function is hard coded to need pips per day on ON TN and SN, the following change ## allows users to enter correct FX fwds and the "special" Divides ON , Tn and SN by days in that run ## prior to passing to the function ###CalcRef=CcyPairCrossesMXN(1..36,1,MXNDetails) #KACE Page Script CalcRef=CcyPairCrossesMXNSpecial(1..36,1,MXNDetails,Ask) CalcRef=CcyPairCrossesMXNSpecial(1..36,1,MXNDetails,Bid) ################ RC 22Jul04 Calc the US Swap Rates ################## #CalcRef=MXN_FxManualDays(MXN) CalcRef=MXNFXCalculateDays(MXNDetails,1..36,1) CalcRef=MXNCalcMidSwap(1,MXNDetails,1) ############ TIIE/Fwds Arb for FX Page only (no BS etc.) ################ CalcRef=MXNFXCalcImpliedMXN(MXNDetails,1,1..36) CalcRef=MXNFXConvertMXNToOrigForm(MXNDetails,1,Bid) CalcRef=MXNFXConvertMXNToOrigForm(MXNDetails,1,Ask) CalcRef=MXNFXCalcImpliedFwdFwdFX(MXNDetails,1,1..36) ############# RC 18Aug04 FX Broken Date Calculator - Allow for server/client creation. ########### CalcRef=MXNFXCalculateDays(MXNBrokenDetails,0..8,1) CalcRef=CcyPairBknCrossesMXN(0..8,1,MXNBrokenDetails) CalcRef=MXNCalcBrokenMidSwap(1,MXNBrokenDetails,1) CalcRef=MXNFXCalcImpliedMXN(MXNBrokenDetails,1,0..8) CalcRef=MXNFXConvertMXNToOrigForm(MXNBrokenDetails,1,Bid) CalcRef=MXNFXConvertMXNToOrigForm(MXNBrokenDetails,1,Ask) CalcRef=MXNFXCalcImpliedFwdFwdFX(MXNBrokenDetails,1,0..8) CalcRef=MXNFXImpliedFwdFwdDivisor(MXNBrokenDetails,1) ############### RC 08Jul04 This is used in creating the spread grid. ############# CalcRef=CopyMxnTIIEManualRates(1..19) CalcRef=CopyMxnTIIEImpliedRates(1..19) CalcRef=MXNBrokenMatrix(MXN) CalcRef=MxnTIIE-SpreadGrid(2..19,1,Manual) CalcRef=MxnTIIE-SpreadGrid(3..19,2,Manual) CalcRef=MxnTIIE-SpreadGrid(4..19,3,Manual) CalcRef=MxnTIIE-SpreadGrid(5..19,4,Manual) CalcRef=MxnTIIE-SpreadGrid(6..19,5,Manual) CalcRef=MxnTIIE-SpreadGrid(7..19,6,Manual) CalcRef=MxnTIIE-SpreadGrid(8..19,7,Manual) CalcRef=MxnTIIE-SpreadGrid(9..19,8,Manual) CalcRef=MxnTIIE-SpreadGrid(10..19,9,Manual) CalcRef=MxnTIIE-SpreadGrid(11..19,10,Manual) CalcRef=MxnTIIE-SpreadGrid(12..19,11,Manual) CalcRef=MxnTIIE-SpreadGrid(13..19,12,Manual) CalcRef=MxnTIIE-SpreadGrid(14..19,13,Manual) CalcRef=MxnTIIE-SpreadGrid(15..19,14,Manual) CalcRef=MxnTIIE-SpreadGrid(16..19,15,Manual) CalcRef=MxnTIIE-SpreadGrid(17..19,16,Manual) CalcRef=MxnTIIE-SpreadGrid(18..19,17,Manual) CalcRef=MxnTIIE-SpreadGrid(19,18,Manual) CalcRef=MxnTIIE-SpreadGrid(2..19,1,Implied) CalcRef=MxnTIIE-SpreadGrid(3..19,2,Implied) CalcRef=MxnTIIE-SpreadGrid(4..19,3,Implied) CalcRef=MxnTIIE-SpreadGrid(5..19,4,Implied) CalcRef=MxnTIIE-SpreadGrid(6..19,5,Implied) CalcRef=MxnTIIE-SpreadGrid(7..19,6,Implied) CalcRef=MxnTIIE-SpreadGrid(8..19,7,Implied) CalcRef=MxnTIIE-SpreadGrid(9..19,8,Implied) CalcRef=MxnTIIE-SpreadGrid(10..19,9,Implied) CalcRef=MxnTIIE-SpreadGrid(11..19,10,Implied) CalcRef=MxnTIIE-SpreadGrid(12..19,11,Implied) CalcRef=MxnTIIE-SpreadGrid(13..19,12,Implied) CalcRef=MxnTIIE-SpreadGrid(14..19,13,Implied) CalcRef=MxnTIIE-SpreadGrid(15..19,14,Implied) CalcRef=MxnTIIE-SpreadGrid(16..19,15,Implied) CalcRef=MxnTIIE-SpreadGrid(17..19,16,Implied) CalcRef=MxnTIIE-SpreadGrid(18..19,17,Implied) CalcRef=MxnTIIE-SpreadGrid(19,18,Implied) ############## These are used to calculate the DV01 for MXN. Have to use the single entity calc ########################## ############## as the calc that produces the results as a list doesn't appear to work. ########################## ####### Calculate the Duration Amounts now that we have the DV01 ##################### CalcRef=MXNDurationAmounts-DV01() ###the amts from the USD curve CalcRef=MXNDurationUSDAmounts-DV01() #KACE Page Script ####### Calculate the Nominal Swap Required for an Entered DV01 ##################### CalcRef=MXNDurationNomReqd() ############# Calculate the duration based upon the BPV as opposed to DV01 ############# ###CalcRef=MXNDurationAmounts-BPV() ############# RC 14Aug04 Weighted 4 and 7 Yr ################## #CalcRef=TIIEARB_CreateWeighted4y7yTIIE(1,Bid) #CalcRef=TIIEARB_CreateWeighted4y7yTIIE(1,Ask) ################ Popups ###################### CalcRef=PopupFXMaintenance() CalcRef=PopupTIIEMaintenance() CalcRef=Popup-Mxn3WaySpreadCalc() #### These are used to calc the Implied MXN for just ON/TN 21Jun05 MG/RC CalcRef=ONTNMXNFXCalcImpliedMXN(ON) CalcRef=ONTNMXNFXCalcImpliedMXN(TN) ###### RC 07Dec05 Added to stop users over writing none manual forwards. CalcRef=VBLockFwds(Bid,MXN) CalcRef=VBLockFwds(Ask,MXN) ############## MG 13Nov07 TIIE Short-Dates Fwd Grid. ############# #KACE Page Script CalcRef=FwdGrid_FwdTIIEs(0d) CalcRef=FwdGrid_FwdTIIEs(28d) CalcRef=FwdGrid_FwdTIIEs(56d) CalcRef=FwdGrid_FwdTIIEs(84d) CalcRef=FwdGrid_FwdTIIEs(112d) CalcRef=FwdGrid_FwdTIIEs(140d) CalcRef=LongFwdGrid_FwdTIIEs(364d) #CalcRef=LongFwdGrid_FwdTIIEs(532d) CalcRef=LongFwdGrid_FwdTIIEs(728d) CalcRef=LongFwdGrid_FwdTIIEs(1092d) CalcRef=LongFwdGrid_FwdTIIEs(1456d) CalcRef=LongFwdGrid_FwdTIIEs(1820d) CalcRef=LongFwdGrid_FwdTIIEs(2184d) CalcRef=LongFwdGrid_FwdTIIEs(2548d) CalcRef=LongFwdGrid_FwdTIIEs(2912d) CalcRef=LongFwdGrid_FwdTIIEs(3278d) CalcRef=LongFwdGrid_FwdTIIEs(3640d) CalcRef=LongFwdGrid_FwdTIIEs(4368d) CalcRef=LongFwdGrid_FwdTIIEs(5460d) CalcRef=LongFwdGrid_FwdBSs(364d) #CalcRef=LongFwdGrid_FwdBSs(532d) CalcRef=LongFwdGrid_FwdBSs(728d) CalcRef=LongFwdGrid_FwdBSs(1092d) CalcRef=LongFwdGrid_FwdBSs(1456d) CalcRef=LongFwdGrid_FwdBSs(1820d) CalcRef=LongFwdGrid_FwdBSs(2184d) CalcRef=LongFwdGrid_FwdBSs(2548d) CalcRef=LongFwdGrid_FwdBSs(2912d) CalcRef=LongFwdGrid_FwdBSs(3278d) CalcRef=LongFwdGrid_FwdBSs(3640d) CalcRef=LongFwdGrid_FwdBSs(4368d) CalcRef=LongFwdGrid_FwdBSs(5460d) #####TIIE Regular Snapshot FX Dates popup #KACE Page Script CalcRef=TIIEARB_PopupRegFXDates() CalcRef=TIIEARB_PopupSprdOvr10Yrs() CalcRef=TIIEARB_PopupFwdGrid() CalcRef=TIIEARB_PopupLongDatedFwdGrid() ### Basis Nudging Feb 08 ##### #KACE Page Script CalcRef=BasisNudgeNudgedBasis() CalcRef=BasisNudge_Button3() #KACE Page Script #MW Oct 08 chged interp routine from * to 28d to 364d only due to long TIIE spread calc # need to review and remove TIIEARB_SelfInterp(TIIE,Bid,MXN) and Ask side CalcRef=TIIEARB_SelfInterpTIIE(TIIE,Bid,MXN) CalcRef=TIIEARB_SelfInterpTIIE(TIIE,Ask,MXN) CalcRef=TIIEARB_InBasisNudge() #KACE Page Script CalcRef=CopyUSshortRates(Bid) CalcRef=CopyUSshortRates(Ask) ######Ensure O/N TIIE Rate is populated####### CalcRef=CopyTIEEONRate() ####NEW ADJ CURVE##### #Calcref=DFC-6MLiborCurve(Bid,USD) #Calcref=DFC-6MLiborCurve(Ask,USD) CalcRef=DFC-3MAdjCurve(Bid,USD) CalcRef=DFC-3MAdjCurve(Ask,USD) ############################################ ## Amended model to include 19m 6y, 8y and 9y ## Linearly Interps +/- adj new periods alternatively allows spread over/under or manual #KACE Page Script CalcRef=MXN_SprdMinorMats19m(Ask) CalcRef=MXN_SprdMinorMats19m(Bid) CalcRef=MXN_SprdMinorMats6y(Ask) CalcRef=MXN_SprdMinorMats6y(Bid) CalcRef=MXN_SprdMinorMats8y(Ask) CalcRef=MXN_SprdMinorMats8y(Bid) CalcRef=MXN_SprdMinorMats9y(Ask) CalcRef=MXN_SprdMinorMats9y(Bid) #KACE Page Script CalcRef=MXN_UPnDN_ManInputs() CalcRef=MXN_UPnDN_MinorMats() CalcRef=MXN_UPnDN_SprdsOv10Y() CalcRef=MXN_UPnDN_Basis() CalcRef=FwdFwdMXNCharts() ### For DV01 Calculator for FX CalcRef=MXN-CalcDV01_USD() CalcRef=MXNDurNomReqdUSD() ### For DV01 calculator for TIIE or Basis using USD curve CalcRef=MXN-CalcDV01_2() CalcRef=MXN_2DurationNomReqd() #### For DV01 calc for any broken dates #KACE Page Script CalcRef=MXNAdjDatesToBD-3(Start,1,1,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(Start,1,2,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(Start,1,3,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(Start,1,4,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(Start,1,5,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(End,1,1,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(End,1,2,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(End,1,3,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(End,1,4,BrokenDV01) CalcRef=MXNAdjDatesToBD-3(End,1,5,BrokenDV01) CalcRef=MXNBrknDurationNomReqd(1) CalcRef=MXNBrknDurationNomReqd(2) CalcRef=MXNBrknDurationNomReqd(3) CalcRef=MXNBrknDurationNomReqd(4) CalcRef=MXNBrknDurationNomReqd(5) CalcRef=MXN_2BrknDurationNomReqd(1) CalcRef=MXN_2BrknDurationNomReqd(2) CalcRef=MXN_2BrknDurationNomReqd(3) CalcRef=MXN_2BrknDurationNomReqd(4) CalcRef=MXN_2BrknDurationNomReqd(5) #KACE Page Script CalcRef=BrknDV01() #KACE Page Script CalcRef=MXNDurationFXAmounts-DV01() ## For the manual selection of Flys ## CalcRef=MXN_FlyStrips(Row) CalcRef=MXN_FlyStrips(1) CalcRef=MXN_FlyStrips(2) CalcRef=MXN_FlyStrips(3) CalcRef=MXN_FlyStrips(4) CalcRef=MXN_FlyStrips(5) CalcRef=MXN_FlyStrips(6) CalcRef=MXN_FlyStrips(7) CalcRef=MXN_FlyStrips(8) CalcRef=MXN_FlyStrips(9) CalcRef=MXN_FlyStrips(10) CalcRef=MXN_FlyStrips(11) CalcRef=MXN_FlyStrips(12) CalcRef=MXN_FlyStrips(13) CalcRef=MXN_FlyStrips(14) CalcRef=MXN_FlyStrips(15) ##### For Calculation of Near and Far NPA based on Body Amount Input ### CalcRef=MXN_Fly_Amts({Row}) #KACE Page Script CalcRef=MXN_Fly_Amts(1) CalcRef=MXN_Fly_Amts(2) CalcRef=MXN_Fly_Amts(3) CalcRef=MXN_Fly_Amts(4) CalcRef=MXN_Fly_Amts(5) CalcRef=MXN_Fly_Amts(6) CalcRef=MXN_Fly_Amts(7) CalcRef=MXN_Fly_Amts(8) CalcRef=MXN_Fly_Amts(9) CalcRef=MXN_Fly_Amts(10) CalcRef=MXN_Fly_Amts(11) CalcRef=MXN_Fly_Amts(12) CalcRef=MXN_Fly_Amts(13) CalcRef=MXN_Fly_Amts(14) CalcRef=MXN_Fly_Amts(15) ##### For Calculation of fly rates required etc.... ### CalcRef=MXN_Reqd_Flys2({Row}) #KACE Page Script CalcRef=MXN_Reqd_Flys2(1) CalcRef=MXN_Reqd_Flys2(2) CalcRef=MXN_Reqd_Flys2(3) CalcRef=MXN_Reqd_Flys2(4) CalcRef=MXN_Reqd_Flys2(5) CalcRef=MXN_Reqd_Flys2(6) CalcRef=MXN_Reqd_Flys2(7) CalcRef=MXN_Reqd_Flys2(8) CalcRef=MXN_Reqd_Flys2(9) CalcRef=MXN_Reqd_Flys2(10) CalcRef=MXN_Reqd_Flys2(11) CalcRef=MXN_Reqd_Flys2(12) CalcRef=MXN_Reqd_Flys2(13) CalcRef=MXN_Reqd_Flys2(14) CalcRef=MXN_Reqd_Flys2(15) CubeRef=MXN_Reqd_Flys("NearSpdOrder,FarSpdOrder",*,1) Multiplier=4 ###### Popup Display for the above calcs #KACE Page Script CalcRef=PopupFLY() CalcRef=PopupSingleFly() #KACE Page Script ## This clears the input orders on the fly calc if ANY leg is changed CalcRef=MXNClearFlyOrdersNear(1) CalcRef=MXNClearFlyOrdersNear(2) CalcRef=MXNClearFlyOrdersNear(3) CalcRef=MXNClearFlyOrdersNear(4) CalcRef=MXNClearFlyOrdersNear(5) CalcRef=MXNClearFlyOrdersNear(6) CalcRef=MXNClearFlyOrdersNear(7) CalcRef=MXNClearFlyOrdersNear(8) CalcRef=MXNClearFlyOrdersNear(9) CalcRef=MXNClearFlyOrdersNear(10) CalcRef=MXNClearFlyOrdersNear(11) CalcRef=MXNClearFlyOrdersNear(12) CalcRef=MXNClearFlyOrdersNear(13) CalcRef=MXNClearFlyOrdersNear(14) CalcRef=MXNClearFlyOrdersNear(15) CalcRef=MXNClearFlyOrdersFar(1) CalcRef=MXNClearFlyOrdersFar(2) CalcRef=MXNClearFlyOrdersFar(3) CalcRef=MXNClearFlyOrdersFar(4) CalcRef=MXNClearFlyOrdersFar(5) CalcRef=MXNClearFlyOrdersFar(6) CalcRef=MXNClearFlyOrdersFar(7) CalcRef=MXNClearFlyOrdersFar(8) CalcRef=MXNClearFlyOrdersFar(9) CalcRef=MXNClearFlyOrdersFar(10) CalcRef=MXNClearFlyOrdersFar(11) CalcRef=MXNClearFlyOrdersFar(12) CalcRef=MXNClearFlyOrdersFar(13) CalcRef=MXNClearFlyOrdersFar(14) CalcRef=MXNClearFlyOrdersFar(15) CalcRef=MXNClearFlyOrdersFly(1) CalcRef=MXNClearFlyOrdersFly(2) CalcRef=MXNClearFlyOrdersFly(3) CalcRef=MXNClearFlyOrdersFly(4) CalcRef=MXNClearFlyOrdersFly(5) CalcRef=MXNClearFlyOrdersFly(6) CalcRef=MXNClearFlyOrdersFly(7) CalcRef=MXNClearFlyOrdersFly(8) CalcRef=MXNClearFlyOrdersFly(9) CalcRef=MXNClearFlyOrdersFly(10) CalcRef=MXNClearFlyOrdersFly(11) CalcRef=MXNClearFlyOrdersFly(12) CalcRef=MXNClearFlyOrdersFly(13) CalcRef=MXNClearFlyOrdersFly(14) CalcRef=MXNClearFlyOrdersFly(15) CalcRef=MXN_Days2Mths(1) CalcRef=MXN_Days2Mths(2) CalcRef=MXN_Days2Mths(3) CalcRef=MXN_Days2Mths(4) CalcRef=MXN_Days2Mths(5) CalcRef=MXN_Days2Mths(6) CalcRef=MXN_Days2Mths(7) CalcRef=MXN_Days2Mths(8) CalcRef=MXN_Days2Mths(9) CalcRef=MXN_Days2Mths(10) CalcRef=MXN_Days2Mths(11) CalcRef=MXN_Days2Mths(12) CalcRef=MXN_Days2Mths(13) CalcRef=MXN_Days2Mths(14) CalcRef=MXN_Days2Mths(15) ################################################################################ ###################### probably not required #################################### ################################################################################ ## For Fly Strip Grid and Implied Fly Strip Grid ## CalcRef=MXN_FlyStripGrid(Near,Far,Body) ## Periods 3,26,39,52,65,91,130,156,195,260,325,390 #CalcRef=MXN_FlyStripGrid(13,39,26) #CalcRef=MXN_FlyStripGrid(13,52,26) #CalcRef=MXN_FlyStripGrid(13,65,26) #CalcRef=MXN_FlyStripGrid(13,91,26) #CalcRef=MXN_FlyStripGrid(13,130,26) #CalcRef=MXN_FlyStripGrid(13,156,26) #CalcRef=MXN_FlyStripGrid(13,260,26) #CalcRef=MXN_FlyStripGrid(13,325,26) #CalcRef=MXN_FlyStripGrid(13,390,26) #CalcRef=MXN_FlyStripGrid(13,52,39) #CalcRef=MXN_FlyStripGrid(13,65,39) #CalcRef=MXN_FlyStripGrid(13,91,39) #CalcRef=MXN_FlyStripGrid(13,130,39) #CalcRef=MXN_FlyStripGrid(13,156,39) #CalcRef=MXN_FlyStripGrid(13,260,39) #CalcRef=MXN_FlyStripGrid(13,325,39) #CalcRef=MXN_FlyStripGrid(13,390,39) #CalcRef=MXN_FlyStripGrid(13,65,52) #CalcRef=MXN_FlyStripGrid(13,91,52) #CalcRef=MXN_FlyStripGrid(13,130,52) #CalcRef=MXN_FlyStripGrid(13,156,52) #CalcRef=MXN_FlyStripGrid(13,260,52) #CalcRef=MXN_FlyStripGrid(13,325,52) #CalcRef=MXN_FlyStripGrid(13,390,52) #CalcRef=MXN_FlyStripGrid(13,91,65) #CalcRef=MXN_FlyStripGrid(13,130,65) #CalcRef=MXN_FlyStripGrid(13,156,65) #CalcRef=MXN_FlyStripGrid(13,260,65) #CalcRef=MXN_FlyStripGrid(13,325,65) #CalcRef=MXN_FlyStripGrid(13,390,65) #CalcRef=MXN_FlyStripGrid(13,130,91) #CalcRef=MXN_FlyStripGrid(13,156,91) #CalcRef=MXN_FlyStripGrid(13,260,91) #CalcRef=MXN_FlyStripGrid(13,325,91) #CalcRef=MXN_FlyStripGrid(13,390,91) #CalcRef=MXN_FlyStripGrid(13,156,130) #CalcRef=MXN_FlyStripGrid(13,260,130) #CalcRef=MXN_FlyStripGrid(13,325,130) #CalcRef=MXN_FlyStripGrid(13,390,130) #CalcRef=MXN_FlyStripGrid(13,260,156) #CalcRef=MXN_FlyStripGrid(13,325,156) #CalcRef=MXN_FlyStripGrid(13,390,156) #CalcRef=MXN_FlyStripGrid(13,325,260) #CalcRef=MXN_FlyStripGrid(13,390,260) #CalcRef=MXN_FlyStripGrid(13,390,325) #CalcRef=MXN_FlyStripGrid(26,52,39) #CalcRef=MXN_FlyStripGrid(26,65,39) #CalcRef=MXN_FlyStripGrid(26,91,39) #CalcRef=MXN_FlyStripGrid(26,130,39) #CalcRef=MXN_FlyStripGrid(26,156,39) #CalcRef=MXN_FlyStripGrid(26,260,39) #CalcRef=MXN_FlyStripGrid(26,325,39) #CalcRef=MXN_FlyStripGrid(26,390,39) #CalcRef=MXN_FlyStripGrid(26,65,52) #CalcRef=MXN_FlyStripGrid(26,91,52) #CalcRef=MXN_FlyStripGrid(26,130,52) #CalcRef=MXN_FlyStripGrid(26,156,52) #CalcRef=MXN_FlyStripGrid(26,260,52) #CalcRef=MXN_FlyStripGrid(26,325,52) #CalcRef=MXN_FlyStripGrid(26,390,52) #CalcRef=MXN_FlyStripGrid(26,91,65) #CalcRef=MXN_FlyStripGrid(26,130,65) #CalcRef=MXN_FlyStripGrid(26,156,65) #CalcRef=MXN_FlyStripGrid(26,260,65) #CalcRef=MXN_FlyStripGrid(26,325,65) #CalcRef=MXN_FlyStripGrid(26,390,65) #CalcRef=MXN_FlyStripGrid(26,130,91) #CalcRef=MXN_FlyStripGrid(26,156,91) #CalcRef=MXN_FlyStripGrid(26,260,91) #CalcRef=MXN_FlyStripGrid(26,325,91) #CalcRef=MXN_FlyStripGrid(26,390,91) #CalcRef=MXN_FlyStripGrid(26,156,130) #CalcRef=MXN_FlyStripGrid(26,260,130) #CalcRef=MXN_FlyStripGrid(26,325,130) #CalcRef=MXN_FlyStripGrid(26,390,130) #CalcRef=MXN_FlyStripGrid(26,260,156) #CalcRef=MXN_FlyStripGrid(26,325,156) #CalcRef=MXN_FlyStripGrid(26,390,156) #CalcRef=MXN_FlyStripGrid(26,325,260) #CalcRef=MXN_FlyStripGrid(26,390,260) #CalcRef=MXN_FlyStripGrid(26,390,325) #CalcRef=MXN_FlyStripGrid(39,65,52) #CalcRef=MXN_FlyStripGrid(39,91,52) #CalcRef=MXN_FlyStripGrid(39,130,52) #CalcRef=MXN_FlyStripGrid(39,156,52) #CalcRef=MXN_FlyStripGrid(39,260,52) #CalcRef=MXN_FlyStripGrid(39,325,52) #CalcRef=MXN_FlyStripGrid(39,390,52) #CalcRef=MXN_FlyStripGrid(39,91,65) #CalcRef=MXN_FlyStripGrid(39,130,65) #CalcRef=MXN_FlyStripGrid(39,156,65) #CalcRef=MXN_FlyStripGrid(39,260,65) #CalcRef=MXN_FlyStripGrid(39,325,65) #CalcRef=MXN_FlyStripGrid(39,390,65) #CalcRef=MXN_FlyStripGrid(39,130,91) #CalcRef=MXN_FlyStripGrid(39,156,91) #CalcRef=MXN_FlyStripGrid(39,260,91) #CalcRef=MXN_FlyStripGrid(39,325,91) #CalcRef=MXN_FlyStripGrid(39,390,91) #CalcRef=MXN_FlyStripGrid(39,156,130) #CalcRef=MXN_FlyStripGrid(39,260,130) #CalcRef=MXN_FlyStripGrid(39,325,130) #CalcRef=MXN_FlyStripGrid(39,390,130) #CalcRef=MXN_FlyStripGrid(39,260,156) #CalcRef=MXN_FlyStripGrid(39,325,156) #CalcRef=MXN_FlyStripGrid(39,390,156) #CalcRef=MXN_FlyStripGrid(39,325,260) #CalcRef=MXN_FlyStripGrid(39,390,260) #CalcRef=MXN_FlyStripGrid(39,390,325) #CalcRef=MXN_FlyStripGrid(52,91,65) #CalcRef=MXN_FlyStripGrid(52,130,65) #CalcRef=MXN_FlyStripGrid(52,156,65) #CalcRef=MXN_FlyStripGrid(52,260,65) #CalcRef=MXN_FlyStripGrid(52,325,65) #CalcRef=MXN_FlyStripGrid(52,390,65) #CalcRef=MXN_FlyStripGrid(52,130,91) #CalcRef=MXN_FlyStripGrid(52,156,91) #CalcRef=MXN_FlyStripGrid(52,260,91) #CalcRef=MXN_FlyStripGrid(52,325,91) #CalcRef=MXN_FlyStripGrid(52,390,91) #CalcRef=MXN_FlyStripGrid(52,156,130) #CalcRef=MXN_FlyStripGrid(52,260,130) #CalcRef=MXN_FlyStripGrid(52,325,130) #CalcRef=MXN_FlyStripGrid(52,390,130) #CalcRef=MXN_FlyStripGrid(52,260,156) #CalcRef=MXN_FlyStripGrid(52,325,156) #CalcRef=MXN_FlyStripGrid(52,390,156) #CalcRef=MXN_FlyStripGrid(52,325,260) #CalcRef=MXN_FlyStripGrid(52,390,260) #CalcRef=MXN_FlyStripGrid(52,390,325) #CalcRef=MXN_FlyStripGrid(65,130,91) #CalcRef=MXN_FlyStripGrid(65,156,91) #CalcRef=MXN_FlyStripGrid(65,260,91) #CalcRef=MXN_FlyStripGrid(65,325,91) #CalcRef=MXN_FlyStripGrid(65,390,91) #CalcRef=MXN_FlyStripGrid(65,156,130) #CalcRef=MXN_FlyStripGrid(65,260,130) #CalcRef=MXN_FlyStripGrid(65,325,130) #CalcRef=MXN_FlyStripGrid(65,390,130) #CalcRef=MXN_FlyStripGrid(65,260,156) #CalcRef=MXN_FlyStripGrid(65,325,156) #CalcRef=MXN_FlyStripGrid(65,390,156) #CalcRef=MXN_FlyStripGrid(65,325,260) #CalcRef=MXN_FlyStripGrid(65,390,260) #CalcRef=MXN_FlyStripGrid(65,390,325) #CalcRef=MXN_FlyStripGrid(91,156,130) #CalcRef=MXN_FlyStripGrid(91,260,130) #CalcRef=MXN_FlyStripGrid(91,325,130) #CalcRef=MXN_FlyStripGrid(91,390,130) #CalcRef=MXN_FlyStripGrid(91,260,156) #CalcRef=MXN_FlyStripGrid(91,325,156) #CalcRef=MXN_FlyStripGrid(91,390,156) #CalcRef=MXN_FlyStripGrid(91,325,260) #CalcRef=MXN_FlyStripGrid(91,390,260) #CalcRef=MXN_FlyStripGrid(91,390,325) #CalcRef=MXN_FlyStripGrid(130,260,156) #CalcRef=MXN_FlyStripGrid(130,325,156) #CalcRef=MXN_FlyStripGrid(130,390,156) #CalcRef=MXN_FlyStripGrid(130,325,260) #CalcRef=MXN_FlyStripGrid(130,390,260) #CalcRef=MXN_FlyStripGrid(130,390,325) #CalcRef=MXN_FlyStripGrid(156,325,260) #CalcRef=MXN_FlyStripGrid(156,390,260) #CalcRef=MXN_FlyStripGrid(156,390,325) #CalcRef=MXN_FlyStripGrid(260,390,325) #### MXN Closings popup all data is from SERVER #KACE Page Script CalcRef=MXNClose_TIIEPopup() #KACE Page Script CalcRef=MXN_DynamicSpreads(1) CalcRef=MXN_DynamicSpreads(2) CalcRef=MXN_DynamicSpreads(3) CalcRef=MXN_DynamicSpreads(4) CalcRef=MXN_DynamicSpreads(5) #KACE Page Script CubeRef=MXN_DynamicSpreads(Near,*,1) SetControl=ComboIndex1,3m|6m|9m|1y|19m|2y|3y|4y|5y|6y|7y|8y|9y|10y|12y|15y|20y|25y CubeRef=MXN_DynamicSpreads(Far,*,1) SetControl=ComboIndex1,3m|6m|9m|1y|19m|2y|3y|4y|5y|6y|7y|8y|9y|10y|12y|15y|20y|25y|30y CubeRef=MXN_DynamicSpreads(ManImp,*,1) SetControl=ComboString,Manual|Implied #KACE Page Script CalcRef=MXN_ImpRatePopup() ### Client Side ONLY #KACE Page Script ## on the client and server the value layer needs to have track remote checked on the forwards cube ## the client does not take the attributes fdrom the server cube of locked or unlocked and this needs to be run on the server CalcRef=VBLockFwdsClientSide(Bid,MXN) CalcRef=VBLockFwdsClientSide(AskBid,MXN) #KACE Page Script CalcRef=BrokenDatedTIIE() CalcRef=BrokenDatedFX()