TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

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