List of Functions


Generalized Cash Flow Analysis
convex cash flow convexity
durat cash flow duration
futv future value
irate internal rate of return
mdietz* modified Dietz portfolio return
mwr* money-weighted portfolio return
netpv net present value
scmarg floating rate scenario margin
twr* time-weighted portfolio return
*in beta test


Amortization and Annuity
amaint accumulated interest after n payments
amint periodic interest rate
ampmt periodic payment
ampmti interest component of nth periodic payment
ampmtp principal component of nth periodic payment
amprn initial principal
amres residual or balloon payment
amrprn principal remaining after n payments
amterm time length in periods
amwal weighted average life


Foreign Exchange Functions
deporate1 implied Eurodeposit rate for first currency
deporate2 implied Eurodeposit rate for second currency
sfwdrate forward rate offer or bid for forward rate agreement
swappt implied forward offer or bid swap points


General Mathematics
binorm cumulative bivariate normal distribution function
binormdens bivariate normal density function
comb combinations, number of unordered subsets
csplint cubic spline interpolation
cubinterp cubic and log-cubic interpolation
fib nth term of Fibonacci sequence
gcd greatest common denominator
lcm least common multiple
linterp linear interpolation and extrapolation
linterp2d 2D linear interpolation
mdet determinant of a matrix
perm permutations, number of ordered subsets

Financial @nalyst also comes with TechHackers' date, business date, and conversion functions.