ConvertRate
Mon 01 January 2018Syntax
ConvertRate(Rate, In_Frequency, Out_Frequency)
Description
Use the ConvertRate function to convert a rate between various compounding frequencies.
Parameters
|
Field or Control |
Definition |
|---|---|
| Rate |
The rate to be converted. This parameter takes a number value. |
| In_Frequency |
The frequency of the rate to be converted from. This parameter takes an array of number, with two elements. The first element is periodicity, (for example, if you chose daily compounding, 1 would represent daily while 7 would represent weekly.) The second element is the unit of measure of frequency. The values for the second element are: |
|
Value |
Description |
|---|---|
|
0 |
continuous compounding |
|
1 |
daily compounding |
|
2 |
monthly compounding |
|
3 |
yearly compounding |
|
Field or Control |
Definition |
|---|---|
| Out_Frequency |
The frequency of the rate to be converted to. This parameter takes an array of number, with two elements. The first element is periodicity, (for example, if you chose daily compounding, 1 would represent daily while 7 would represent weekly.) The second element is the unit of measure of frequency. The values for the second element are: |
|
Value |
Description |
|---|---|
|
0 |
continuous compounding |
|
1 |
daily compounding |
|
2 |
monthly compounding |
|
3 |
yearly compounding |
Returns
A number representing the converted rate.