PRICEDISC
Category: Financial Function.
Description: Returns the price per $100 face value of a discounted security.
Syntax: PRICEDISC(settlement, maturity, discount, redemption, [basis])
The PRICEDISC function syntax has the following arguments:
Settlement: security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
Maturity: security's maturity date. The maturity date is the date when the security expires.
Discount: security's discount rate.
Redemption: security's redemption value per $100 face value.
Basis: type of day count basis to use.