Returns the interest rate for a fully invested security.
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. |
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();