!settlement,maturity,coupon,yld,frequency,basis!!Returns the annual duration of a security with periodic interest payments!is the security's settlement date, expressed as a serial date number!is the security's maturity date, expressed as a serial date number!is the security's annual coupon rate!is the security's annual yield!is the number of coupon payments per year!is the type of day count basis to use!
serial_number!Returns the year of a date, an integer in the range 1900 - 9999.!is a number in the date-time code used by ...
serial_number,return_type!Returns a number from 1 to 7 identifying the day of the week of a date.!is a number that represents ...
serial_number,return_type!Returns the week number in the year!is the date-time code used by Microsoft Excel for date and ...
Series or category information may not have been retained while converting this chart to the latest version. For best results, ...
settlement,maturity,coupon,yld,frequency,basis!Returns the annual duration of a security with periodic interest payments!is ...
settlement,maturity,coupon,yld,frequency,basis!Returns the Macauley modified duration for a security with an assumed par ...
settlement,maturity,discount!Returns the bond-equivalent yield for a treasury bill!is the Treasury bill's settlement date, ...
settlement,maturity,discount!Returns the price per $100 face value for a treasury bill!is the Treasury bill's settlement ...
settlement,maturity,discount,redemption,basis!Returns the price per $100 face value of a discounted security!is the security's ...