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

List:       koffice-devel
Subject:    TBILLPRICE example in kspread.po
From:       a.celli () jumpy ! it
Date:       2003-07-30 20:49:00
[Download RAW message or body]

I'd suggest to modify the example relative to TBILLPRICE 
It is absolutely crazy and confusing

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

This means I'll pay a negative price (= I'll receive money) to buy the right
to receive 100$ after 6 months.  I'll receive 10,222.22$ for free.

The problem is that "200" as third argument means a 20000%
discount rate. :-0

Then I suggest a more realistic 5% discount rate giving
TBILLPRICE(\"2/28/2001\"; \"8/31/2001\"; 0.05) returns 97.4444

This is usefull also in order to suggest the non trivial way the
discount rate has to be inserted.

Note. A similar function in OOo accept both "0,05" and "5%"
as format for discount rate.

bye, Andrea Celli

________________________________________
Entra nella nuova chat... potrai avere un nick e un profilo solo tuoi! http://www.jumpy.it/homechat.jsp


_______________________________________________
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]