Excel Function : ODDFYIELD

Download now!

Excel Function : ODDFYIELD

Category

Financial

Description

Returns the yield of a security with an odd first period

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ODDFYIELD-function-66bc8b7b-6501-4c93-9ce3-2fd16220fe37

Syntax and Description of the ODDFYIELD Excel Function

The syntax for the ODDFYIELD function in Microsoft Excel is: =ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) Where: settlement - The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. maturity - The security's maturity date. The maturity date is the date when the security expires. issue - The security's issue date. The issue date is the date when the security is issued. first_coupon - The security's first coupon date. The first coupon date is the date

About ODDFYIELD Excel Function

ODDFYIELD returns the yield of a security with an odd first period.