Re: AccrInt

2001-02-05 Thread Jody Goldberg
On Mon, Jan 29, 2001 at 11:26:38AM -0600, John Hasler wrote: > Phillip J Shelton writes: > > I don't intend to un-Excel clone gnumeric. If the spreadsheet functions > > need errors coded in then that is what has to happen. > > Then I will neither use nor recommend gnumeric. I have no objection

Re: AccrInt

2001-02-05 Thread John Hasler
Phillip J Shelton wrote: > I don't intend to un-Excel clone gnumeric. If the spreadsheet functions > need errors coded in then that is what has to happen. On Mon, Jan 29, 2001 at 11:26:38AM -0600 I wrote: > Then I will neither use nor recommend gnumeric. I have no objection to > bug-for-bug co

Re: AccrInt

2001-01-29 Thread John Hasler
Phillip J Shelton writes: > I don't intend to un-Excel clone gnumeric. If the spreadsheet functions > need errors coded in then that is what has to happen. Then I will neither use nor recommend gnumeric. I have no objection to bug-for-bug compatibility as a _option_, but deliberately coding bug

Re: AccrInt

2001-01-29 Thread Jody Goldberg
On Sun, Jan 28, 2001 at 09:14:12PM -0500, James R. Van Zandt wrote: > > I would much prefer that both compatible and correct versions be > implemented. There are two distinct questions. 1) replicate poor function interfaces 2) replicate calculation errors The former is a partial requirem

Re: AccrInt

2001-01-29 Thread James R. Van Zandt
Phillip J Shelton <[EMAIL PROTECTED]> writes: >"John S. Dey" wrote: >> Its been brought up before on the gnumeric mailing list, that if, in >> fact, errors are detected in Excel, what should the gnumeric >> implementation do? This is an issue that probably has already been >> addressed so for w

RE: AccrInt

2001-01-28 Thread Phillip Shelton
> -Original Message- > > I would much prefer that both compatible and correct versions be > > implemented. > There are two distinct questions. > 1) replicate poor function interfaces > 2) replicate calculation errors > The former is a partial requirement. We have no interest in th

Re: AccrInt

2001-01-26 Thread Phillip J Shelton
"John S. Dey" wrote: > Phillip: I went back and read the documentation for the MS Excel's > ACCRINT function. They refer to a concept of quasi-coupon periods > occurring between "issue" and "settlement". Oh. I see I will have to find a co

Re: AccrInt

2001-01-24 Thread Phillip J Shelton
ys for Government Bonds. Income bonds, bonds in default and zero-coupon bonds trade without accrued interest. > > > > Here is the function definition as gnumeric has it. > > >    N_("@FUNCTION=ACCRINT\n" > >    "@SYNTAX=ACCRINT(issue,first_

AccrInt

2001-01-23 Thread Phillip J Shelton
month for corporate bonds and municipal bonds, and on   actual-calendar-days for Government Bonds. Income bonds, bonds in default and zero-coupon bonds trade without accrued interest. Here is the function definition as gnumeric has it.    N_("@FUNCTION=ACCRINT\n"  

accrint (Financial library)

2001-01-18 Thread Phillip J Shelton
This is the description of the function accrint FUNCTION=ACCRINT SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis) DESCRIPTION    ACCRINT calculates the accrued interest for a security that pays periodic interest.  The  rate is the annual rate of the security and par is