writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 16:
Line 16: − +
→Description
*PRICEDISC is calculated by subtracting discounted amount from redemption value.
*PRICEDISC is calculated by subtracting discounted amount from redemption value.
*<math>SettlementDate</math> and <math>MaturityDate</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>SettlementDate</math> and <math>MaturityDate</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.
*If <math>SettlementDate</math> date ≥ <math>MaturityDate</math> date, Calci displays #N/A error message.
*If <math>SettlementDate</math> ≥ <math>MaturityDate</math> , Calci displays #N/A error message.
*<math>DiscountRate</math> value must be greater than or equal to zero, else calci displays #N/A error message.
*<math>DiscountRate</math> value must be greater than or equal to zero, else calci displays #N/A error message.
*<math>RedemptionValue</math> value must be greater than zero, else Calci displays #N/A error message.
*<math>RedemptionValue</math> value must be greater than zero, else Calci displays #N/A error message.