how do we calculate T-bill Price in 365 days year.

A

ASHAR ZUKA FAROOQI

In Pakistan we calculate T- bill Prices on the basis of 365 yaers a day. In
the formual of T-bill Price the basis of 360 days a year. So we found an
error of calculation. Please advice me.
Regards
 
A

Andy Wiggins

According to the Help file, the formula to calculate TBILLPRICE is:
100*(1-discount%*(Maturity Date - Settlement Date)/360).
Use this instead of the provided function and change 360 to 365.
 
A

Andy Wiggins

Which method would be faster? One using raw Excel, or one going through an
addin function? Obviously it would depend on the user's needs.
 
Top