ODDFPRICE
Returns the price per $100 face value of a security with an odd first period
Syntax
ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, 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
- yld: Required. The security's annual yield
- 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
=ODDFPRICE("11/11/2024", "03/01/2029", "10/15/2024", "03/01/2025", 0.0785, 0.0625, 100, 2, 1)