YIELDMAT
Description
Returns the annual yield for a security paying interest at maturity.
Syntax
YIELDMAT(
settlement
,
maturity
,
issue
,
rate
,
price
, [
basis
])
- settlement: The security's settlement date.
- maturity: The security's maturity date.
- issue: The security's issue date.
- rate: The security's interest rate when issued.
- price: The security's price per $100 face value.
- basis: The financial day count to use, shown here using x/y where x = days per month and y = days per year. 0 or Empty = US NASD 30/360; 1 = actual/actual; 2 = actual/360; 3 = actual/365; 4 = European 30/360.