### Day Counting Functions

Functions that take an optional day counting argument.

ACCRINT | The accrued interest for a security that pays interest periodically. |

ACCRINTM | The accrued interest for a security that pays interest at maturity. |

AMORDEGRC | The depreciation of an asset in a single period (straight-line, implicit coefficient). |

AMORLINC | The depreciation of an asset in a single period (straight-line). |

COUPDAYBS | The number of days between the previous coupon date and the settlement date. |

COUPDAYS | The number of days between the coupon dates on either side of the settlement date. |

COUPNCD | The next coupon date after the settlement date. |

COUPNUM | The number of coupons between the settlement date and the maturity date. |

COUPPCD | The previous coupon date before the settlement date. |

DISC | The interest rate (or discount rate) for a security held to maturity. |

DURATION | The annual duration of a security that pays interest periodically. |

INTRATE | The interest rate for a security held to maturity. |

MDURATION | The modified duration for a security that pays interest periodically. |

ODDFPRICE | The price per $100 face value of a security with an odd first period. |

ODDFYIELD | The yield of a security with an odd first period. |

ODDLPRICE | The price per $100 face value of a security with an odd last period. |

ODDLYIELD | The yield of a security with an odd last period. |

PRICE | The price of a security that pays periodic interest. |

PRICEDISC | The price of a discounted security (no interest payments). |

PRICEMAT | The price of a security that pays interest at maturity. |

RECEIVED | The amount received at the end when a security is held to maturity. |

YIELD | The interest rate (annual) for a series of equal cash flows at regular intervals. |

YIELDDISC | The interest rate (annual) for a discounted security (no interest payments). |

YIELDMAT | The interest rate (annual) for a security that pays interest at maturity. |

YEARFRAC | The number of years as a decimal between two dates. |

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