YIELDMAT DAX Function (Financial)

Returns the annual yield of a security that pays interest at maturity.

Syntax

YIELDMAT ( <Settlement>, <Maturity>, <Issue>, <Rate>, <Pr> [, <Basis>] )

Parameter	Attributes	Description
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.
Maturity		The security‘s maturity date. The maturity date is the date when the security expires.
Issue		The security‘s issue date.
Rate		The security‘s interest rate at date of issue.
Pr		The security‘s price per $100 face value.
Basis	Optional	The type of day count basis to use.

Scalar A single decimal value.

Contributors: Alberto Ferrari, Marco Russo