accrint bug?

  • Thread starter Thread starter jack
  • Start date Start date
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!
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top