ODDLPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency [,basis])
Returns the price per $100 face value of a security with an odd last period.
|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||(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
|* If "basis" is left blank, then 0 is used.|
* If "basis" is not an integer, then it is truncated.
* If "basis" < 0, then #NUM! is returned.
* If "basis" > 4, then #NUM! is returned.
* You can use the ODDFPRICE function to return the price per $100 face value of a security with an odd first 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.
* For the Microsoft documentation refer to support.microsoft.com
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top