COUPDAYBS | Returns the number of days from the start of the coupon to the settlement date. |
COUPDAYS | Returns the number of days in the coupon period that contains the settlement date. |
COUPDAYSNC | Returns the number of days from the settlement date to the next coupon. |
COUPNCD | Returns the date of the next coupon after the settlement date. |
COUPNUM | Returns the number of coupons paid between the settlement date and maturity date. |
COUPPCD | Returns the date of the previous coupon before the settlement date. |
DOLLARDE | Returns the dollar fraction expressed as a decimal. |
DOLLARFR | Returns the dollar decimal expressed as a fraction. |
DURATION | Returns the annual duration for a security that pays interest at regular intervals. |
MDURATION | Returns the modified annual duration for a security that pays interest at regular intervals. |
ODDFPRICE | Returns the price per $100 face value for a security having an odd (short or long) first period. |
ODDFYIELD | Returns the yield of a security that has an odd (short or long) first period. |
ODDLPRICE | Returns the price per $100 face value for a security having an odd (short or long) last coupon period. |
ODDLYIELD | Returns the yield of a security that has an odd (short or long) last period. |
PRICE | Returns the price per $100 face value for a security that pays periodic interest. |
PRICEDISC | Returns the price per $100 face value for a discounted security. |
PRICEMAT | Returns the price per $100 face value for a security that pays interest at maturity. |
RATE | Returns the interest rate for a series of equal cash flows at regular intervals. |
TBILLEQ | Returns the bond-equivalent yield for a treasury bill. |
TBILLPRICE | Returns the price per $100 face value for a treasury bill. |
TBILLYIELD | Returns the yield for a treasury bill. |
YIELD | Returns the interest rate for a series of equal cash flows at regular intervals used for yield to maturity calculations. |
YIELDDISC | Returns the annual yield for a discounted security. |
YIELDMAT | Returns the annual yield for a security that pays interest at maturity. |