TBILLYIELD
TBILLYIELD ( settlement , maturity , pr )
Description: Computes the yield for a U.S. Treasury bill.
Mathematical Formula:
where:
DSM = number of days from settlement to maturity, excluding any maturity date that is more than one calendar year after the settlement date.
Arguments:
Name |
Type |
Description |
|---|---|---|
settlement |
number |
The Treasury bill's settlement date. Any time information in the date is ignored. |
maturity |
number |
The Treasury bill's maturity date. Any time information in the date is ignored. |
pr |
number |
The Treasury bill's price per $100 face value. |
Return Type and Value: number – The yield for a U.S. Treasury bill.
However, if
settlement or maturity is out of range for the current date base value,
#NUM!is returned.settlement > maturity,
#NUM!is returned.maturity is more than one year after settlement,
#NUM!is returned.pr ≤ 0,
#NUM!is returned.