| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do we calculate T-bill Price in 365 days year.
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 |
|
#2
|
|||
|
|||
|
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. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "ASHAR ZUKA FAROOQI" <ASHAR ZUKA wrote in message ... 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 |
|
#3
|
|||
|
|||
|
So you could also use =TBILLPRICE(....)*360/365
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andy Wiggins" wrote in message ... 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. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "ASHAR ZUKA FAROOQI" <ASHAR ZUKA wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Bernard Liengme" wrote in message ... So you could also use =TBILLPRICE(....)*360/365 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andy Wiggins" wrote in message ... 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. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "ASHAR ZUKA FAROOQI" <ASHAR ZUKA wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate principal payed in one year in excel | New Users to Excel | |||
| days in a year | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
| HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions | |||
Linear Mode
