Real Rate Swap – RRS, custom amortizing schedule (pay inflation fixed, receive nominal floating)

Last updated 20 November 2026

Function reference › Inflation Derivatives › Real Rate Swap

2 GIAnalyzer functions for Excel. Optional arguments are shown in [brackets].

GIA_IND_RRSCustomAmortInflationFixedNominalFloat_Risk

Returns the risk measures (DV01, CPI01, KR01, KCPI01, Macaulay/Modified Duration, Icoupon01) of a real rate inflation swap with a custom amortizing schedule paying an inflation-linked fixed rate and receiving a nominal floating rate.

GIA_IND_RRSCustomAmortInflationFixedNominalFloat_Risk(EDate, NE0, NE1, PrincipalDates, PrincipalRates, DR, NotP, BCPI, RateP, EfDateP, CFrP, DaysP, NotR, Sp, LR, EfDateR, CFrR, DaysR, S, DCurveDatesP, DCurveRatesP, DCurveDatesR, DCurveRatesR, FCurveDatesR, FCurveRatesR, CPICurveDates, CPICurveRates, Season, VDate, SDate, LagV, LagT, Comp, Days, Interp, CurP, RM, OT, OC, [StartTerm], [EndTerm])

Returns: Risk measures (DV01, CPI01, KR01, KCPI01, Macaulay/Modified Duration, Icoupon01) of a real rate inflation swap with a custom amortizing schedule paying an inflation-linked fixed rate and receiving a nominal floating rate

ArgumentUseDescription
EDateRequiredThe expiry date.
NE0RequiredThis parameter indicates whether the notional amount is being exchanged at the start. (Yes, No)
NE1RequiredThis parameter indicates whether the notional amount is being exchanged at expiry. (Yes, No)
PrincipalDatesRequiredThe array of dates of all principal payments.
PrincipalRatesRequiredThe array of percentages of all principal payments.
DRRequiredThe date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
NotPRequiredThe notional amount in the pay leg of the swap.
BCPIRequiredThe CPI level at the inception of the deal.
RatePRequiredThe interest rate of the pay leg.
EfDatePRequiredThe original effective date in the pay leg.
CFrPRequiredThe frequency of coupons in the pay leg of the swap (Annual, SemiAnnual, Quarterly, Monthly)
DaysPRequiredThe time basis in the pay leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360)
NotRRequiredThe notional amount in the receive leg of the swap.
SpRequiredThe spread (in basis points) in the receive leg of the swap.
LRRequiredThe last reset rate of the reference interest rate in the receive leg of the swap.
EfDateRRequiredThe original effective date in the receive leg.
CFrRRequiredThe frequency of coupons in the receive leg of the swap (Annual, SemiAnnual, Quarterly, Monthly)
DaysRRequiredThe time basis in the receive leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360)
SRequiredThe FX spot rate.
DCurveDatesPRequiredThe array of dates in the interest rate curve used for discounting cash flows in the pay leg of the swap.
DCurveRatesPRequiredThe array of rates in the interest rate curve used for discounting cash flows in the pay leg of the swap.
DCurveDatesRRequiredThe array of dates in the interest rate curve used for discounting cash flows in the receive leg of the swap.
DCurveRatesRRequiredThe array of rates in the interest rate curve used for discounting cash flows in the receive leg of the swap.
FCurveDatesRRequiredThe array of dates in the interest rate curve used for calculating forward interest rates in the receive lag of the swap.
FCurveRatesRRequiredThe array of rates in the interest rate curve used for calculating forward interest rates in the receive lag of the swap.
CPICurveDatesRequiredThe array of dates in the expected CPI curve. The first date has to be equal to the value date.
CPICurveRatesRequiredThe array of rates in the expected CPI curve. The first rate has to be equal to the last published CPI before this date.
SeasonRequiredAn array of 12 numbers, each of which represents the difference between the average monthly inflation rate and the inflation rate in the specific month.
VDateRequiredThe value date.
SDateRequiredThe spot date.
LagVRequiredThe difference in months between the month of the value date and the last month included in the latest CPI. See the documentation for full description.
LagTRequiredThe difference in months between the month of the target date and the last month included in the latest CPI. See the documentation for full description.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
InterpRequiredThe interpolation method (Linear, LogLinear, CubicSpline, Exponential)
CurPRequiredThis parameter indicates whether the currency of the pay leg is base or counter (Base, Counter)
RMRequiredThe risk measure type (DV01, MacaulayDuration, ModifiedDuration, CPI01, KR01, KCPI01)
OTRequiredThe output type of the value/risk. (PayLeg, ReceiveLeg)
OCRequiredThe currency in which the DV01 of the swap is expressed (InBaseCurrency or Base, InCounterCurrency or Counter, InOwnCurrency or Own)
StartTermOptionalThe starting term for Bucket and Key Rate measures.
EndTermOptionalThe ending term for Bucket and Key Rate measures.

See also: GIA_IND_RRSCustomAmortInflationFixedNominalFloat_Value

GIA_IND_RRSCustomAmortInflationFixedNominalFloat_Value

Returns the value of a real rate inflation swap with a custom amortizing schedule in which the pay leg is inflation linked with fixed interest rate and the receive leg is nominal with floating interest rate.

GIA_IND_RRSCustomAmortInflationFixedNominalFloat_Value(EDate, NE0, NE1, PrincipalDates, PrincipalRates, DR, NotP, BCPI, RateP, EfDateP, CFrP, DaysP, NotR, Sp, LR, EfDateR, CFrR, DaysR, S, DCurveDatesP, DCurveRatesP, DCurveDatesR, DCurveRatesR, FCurveDatesR, FCurveRatesR, CPICurveDates, CPICurveRates, Season, VDate, SDate, LagV, LagT, Comp, Days, Interp, CurP, OT, OC)

Returns: Value of a real rate inflation swap with a custom amortizing schedule in which the pay leg is inflation linked with fixed interest rate and the receive leg is nominal with floating interest rate

ArgumentUseDescription
EDateRequiredThe expiry date.
NE0RequiredThis parameter indicates whether the notional amount is being exchanged at the start. (Yes, No)
NE1RequiredThis parameter indicates whether the notional amount is being exchanged at expiry. (Yes, No)
PrincipalDatesRequiredThe array of dates of all principal payments.
PrincipalRatesRequiredThe array of percentages of all principal payments.
DRRequiredThe date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
NotPRequiredThe notional amount in the pay leg of the swap.
BCPIRequiredThe CPI level at the inception of the deal.
RatePRequiredThe interest rate of the pay leg.
EfDatePRequiredThe original effective date in the pay leg.
CFrPRequiredThe frequency of coupons in the pay leg of the swap (Annual, SemiAnnual, Quarterly, Monthly)
DaysPRequiredThe time basis in the pay leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360)
NotRRequiredThe notional amount in the receive leg of the swap.
SpRequiredThe spread (in basis points) in the receive leg of the swap.
LRRequiredThe last reset rate of the reference interest rate in the receive leg of the swap.
EfDateRRequiredThe original effective date in the receive leg.
CFrRRequiredThe frequency of coupons in the receive leg of the swap (Annual, SemiAnnual, Quarterly, Monthly)
DaysRRequiredThe time basis in the receive leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360)
SRequiredThe FX spot rate.
DCurveDatesPRequiredThe array of dates in the interest rate curve used for discounting cash flows in the pay leg of the swap.
DCurveRatesPRequiredThe array of rates in the interest rate curve used for discounting cash flows in the pay leg of the swap.
DCurveDatesRRequiredThe array of dates in the interest rate curve used for discounting cash flows in the receive leg of the swap.
DCurveRatesRRequiredThe array of rates in the interest rate curve used for discounting cash flows in the receive leg of the swap.
FCurveDatesRRequiredThe array of dates in the interest rate curve used for calculating forward interest rates in the receive lag of the swap.
FCurveRatesRRequiredThe array of rates in the interest rate curve used for calculating forward interest rates in the receive lag of the swap.
CPICurveDatesRequiredThe array of dates in the expected CPI curve. The first date has to be equal to the value date.
CPICurveRatesRequiredThe array of rates in the expected CPI curve. The first rate has to be equal to the last published CPI before this date.
SeasonRequiredAn array of 12 numbers, each of which represents the difference between the average monthly inflation rate and the inflation rate in the specific month.
VDateRequiredThe value date.
SDateRequiredThe spot date.
LagVRequiredThe difference in months between the month of the value date and the last month included in the latest CPI. See the documentation for full description.
LagTRequiredThe difference in months between the month of the target date and the last month included in the latest CPI. See the documentation for full description.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
InterpRequiredThe interpolation method (Linear, LogLinear, CubicSpline, Exponential)
CurPRequiredThis parameter indicates whether the currency of the pay leg is base or counter (Base, Counter)
OTRequiredThe output type of the value/risk. (PayLeg, ReceiveLeg, Total)
OCRequiredThe currency in which the value of the swap is expressed (InBaseCurrency or Base, InCounterCurrency or Counter, InOwnCurrency or Own)

See also: GIA_IND_RRSCustomAmortInflationFixedNominalFloat_Risk