| | settlement | The settlement date of the security. |
| | maturity | The maturity date of the security. |
| | issue | The issue date of the security. |
| | first_coupon | The first coupon date of the security. |
| | rate | The interest rate of the security. |
| | yld | The annual yield of the security. |
| | redemption | The redemption value of the security per $100 face value. |
| | frequency | The number of coupon payments per year:
1 = annual
2 = semi annual
4 = quarterly |
| | basis | The type of day counting to use:
0 = US 30/360
1 = Actual/Actual
2 = Actual/360
3 = Actual/365
4 = European 30/360 |
| | | This function is only available if you have the Analysis ToolPak add-in installed. |
| | | 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" < 0, then #NUM! is returned. |
| | | If "basis" > 4, then #NUM! is returned. |
| | | If "basis" is not an integer, it is truncated. |
| | | If "basis" is left blank, then 0 is used. |
| | | | 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! |
| |
