Excel Function : ODDLYIELD

Download now!

Excel Function : ODDLYIELD




Returns the yield of a security with an odd last period

Microsoft Excel Reference Page


Syntax and Description of the ODDLYIELD Excel Function

I am trying to understand how to use the ODDLYIELD() function in excel. The syntax I have is: =ODDLYIELD( settlement, maturity, rate, pr, redemption, frequency, [basis], [calc_method] ) where: 'Settlement' is the security's settlement date, the date after the last coupon date. 'Maturity' is the security's maturity date. 'Rate' is the security's annual coupon rate. 'Pr' is the security's price. 'Redemption' is the security's par value. 'Frequency' is the number of coupon payments per year. 'Basis' is the type of

About ODDLYIELD Excel Function

The ODDLYIELD function returns the yield of a security with an odd first period.