YIELDDISC
Category: Financial Function.
Description: Returns the annual yield for a discounted security.
Syntax: YIELDDISC(settlement, maturity, pr, redemption, [basis])
The YIELDDISC 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.
Pr: security's price per $100 face value.
Redemption: security's redemption value per $100 face value.
Basis: type of day count basis to use.