ODDLYIELD
Returns the yield of a security with an odd last period
Syntax
ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- last_interest: Required. The security's last coupon date before the maturity date
- rate: Required. The security's interest rate
- pr: Required. The security's price
- redemption: Required. The security's redemption value
- frequency: Required. The number of coupon payments per year
- basis: Optional. The type of day count basis
Example
=ODDLYIELD("04/20/2024", "06/15/2024", "12/24/2023", 0.0375, 99.875, 100, 2, 0)