[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Tbillprice function in kspread - my understanding, but ...
From:       <a.celli () infinito ! it>
Date:       2003-07-28 21:32:25
[Download RAW message or body]

I wrote:

| I'm translating Kspread.po and i found some trouble to 
understand what
| tbillprice and tbillyield actually do.
| For my naif approach they seem wrong !
| 
| To explain the problem I'll report messages describing 
these functions
| 
| The TBILLPRICE functions returns the price per $100 
value for a treasury 
| bill. The maturity date must be after the settlement 
date but within 365 
| days. The discount rate must be positive.
| TBILLPRICE(settlement; maturity; discount):
| TBILLPRICE(\"2/28/2001\"; \"8/31/2001\"; 200) returns 
-10122.22
......................
| Then i looked for more realistic examples and i found
| http://www.mtsu.edu/~dgraddy/webda9.htm
|                
|.....................................

A good way to find solution is to expose the problem to 
other
persons :-)

To obtain fair values it's necessary to write discount 
rate in the 
"correct" way

TBILLPRICE("8/8/96";"11/7/96";5.08) returns a negative 
price
TBILLPRICE("8/8/96";"11/7/96";5.08%) returns error
TBILLPRICE("8/8/96";"11/7/96";0.0508) returns right result 
:-))

At this point, i'd suggest to modify messages to explain 
the 
non trivial way the use has to enter the discount rate.

It'd be fine to allow writing discount rate in the form 
"5.08%"

The current example is ever more "unrealistic": it's based 
on
a 20000% discount rate  :-0

bye, Andrea Celli

La tua casella email ti va stretta?
Prova Infinito XmaiL: 60MB di spazio
e 10MB di allegati a solo 1 Euro al mese!

http://www.infinito.it/xmail

_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]