TRY NEW VERSION

INTRATE

INTRATE(arg1, arg2, arg3, arg4, arg5) → { number | string | boolean }

Returns the interest rate for a fully invested security.

Parameters:

Name Type Description
arg1 any

Is the security's settlement date, expressed as a serial date number.

arg2 any

Is the security's maturity date, expressed as a serial date number.

arg3 any

Is the amount invested in the security.

arg4 any

Is the amount to be received at maturity.

arg5 any

Is the type of day count basis to use.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.INTRATE("1/1/2018", "11/12/2018", 1000, 1050, 2));
builder.SaveFile("xlsx", "INTRATE.xlsx");
builder.CloseFile();

Resulting document