OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: ODFF: YIELDDISC function


"Summary: Calculate the yield of a discounted security per 100 
currency units of face value."

Suggest:
"Summary: Calculate the yield of a discounted non-interest paying 
security."

or "discounted zero coupon bond", or similar - whatever 
description is used elsewhere.

There is a formula and some notes about YEARFRAC (yuk) and non-
compounding here:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Ca
lc:_YIELDDISC_function

The internal use of YEARFRAC explains:
"OpenOffice.org 2.0 and Excel returns different results to some 
test cases."

D



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]