Changes

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

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

*If settlement date ≥ maturity date, Calci displays #N/A error message.

*If settlement date ≥ maturity date, Calci displays #N/A error message.

*'rate' and 'yield' values must be greater than zero, else Calci displays #N/A error message.

*'rate' and 'yield' values must be greater than or equal to zero, else Calci displays #N/A error message.

*'redemption' value must be greater than or equal to zero, else Calci displays #N/A error message.

*'redemption' value must be greater than zero, else Calci displays #N/A error message.

*The values for 'frequency' should be 1,2 or 4.  

*The values for 'frequency' should be 1,2 or 4.  

For Annual payment, frequency = 1,

For Annual payment, frequency = 1,