How can we help?
Calculates the price of a US Treasury Bill based on discount rate.
TBILLPRICE(DATE(2010,1,2), DATE(2010,12,31), 1.25)
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.
maturity should be entered using
TO_DATE or other date parsing functions rather than by entering text.
TBILLPRICE is equivalent to using
PRICEDISC with US Treasury Bill conventions for the absent parameters.
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.