⌨ Syntax
PRICEDISC(settlement,maturity,discount,redemption,[basis])
Arguments
settlement
(required)
— The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
maturity
(required)
— The security's maturity date. The maturity date is the date when the security expires.
discount
(required)
— The security's discount rate.
redemption
(required)
— The security's redemption value per $100 face value.
basis
(optional)
— The type of day count basis to use.
▶ Examples
=PRICEDISC(A2,A3,A4,A5,A6)