Cross-Currency Swap – CCS, custom amortizing schedule (pay fixed – receive fixed)

Last updated 9 November 2026

Function reference › Interest Rate Derivatives › Cross Currency Swap

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

GIA_IRD_CCSCustomFixedFixed_Risk

Returns the risk measures (DV01, Coupon01, Macaulay Duration, Modified Duration) of a cross-currency swap with a custom amortizing schedule in which the interest rates in both legs are fixed.

GIA_IRD_CCSCustomFixedFixed_Risk(EDate, NE0, NE1, PrincipalDates, PrincipalRates, DR, NotP, RateP, EfDateP, CFrP, DaysP, NotR, RateR, EfDateR, CFrR, DaysR, S, DCurveDatesP, DCurveRatesP, DCurveDatesR, DCurveRatesR, VDate, SDate, Comp, Days, Interp, CurP, RM, OT, OC)

Returns: Risk measures (DV01, Coupon01, Macaulay Duration, Modified Duration) of a cross-currency swap with a custom amortizing schedule in which the interest rates in both legs are fixed

ArgumentUseDescription
EDateRequiredThe expiry date.
NE0RequiredWhether the notional amount is being exchanged at the start. (Yes, No)
NE1RequiredWhether 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.
RatePRequiredThe fixed rate in the pay leg of the swap.
EfDatePRequiredThe original effective date in the pay leg of the swap.
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.
RateRRequiredThe fixed rate in the receive leg of the swap.
EfDateRRequiredThe original effective date in the receive leg of the swap.
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.
VDateRequiredThe value date.
SDateRequiredThe spot date.
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)
CurPRequiredWhether the currency of the pay leg is base or counter (Base, Counter)
RMRequiredThe risk measure type (DV01, Coupon01, MacaulayDuration, ModifiedDuration)
OTRequiredThe output type of the value/risk. (PayLeg, ReceiveLeg)
OCRequiredThe currency in which the DV01 is expressed (InBaseCurrency, InCounterCurrency)

See also: GIA_IRD_CCSCustomFixedFixed_Value

GIA_IRD_CCSCustomFixedFixed_Value

Returns the value of a cross-currency swap with a custom amortizing schedule in which the interest rates in both legs are fixed.

GIA_IRD_CCSCustomFixedFixed_Value(EDate, NE0, NE1, PrincipalDates, PrincipalRates, DR, NotP, RateP, EfDateP, CFrP, DaysP, NotR, RateR, EfDateR, CFrR, DaysR, S, DCurveDatesP, DCurveRatesP, DCurveDatesR, DCurveRatesR, VDate, SDate, Comp, Days, Interp, CurP, OT, OC)

Returns: Value of a cross-currency swap with a custom amortizing schedule in which the interest rates in both legs are fixed

ArgumentUseDescription
EDateRequiredThe expiry date.
NE0RequiredWhether the notional amount is being exchanged at the start. (Yes, No)
NE1RequiredWhether 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.
RatePRequiredThe fixed rate in the pay leg of the swap.
EfDatePRequiredThe original effective date in the pay leg of the swap.
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.
RateRRequiredThe fixed rate in the receive leg of the swap.
EfDateRRequiredThe original effective date in the receive leg of the swap.
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.
VDateRequiredThe value date.
SDateRequiredThe spot date.
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)
CurPRequiredWhether 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 is expressed (InBaseCurrency, InCounterCurrency, InOwnCurrency)

See also: GIA_IRD_CCSCustomFixedFixed_Risk