Given the price at which a security paying interest at maturity was bought, calculates its annual yield.
YIELDMAT(settlement: String, maturity: String, issue: String, rate: Number, price: Number, basis: String = us_nasd) => Number
Parameter | Description |
Settlement | The security's settlement date. |
Maturity | The security's maturity or end date. |
Issue | The date the security was initially issued. |
Rate | The annualized rate of interest. |
Price | The price at which the security is bought. |
Basis | Method to use for counting days per month/year:
|
date1 = "2010-03-01T13:06:15+03:00"date2 = "2010-12-31T13:06:15+03:00"date3 = "2010-01-02T13:06:15+03:00"date4 = "2009-01-31T13:06:15+03:00"date5 = "2023-10-31T13:06:15+03:00"date6 = "2009-01-30T13:06:15+03:00"date7 = "2023-10-30T13:06:15+03:00"date8 = "2008-10-30T13:06:15+03:00"
Formula | Return value |
|
|
|
|
|
|
|
|