Excel Function : ODDFPRICE

Download now!

Excel Function : ODDFPRICE

Category

Financial

Description

Returns the price per $100 face value of a security with an odd first period

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ODDFPRICE-function-d7d664a8-34df-4233-8d2b-922bcf6a69e1

Syntax and Description of the ODDFPRICE Excel Function

The syntax for the ODDFPRICE function in Microsoft Excel is: ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis]) The function returns the price per $100 face value of a security paying periodic interest.

About ODDFPRICE Excel Function

The ODDFPRICE function returns the price per $100 face value of a security with an odd first period.