ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency [,basis])

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

settlementThe settlement date of the security.
maturityThe maturity date of the security.
issueThe issue date of the security.
first_couponThe first coupon date of the security.
rateThe interest rate of the security.
yldThe annual yield of the security.
redemptionThe redemption value of the security per $100 face value.
frequencyThe number of coupon payments per year:
1 = annual
2 = semi annual
4 = quarterly
basis(Optional) The type of day counting to use:
0 = US 30/360 (default)
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/360

Remarks

* The settlement date is the date a buyer purchases a coupon, such as a bond. For example, suppose a 30-year bond is issued on January 1, 1996, and is purchased by a buyer six months later. The issue date would be January 1, 1996, the settlement date would be July 1, 1996, and the maturity date would be January 1, 2026, which is 30 years after the January 1, 1996, issue date.
* The maturity date is the date when a coupon expires.
* If "settlement" it is truncated.
* If "settlement" is not a valid date, then #NUM! is returned.
* If "maturity" is not an integer, it is truncated.
* If "maturity" is not a valid date, then #NUM! is returned.
* If "maturity" > "first_coupon" > "settlement" > "issue", then #NUM! is returned.
* If "issue" is not an integer, it is truncated.
* If "issue" is not a valid date, then #NUM! is returned.
* If "first_coupon" is not an integer, it is truncated.
* If "first_coupon" is not a valid date, then #NUM! is returned.
* If "rate" < 0, then #NUM! is returned.
* If "yld" < 0, then #NUM! is returned.
* If "basis" is left blank, then 0 is used.
* If "basis" is not an integer, it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* You can use the ODDLPRICE function to return the price per $100 face value of a security with an odd last period.
* You can use the ODDFYIELD function to return the yield of a security with an odd first period.
* You can use the ODDLYIELD function to return the yield of a security with an odd last period.
* In Excel 2007 the accuracy of this function was improved.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=ODDFPRICE("11/11/2008","01/03/2021","15/10/2008","01/03/2009",5/100,5/100,20,2,1) = 56.430
2=ODDFPRICE("11/01/1999","3/07/1999","10/10/2000","3/1/2001",0.5,0.5,100,2,1) = #NUM!
3=ODDFPRICE("11/01/1999","3/15/1999","10/10/2000","3/1/2001",0.5,0.5,100,2,1) = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top