WorksheetFunction.PriceMat (Excel)

Returns the price per $100 face value of a security that pays interest at maturity.

PriceMat (Arg1, Arg2, ..., Arg6)


Dim dblPriceMat As Double
dblPriceMat = WorksheetFunction.PriceMat(Arg1:=, Arg2:=, Arg3:=, Arg4:=, Arg5:=)

Arguments

Arg1, Arg2, ..., Arg6

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 - Issue - the security's issue date, expressed as a serial date number

Arg4 - Rate - the security's interest rate at date of issue

Arg5 - Yld - the security's annual yield

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