BillPrice() function  Previous topicNext topicFirst topicLast topic

BillPrice() function

BillPrice(argument list…)

This function returns the price per $100 par of a discount money market security such as a Treasury bill. The function uses the following arguments:

Argument Description Restrictions
Settlement_Date bill settlement date valid Excel date number
Maturity_Date bill maturity date valid Excel date number
>= Settlement_Date
Yield money market yield of the bill in decimal form (e.g. six percent entered as 0.06) > 0
Year_Basis days per year for calculations 360 or 365

© 1995-98 Leap of Faith Research Inc.