TBILLYIELD

Returns the yield for a Treasury bill.

Syntax

expression.TBILLYIELD(arg1, arg2, arg3);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName | number		The settlement date of the Treasury bill, expressed as a serial date number.
arg2	Required	ApiRange | ApiName | number		The maturity date of the Treasury bill, expressed as a serial date number.
arg3	Required	ApiRange | ApiName | number		The purchase price of the Treasury bill, per $100 par value.

Returns

number

Example

• Code
• Result

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.TBILLYIELD("2/15/2018", "6/1/2018", 99.5));