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.