Yconvert() function

Yconvert() function

Yconvert(argument list…)

This function converts yields from one compounding frequency to another. The function uses the following arguments:

Argument	Description	Restrictions
Source_Rate	the rate you are converting from in decimal form (e.g. six percent entered as 0.06)	>= 0
Source_Freq	the compounding frequency of the source rate	1 = annual 2 = semi-annual 4 = quarterly 12 = monthly 365 = daily 366 = continuous
Target_Freq	the compounding frequency of the rate you are converting to	1 = annual 2 = semi-annual 4 = quarterly 12 = monthly 365 = daily 366 = continuous