accrint()

[chengj]

Last month I sent a post here for the function accrint().
But I didn't resolve it. Then I　was sent to another
project team, so I put this problem down.
Now I am back and continue with this problem.
EX :

########################################################
ACCRINT("39507","39691","39569",0.1,1000,2,2)=17.222222222
BUT:
ACCRINT("39507","39691","39569",0.1,1000,4,2)=16.666666667
39507---"2008-2-29"
39691---"2008-8-31"
39569---"2008-5-1"
As you see, when "Frequency"=4 the result is smaller.
#########################################################

I think Excel set the number of day as 60 when "Frequency"
= 4(but it is 62 when "Frequency" = 2)

Anyone who know the reason ,please save me!

It is very important for me
Thank you!!

 

[Harlan Grove]

Last month I sent a post here for the function accrint().
But I didn't resolve it. Then I　was sent to another
project team, so I put this problem down.
Now I am back and continue with this problem.
EX :

########################################################
ACCRINT("39507","39691","39569",0.1,1000,2,2)=17.222222222
BUT:
ACCRINT("39507","39691","39569",0.1,1000,4,2)=16.666666667
39507---"2008-2-29"
39691---"2008-8-31"
39569---"2008-5-1"
As you see, when "Frequency"=4 the result is smaller.
#########################################################

...

The first argument to ACCRINT is the security's date of issue. The second
argument to ACCRINT is the date of the security's first interest payment. If
your frequency is 2, then it makes sense that the first interest payment is 6
months after the issue date, but the 6 month period between issuance and first
interest payment doesn't make sense when frequency is 4. If the second formula
used 31-May-2008 as the first interest payment date, the formula

=ACCRINT("2008-2-29","2008-5-31","2008-5-1",0.1,1000,4,2)

returns 17.22222222. So, your problem with the second ACCRINT call above is due
to the first interest payment date being inconsistent with the frequency of
interest payments. Garbage in, garbage out.

 

[Fred Smith]

You had several answers to your original post. Just do a google search of
the newsgroup, and you'll find them.