accrint bug?

J

jack

accrint("1993/1/26","1993/8/27","1993/1/28",0.1,40,4,4)
=0.022222222
accrint("1993/1/26","1993/8/28","1993/1/28",0.1,40,4,4)
=0.022222222
accrint("1993/1/26","1993/8/29","1993/1/28",0.1,40,4,4)
=0.011111111
accrint("1993/1/26","1993/8/30","1993/1/28",0.1,40,4,4)
=-5.55112E-17
accrint("1993/1/26","1993/8/31","1993/1/28",0.1,40,4,4)
=0.008080808
accrint("1993/1/26","1993/9/01","1993/1/28",0.1,40,4,4)
=0.022222222
accrint("1993/1/26","1993/9/02","1993/1/28",0.1,40,4,4)
=0.022222222

I think all the results should be 0.022222222,
who can explain the result for me?
thanks very much!
 
N

Norman Harker

Hi Jack!

It seems that there is are two bugs here. One relates to the basis
used and the second relates to your data.

But there does appear to be some problems with the reality of the data
that you are using. With an issue date of 1996-1-26 and quarterly
interest payments you have the first interest payment date some 7
months after issue. I can't think that this would be the case with
normal bond issues.

I think I'd be more concerned with establishing that the data is real
first and then to see if you get problems with such data.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top