Compounding Conversion
Last updated 9 November 2026
Function reference › Interest Rates › Interest Rates
1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].
GIA_IR_CompoundingConverter
Converts an interest rate from one compounding basis to another
GIA_IR_CompoundingConverter(interestRate, T0, T, CompInput, CompOutput, DaysInput, DaysOutput)| Argument | Use | Description |
|---|---|---|
interestRate | Required | The annual interest rate. |
T0 | Required | The start date of the interest rate period. |
T | Required | The end date of the interest rate period. |
CompInput | Required | The compounding basis of the input interest rate (Annual, SemiAnnual, Quarterly, Simple, Continuous) |
CompOutput | Required | The compounding basis of the output interest rate (Annual, SemiAnnual, Quarterly, Simple, Continuous) |
DaysInput | Required | The time basis of the input interest rate (act/360, act/365, act/act, 30E/360, 30I/360) |
DaysOutput | Required | The time basis of the output interest rate (act/360, act/365, act/act, 30E/360, 30I/360) |