next up previous contents index
Next: INVDFT Up: A. Function Reference Previous: INTERP3D   Contents   Index


INTRATE

Syntax: INTRATE(S, M, I, R[, B])

S = Settlement date, date of purchase
M = Maturity date
I = Investment amount
R = Redemption amount
B = (Optional) Day count basis as follows:

0 or omitted 30/360
1 Actual/actual
2 Actual/360
3 Actual/365

INTRATE returns the interest rate for a fully invested investment.

Example:

INTRATE(DATE(93, 1, 15), DATE(93, 6, 15), 10000, 10545) = 0.1317

Excel function: N/A


next up previous contents index
Next: INVDFT Up: A. Function Reference Previous: INTERP3D   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003