WorksheetFunction.PriceDisc (Excel)

Returns the price per $100 face value of a discounted security.

PriceDisc (Arg1, Arg2, ..., Arg5)

Dim dblPriceDisc As Double
dblPriceDisc = WorksheetFunction.PriceDisc(Arg1:=, Arg2:=, Arg3:=, Arg4:=)

Arguments

Arg1 - Settlement - the security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer

Arg2 - Maturity - the security's maturity date. The maturity date is the date when the security expires

Arg3 - Discount - the security's discount rate

Arg4 - Redemption - the security's redemption value per $100 face value

Arg5 - Basis - the type of day count basis to use