ODDFYIELD
Returns the yield of a security with an odd first period
Syntax
ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- issue: Required. The security's issue date
- first_coupon: Required. The security's first coupon date
- rate: Required. The security's interest rate
- pr: Required. The security's price
- redemption: Required. The security's redemption value per $100 face value
- frequency: Required. The number of coupon payments per year
- basis: Optional. The type of day count basis
Example
=ODDFYIELD("11/11/2024", "03/01/2029", "10/15/2024", "03/01/2025", 0.0575, 84.5, 100, 2, 0)