Changes

  If B= Number of days from beginning of coupon period to settlement date,

  If B= Number of days from beginning of coupon period to settlement date,

     C= Number of days in coupon period,

     C= Number of days in coupon period,

     N= Number of days from settlement date to redemption date,

     N= Number of days from settlement date to redemption date

  <math>YIELD = \frac{(\frac{redemption}{100}+\frac{rate}{frequency})-(\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency}))}{\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency})}*\frac{frequency*C}{N}</math>

  :<math>YIELD = \frac{(\frac{redemption}{100}+\frac{rate}{frequency})-(\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency}))}{\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency})}*\frac{frequency*C}{N}</math>

*<math>settlement</math> and <math>maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.

*<math>settlement</math> and <math>maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.