Determines the final coupon or interest payment date preceding the settlement date.
Determines the upcoming coupon or interest payment date following the settlement date.
Determines the accrued interest for a security that pays its interest upon maturity.
Determines the interest accumulated on a security that has recurring payments.
Provides unique rows from the given source range while eliminating duplicates. The rows appear in the same order as they first occurred in the source range.
Returns the initial n entries of a dataset following a sorting operation.
Calculates the tangent of a specified complex number.
Calculates the sine of a specified complex number.
Calculates the hyperbolic secant of a specified complex number. For instance, providing a complex number in the form “x+yi” will yield “sech(x+yi)” as the result.
Calculates the cosecant of a specified complex number.