Function SecurityDiscountedPrice(SettlementDate, MaturityDate, Redemption, DiscountRate, Basis)


The function SecurityDiscountedPrice returns the price of a discounted security at settlement date.

    SettlementDate,           ! (input) scalar string expression
    MaturityDate,             ! (input) scalar string expression
    Redemption,               ! (input) numerical expression
    DiscountRate,             ! (input) numerical expression
    [Basis]                   ! (optional) numerical expression



The date of settlement of the security. SettlementDate must be given in a date format.


The date of maturity of the security. MaturityDate must also be in date format and must be a date after SettlementDate.


The amount repaid at maturity date. Redemption must be a positive real number.


The rate the security’s value increases per year as a percentage of the redemption value. DiscountRate must be a positive real number.


The day-count basis method to be used. The default is 1.

Return Value

The function SecurityDiscountedPrice returns the price of the security at settlement date.


  • This function can be used in an objective function or constraint and the input parameters Redemption and DiscountRate can be used as a variable.

  • The function SecurityDiscountedPrice is similar to the Excel function PRICEDISC.

See also

Day count basis methods. General equations for discounted securities.