INTRATE
Category: Financial Function.
Description: Returns the interest rate for a fully invested security.
Syntax: INTRATE(settlement, maturity, investment, redemption, [basis])
The INTRATE function syntax has the following arguments:
Settlement: security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
Maturity: security's maturity date. The maturity date is the date when the security expires.
Investment: amount invested in the security.
Redemption: amount to be received at maturity.
Basis: type of day count basis to use.