Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: ODDLYIELD function

ODDLYIELD function: Description, Usage, Syntax, Examples and Explanation

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