InterestRate

High level graphic of InterestRate() function with parameters. Blue square node is the actual function with the parameters ordered.

1. Key parameter
   
   
   Key value to use as a handle for the created object
2. Reload parameter
   
   
   When creating this object for the first time, set this parameter to a positive value. Within Excel, when re-computing a worksheet where you do not wish to recreate the object, set this parameter to zero (0).
3. Rate parameter
   
   
   The interest rate.
4. compounding parameter
   
   
   The compounding of the interest rate passed in. 'Discounted' 1/(1-r*t), 'Simple' (1+r*t), 'Compounded' (1+r/N)^(t*N), where N is the number of coupons per year, 'Continuous' e^{r*t} and 'SimpleThenCompounded' (Simple up to the first period then Compounded).
5. Freq parameter
   
   
   Frequency of the passed in interest rate. (
6. DayCount parameter
   
   
   The DayCounter of the passed in interest rate.

String CTUtils.InterestRate( _
String Key, _
Long Reload, _
Double Rate, _
COMPEnum compounding, _
FreqEnum Freq, _
DayCountEnum DayCount)

=CT.Rate.InterestRate(
Excel String Cell Key,
Excel Numeric Cell Reload,
Excel Numeric Cell Rate,
Excel String Cell compounding,
Excel String Cell Freq,
Excel String Cell DayCount)

static std::string InterestRate(
std::string Key,
long Reload,
double Rate,
COMPEnum compounding,
FreqEnum Freq,
DayCountEnum DayCount);

System.String CTUtilsSA.InterestRate(
System.String Key,
System.Int32 Reload,
System.Double Rate,
CTIEnums.COMPEnum compounding,
CTIEnums.FreqEnum Freq,
CTIEnums.DayCountEnum DayCount);

• Example VB.NET Driver function. Preparing the parameters and the final function call (the result).
• Example C# Driver function. Preparing the parameters, sub-function calls and the final function call (the result).
• Example C++.NET Driver function. Preparing the parameters and the final function call (the result).
• Example J# Driver function. Preparing the parameters and the final function call (the result).

• Example Visual Basic 6 Driver function. Preparing the parameters and the final function call (the result).
• Example Excel VBA Driver function. Preparing the parameters and the final function call (the result).
• Example C++ Driver function. Preparing the parameters and the final function call (the result).
• Example Java Driver function. Preparing the parameters and the final function call (the result).