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.