What is ODDFYIELD function in Excel? ODDFYIELD function is one of the Financial functions in Microsoft Excel that returns the yield of a security that has an odd (short or long) first period. Syntax of ODDFYIELD function ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis]) The ODDFYIELD function syntax has the following arguments: Settlement: The security’s settlement date. The security…