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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top