| BillDisc() function | |
BillDisc() functionBillDisc(argument list…)
This function returns the money market discount rate of a discount money market security such as a Treasury bill given price. 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 |
| Price | bill price per $100 par | > 0 |
| Redemption | redemption value per $100 par | > 0 |
| DCB | day count basis | 0 = 30/360 (US) 1 = act/act for CAD/US T-Bonds 2 = act/360 3 = act/365 4 = 30/360 (European) |
© 1995-98 Leap of Faith Research Inc.