Calculates the price of a US Treasury Bill based on discount rate.
TBILLPRICE(DATE(2010,1,2), DATE(2010,12,31), .0125)
TBILLPRICE(settlement, maturity, discount)
settlement- The settlement date of the security, the date after issuance when the security is delivered to the buyer.
maturity- The maturity or end date of the security, when it can be redeemed at face or par value.
discount- The discount rate of the bill at time of purchase.
maturityshould be entered using
TO_DATEor other date parsing functions rather than by entering text.
TBILLPRICEis equivalent to using
PRICEDISCwith US Treasury Bill conventions for the absent parameters.
maturitymust be one year or less from the
discountis a percentage and must be entered as a positive number from zero to one.
TBILLYIELD: Calculates the yield of a US Treasury Bill based on price.
PRICEDISC: Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
PRICE: Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.