Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: ODDFPRICE function

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

What is ODDFPRICE function in Excel? ODDFPRICE function is one of the Financial functions in Microsoft Excel that returns the price per $100 face value of a security having an odd (short or long) first period. Syntax of¬†ODDFPRICE function ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) The ODDFPRICE function syntax has the following arguments: Settlement: The security’s settlement…