ODDFYIELD |
ODDFYIELD(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency [,basis]) |
Returns the yield of a security with an odd first 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 = 30/360 (default) 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = 30E/360 |
REMARKS |
* 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 ODDLYIELD function to return the yield of a security with an odd last period. * 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 ODDLPRICE function to return the price per $100 face value of a security with an odd last period. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top