Cross-Currency Swap – CCS, custom amortizing schedule (pay floating RFR – receive fixed)
Last updated 20 November 2026
Function reference › Interest Rate Derivatives › Cross Currency Swap
2 GIAnalyzer functions for Excel. Optional arguments are shown in [brackets].
GIA_IRD_CCSCustomRFRFixed_Risk
Returns the risk measures (DV01, Coupon01, Macaulay/Modified Duration, KR01, Bucket DV01, Key Rate/Bucket Duration) of a cross-currency swap with a custom amortizing schedule paying floating (RFR) and receiving fixed.
GIA_IRD_CCSCustomRFRFixed_Risk(EDate, NE0, NE1, PrincipalDates, PrincipalRates, DR, NotP, SpP, LRP, EfDateP, CFrP, DaysP, NotR, RateR, EfDateR, CFrR, DaysR, S, DCurveDatesP, DCurveRatesP, FCurveDatesP, FCurveRatesP, DCurveDatesR, DCurveRatesR, HDatesP, HRatesP, VDate, SDate, Comp, Days, Interp, CurP, RM, OT, OC, CalcType, [StartTerm], [EndTerm])Returns: Risk measures (DV01, Coupon01, Macaulay/Modified Duration, KR01, Bucket DV01, Key Rate/Bucket Duration) of a cross-currency swap with a custom amortizing schedule paying floating (RFR) and receiving fixed
| Argument | Use | Description |
|---|---|---|
EDate | Required | The expiry date. |
NE0 | Required | Whether the notional amount is being exchanged at the start. (Yes, No) |
NE1 | Required | Whether the notional amount is being exchanged at expiry. (Yes, No) |
PrincipalDates | Required | The array of dates of all principal payments. |
PrincipalRates | Required | The array of percentages of all principal payments. |
DR | Required | The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment) |
NotP | Required | The notional amount in the pay leg of the swap. |
SpP | Required | The spread (in basis points) in the pay leg of the swap. |
LRP | Required | The last reset rate of the reference interest rate in the pay leg of the swap. |
EfDateP | Required | The original effective date in the pay leg of the swap. |
CFrP | Required | The frequency of coupons in the pay leg of the swap (Annual, SemiAnnual, Quarterly, Monthly) |
DaysP | Required | The time basis in the pay leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360) |
NotR | Required | The notional amount in the receive leg of the swap. |
RateR | Required | The fixed rate in the receive leg of the swap. |
EfDateR | Required | The original effective date in the receive leg of the swap. |
CFrR | Required | The frequency of coupons in the receive leg of the swap (Annual, SemiAnnual, Quarterly, Monthly) |
DaysR | Required | The time basis in the receive leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360) |
S | Required | The FX spot rate. |
DCurveDatesP | Required | The array of dates in the interest rate curve used for discounting cash flows in the pay leg of the swap. |
DCurveRatesP | Required | The array of rates in the interest rate curve used for discounting cash flows in the pay leg of the swap. |
FCurveDatesP | Required | The array of dates in the interest rate curve used for calculating forward interest rates, in the pay leg of the swap. |
FCurveRatesP | Required | The array of rates in the interest rate curve used for calculating forward interest rates, in the pay leg of the swap. |
DCurveDatesR | Required | The array of dates in the interest rate curve used for discounting cash flows in the receive leg of the swap. |
DCurveRatesR | Required | The array of rates in the interest rate curve used for discounting cash flows in the receive leg of the swap. |
HDatesP | Required | The array of dates of historical rates of the floating interest rate in the pay leg of the swap. |
HRatesP | Required | The array of historical rates of the floating interest rate in the pay leg of the swap. |
VDate | Required | The value date. |
SDate | Required | The spot date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |
CurP | Required | Whether the currency of the pay leg is base or counter (Base, Counter) |
RM | Required | The risk measure type (DV01, Coupon01, MacaulayDuration, ModifiedDuration, KR01, BucketDV01, KRDuration, BucketDuration) |
OT | Required | The output type of the value/risk. (PayLeg, ReceiveLeg) |
OC | Required | The currency in which the DV01 is expressed (InBaseCurrency or Base, InCounterCurrency or Counter) |
CalcType | Required | The floating leg calculation method; Approx is the default (Approx, Exact) |
StartTerm | Optional | The starting term for Bucket and Key Rate measures. |
EndTerm | Optional | The ending term for Bucket and Key Rate measures. |
See also: GIA_IRD_CCSCustomRFRFixed_Value
GIA_IRD_CCSCustomRFRFixed_Value
Returns the value of a cross-currency swap with a custom amortizing schedule in which the interest rate in the pay leg is floating (RFR) and the interest rate in the receive leg is fixed.
GIA_IRD_CCSCustomRFRFixed_Value(EDate, NE0, NE1, PrincipalDates, PrincipalRates, DR, NotP, SpP, LRP, EfDateP, CFrP, DaysP, NotR, RateR, EfDateR, CFrR, DaysR, S, DCurveDatesP, DCurveRatesP, FCurveDatesP, FCurveRatesP, DCurveDatesR, DCurveRatesR, HDatesP, HRatesP, VDate, SDate, Comp, Days, Interp, CurP, OT, OC, CalcType)Returns: Value of a cross-currency swap with a custom amortizing schedule in which the interest rate in the pay leg is floating (RFR) and the interest rate in the receive leg is fixed
| Argument | Use | Description |
|---|---|---|
EDate | Required | The expiry date. |
NE0 | Required | Whether the notional amount is being exchanged at the start. (Yes, No) |
NE1 | Required | Whether the notional amount is being exchanged at expiry. (Yes, No) |
PrincipalDates | Required | The array of dates of all principal payments. |
PrincipalRates | Required | The array of percentages of all principal payments. |
DR | Required | The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment) |
NotP | Required | The notional amount in the pay leg of the swap. |
SpP | Required | The spread (in basis points) in the pay leg of the swap. |
LRP | Required | The last reset rate of the reference interest rate in the pay leg of the swap. |
EfDateP | Required | The original effective date in the pay leg of the swap. |
CFrP | Required | The frequency of coupons in the pay leg of the swap (Annual, SemiAnnual, Quarterly, Monthly) |
DaysP | Required | The time basis in the pay leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360) |
NotR | Required | The notional amount in the receive leg of the swap. |
RateR | Required | The fixed rate in the receive leg of the swap. |
EfDateR | Required | The original effective date in the receive leg of the swap. |
CFrR | Required | The frequency of coupons in the receive leg of the swap (Annual, SemiAnnual, Quarterly, Monthly) |
DaysR | Required | The time basis in the receive leg of the swap (act/360, act/365, act/act, 30E/360, 30I/360) |
S | Required | The FX spot rate. |
DCurveDatesP | Required | The array of dates in the interest rate curve used for discounting cash flows in the pay leg of the swap. |
DCurveRatesP | Required | The array of rates in the interest rate curve used for discounting cash flows in the pay leg of the swap. |
FCurveDatesP | Required | The array of dates in the interest rate curve used for calculating forward interest rates, in the pay leg of the swap. |
FCurveRatesP | Required | The array of rates in the interest rate curve used for calculating forward interest rates, in the pay leg of the swap. |
DCurveDatesR | Required | The array of dates in the interest rate curve used for discounting cash flows in the receive leg of the swap. |
DCurveRatesR | Required | The array of rates in the interest rate curve used for discounting cash flows in the receive leg of the swap. |
HDatesP | Required | The array of dates of historical rates of the floating interest rate in the pay leg of the swap. |
HRatesP | Required | The array of historical rates of the floating interest rate in the pay leg of the swap. |
VDate | Required | The value date. |
SDate | Required | The spot date. |
Comp | Required | The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |
CurP | Required | Whether the currency of the pay leg is base or counter (Base, Counter) |
OT | Required | The output type of the value/risk. (PayLeg, ReceiveLeg, Total) |
OC | Required | The currency in which the value is expressed (InBaseCurrency or Base, InCounterCurrency or Counter, InOwnCurrency or Own) |
CalcType | Required | The floating leg calculation method; Approx is the default (Approx, Exact) |
See also: GIA_IRD_CCSCustomRFRFixed_Risk
