summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKurt Zenker <kz@openoffice.org>2008-03-07 11:07:24 +0000
committerKurt Zenker <kz@openoffice.org>2008-03-07 11:07:24 +0000
commit9d8bc6525ad4fc929b97803f6552ff47db238561 (patch)
tree8bd4e488e0be6765e566b80b303ff5273a4cdcaf
parente6004956def51160b6a6f7576d387aa846af447f (diff)
INTEGRATION: CWS hcshared17_DEV300 (1.8.2); FILE MERGED
2008/03/04 15:23:56 ufi 1.8.2.1: vor build
-rw-r--r--helpcontent2/source/text/scalc/01/04060118.xhp18
1 files changed, 2 insertions, 16 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060118.xhp b/helpcontent2/source/text/scalc/01/04060118.xhp
index ea3982c42d..0347883e48 100644
--- a/helpcontent2/source/text/scalc/01/04060118.xhp
+++ b/helpcontent2/source/text/scalc/01/04060118.xhp
@@ -7,9 +7,9 @@
*
* $RCSfile: 04060118.xhp,v $fileonly,v $
*
- * $Revision: 1.8 $
+ * $Revision: 1.9 $
*
- * last change: $Author: rt $ $Date: 2008-02-19 22:13:12 $
+ * last change: $Author: kz $ $Date: 2008-03-07 12:07:24 $
*
* The Contents of this file are made available subject to
* the terms of GNU Lesser General Public License Version 2.1.
@@ -53,7 +53,6 @@
<bookmark_value>prices;securities with irregular first interest rate</bookmark_value>
</bookmark><comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ODDFPRICE" id="bm_id3146107" localize="false"/><paragraph role="heading" id="hd_id3145112" xml-lang="en-US" level="2" oldref="71">ODDFPRICE</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3147250" xml-lang="en-US" l10n="U" oldref="72"><ahelp hid="HID_AAI_FUNC_ODDFPRICE">Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3153074" xml-lang="en-US" level="3" l10n="U" oldref="73">Syntax</paragraph>
<paragraph role="code" id="par_id3146098" xml-lang="en-US" l10n="U" oldref="74">ODDFPRICE(Settlement; Maturity; Issue; FirstCoupon; Rate; Yield; Redemption; Frequency; Basis)</paragraph>
@@ -79,7 +78,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3157871"><bookmark_value>ODDFYIELD function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ODDFYIELD" id="bm_id3149723" localize="false"/><paragraph role="heading" id="hd_id3157871" xml-lang="en-US" level="2" oldref="87">ODDFYIELD</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3147414" xml-lang="en-US" l10n="U" oldref="88"><ahelp hid="HID_AAI_FUNC_ODDFYIELD">Calculates the yield of a security if the first interest date falls irregularly.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3150651" xml-lang="en-US" level="3" l10n="U" oldref="89">Syntax</paragraph>
<paragraph role="code" id="par_id3152982" xml-lang="en-US" l10n="U" oldref="90">ODDFYIELD(Settlement; Maturity; Issue; FirstCoupon; Rate; Price; Redemption; Frequency; Basis)</paragraph>
@@ -105,7 +103,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>ODDLPRICE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ODDLPRICE" id="bm_id3145596" localize="false"/><paragraph role="heading" id="hd_id3153933" xml-lang="en-US" level="2" oldref="103">ODDLPRICE</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3145145" xml-lang="en-US" l10n="U" oldref="104"><ahelp hid="HID_AAI_FUNC_ODDLPRICE">Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3152784" xml-lang="en-US" level="3" l10n="U" oldref="105">Syntax</paragraph>
<paragraph role="code" id="par_id3155262" xml-lang="en-US" l10n="U" oldref="106">ODDLPRICE(Settlement; Maturity; LastInterest; Rate; Yield; Redemption; Frequency; Basis)</paragraph>
@@ -133,7 +130,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3153564"><bookmark_value>ODDLYIELD function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ODDLYIELD" id="bm_id3153732" localize="false"/><paragraph role="heading" id="hd_id3153564" xml-lang="en-US" level="2" oldref="118">ODDLYIELD</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3158002" xml-lang="en-US" l10n="U" oldref="119"><ahelp hid="HID_AAI_FUNC_ODDLYIELD">Calculates the yield of a security if the last interest date falls irregularly.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3147366" xml-lang="en-US" level="3" l10n="U" oldref="120">Syntax</paragraph>
<paragraph role="code" id="par_id3150018" xml-lang="en-US" l10n="U" oldref="121">ODDLYIELD(Settlement; Maturity; LastInterest; Rate; Price; Redemption; Frequency; Basis)</paragraph>
@@ -194,7 +190,6 @@
<bookmark_value>XIRR function</bookmark_value>
</bookmark><comment>mw changed "calculating;..." and "internal rates of return"</comment>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_XIRR" id="bm_id3083443" localize="false"/><paragraph role="heading" id="hd_id3147485" xml-lang="en-US" level="2" oldref="193">XIRR</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3145614" xml-lang="en-US" l10n="U" oldref="194"><ahelp hid="HID_AAI_FUNC_XIRR">Calculates the internal rate of return for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years.</paragraph>
<paragraph role="paragraph" id="par_idN10E62" xml-lang="en-US">If the payments take place at regular intervals, use the IRR function.</paragraph>
<paragraph role="heading" id="hd_id3146149" xml-lang="en-US" level="3" l10n="U" oldref="195">Syntax</paragraph>
@@ -296,7 +291,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149198"><bookmark_value>XNPV function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_XNPV" id="bm_id3151172" localize="false"/><paragraph role="heading" id="hd_id3149198" xml-lang="en-US" level="2" oldref="213">XNPV</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3153904" xml-lang="en-US" l10n="U" oldref="214"><ahelp hid="HID_AAI_FUNC_XNPV">Calculates the capital value (net present value)for a list of payments which take place on different dates.</ahelp> The calculation is based on a 365 days per year basis, ignoring leap years.</paragraph>
<paragraph role="paragraph" id="par_idN11138" xml-lang="en-US">If the payments take place at regular intervals, use the NPV function.</paragraph>
<paragraph role="heading" id="hd_id3155323" xml-lang="en-US" level="3" l10n="U" oldref="215">Syntax</paragraph>
@@ -363,7 +357,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149106"><bookmark_value>INTRATE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_INTRATE" id="bm_id3152944" localize="false"/><paragraph role="heading" id="hd_id3149106" xml-lang="en-US" level="2" oldref="60">INTRATE</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3149918" xml-lang="en-US" l10n="U" oldref="61"><ahelp hid="HID_AAI_FUNC_INTRATE">Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3149974" xml-lang="en-US" level="3" l10n="U" oldref="62">Syntax</paragraph>
<paragraph role="code" id="par_id3149800" xml-lang="en-US" l10n="U" oldref="63">INTRATE(Settlement; Maturity; Investment; Redemption; Basis)</paragraph>
@@ -384,7 +377,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3148654"><bookmark_value>COUPNCD function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COUPNCD" id="bm_id3148413" localize="false"/><paragraph role="heading" id="hd_id3148654" xml-lang="en-US" level="2" oldref="163">COUPNCD</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3149927" xml-lang="en-US" l10n="U" oldref="164"><ahelp hid="HID_AAI_FUNC_COUPNCD">Returns the date of the first interest date after the settlement date. Format the result as a date.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3153317" xml-lang="en-US" level="3" l10n="U" oldref="165">Syntax</paragraph>
<paragraph role="code" id="par_id3150423" xml-lang="en-US" l10n="U" oldref="166">COUPNCD(Settlement; Maturity; Frequency; Basis)</paragraph>
@@ -403,7 +395,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3143281"><bookmark_value>COUPDAYS function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COUPDAYS" id="bm_id3144759" localize="false"/><paragraph role="heading" id="hd_id3143281" xml-lang="en-US" level="2" oldref="143">COUPDAYS</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3149488" xml-lang="en-US" l10n="U" oldref="144"><ahelp hid="HID_AAI_FUNC_COUPDAYS">Returns the number of days in the current interest period in which the settlement date falls.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3148685" xml-lang="en-US" level="3" l10n="U" oldref="145">Syntax</paragraph>
<paragraph role="code" id="par_id3149585" xml-lang="en-US" l10n="U" oldref="146">COUPDAYS(Settlement; Maturity; Frequency; Basis)</paragraph>
@@ -422,7 +413,6 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154832"><bookmark_value>COUPDAYSNC function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COUPDAYSNC" id="bm_id3150941" localize="false"/><paragraph role="heading" id="hd_id3154832" xml-lang="en-US" level="2" oldref="153">COUPDAYSNC</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3147100" xml-lang="en-US" l10n="U" oldref="154"><ahelp hid="HID_AAI_FUNC_COUPDAYSNC">Returns the number of days from the settlement date until the next interest date.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3151312" xml-lang="en-US" level="3" l10n="U" oldref="155">Syntax</paragraph>
<paragraph role="code" id="par_id3155121" xml-lang="en-US" l10n="U" oldref="156">COUPDAYSNC(Settlement; Maturity; Frequency; Basis)</paragraph>
@@ -443,7 +433,6 @@
<bookmark_value>securities;first interest payment until settlement date</bookmark_value>
</bookmark><comment>mw added "durations;" and "securities;"</comment>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COUPDAYBS" id="bm_id3153775" localize="false"/><paragraph role="heading" id="hd_id3150408" xml-lang="en-US" level="2" oldref="133">COUPDAYBS</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3146795" xml-lang="en-US" l10n="U" oldref="134"><ahelp hid="HID_AAI_FUNC_COUPDAYBS">Returns the number of days from the first day of interest payment on a security until the settlement date.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3156142" xml-lang="en-US" level="3" l10n="U" oldref="135">Syntax</paragraph>
<paragraph role="code" id="par_id3159083" xml-lang="en-US" l10n="U" oldref="136">COUPDAYBS(Settlement; Maturity; Frequency; Basis)</paragraph>
@@ -463,7 +452,6 @@
<bookmark_value>dates;interest date prior to settlement date</bookmark_value>
</bookmark><comment>mw added "dates;"</comment>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COUPPCD" id="bm_id3149553" localize="false"/><paragraph role="heading" id="hd_id3152957" xml-lang="en-US" level="2" oldref="183">COUPPCD</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3153678" xml-lang="en-US" l10n="U" oldref="184"><ahelp hid="HID_AAI_FUNC_COUPPCD">Returns the date of the interest date prior to the settlement date. Format the result as a date.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3156269" xml-lang="en-US" level="3" l10n="U" oldref="185">Syntax</paragraph>
<paragraph role="code" id="par_id3153790" xml-lang="en-US" l10n="U" oldref="186">COUPPCD(Settlement; Maturity; Frequency; Basis)</paragraph>
@@ -483,7 +471,6 @@
<bookmark_value>number of coupons</bookmark_value>
</bookmark><comment>mw added "number..."</comment>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COUPNUM" id="bm_id3153348" localize="false"/><paragraph role="heading" id="hd_id3150673" xml-lang="en-US" level="2" oldref="173">COUPNUM</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3154350" xml-lang="en-US" l10n="U" oldref="174"><ahelp hid="HID_AAI_FUNC_COUPNUM">Returns the number of coupons (interest payments) between the settlement date and the maturity date.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3148400" xml-lang="en-US" level="3" l10n="U" oldref="175">Syntax</paragraph>
<paragraph role="code" id="par_id3153200" xml-lang="en-US" l10n="U" oldref="176">COUPNUM(Settlement; Maturity; Frequency; Basis)</paragraph>
@@ -555,7 +542,6 @@
<bookmark_value>future values;varying interest rates</bookmark_value>
</bookmark><comment>mw added "future values"</comment>
<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_FVSCHEDULE" id="bm_id3155341" localize="false"/><paragraph role="heading" id="hd_id3155912" xml-lang="en-US" level="2" oldref="51">FVSCHEDULE</paragraph>
-<embed href="text/shared/00/00000001.xhp#add"/>
<paragraph role="paragraph" id="par_id3163726" xml-lang="en-US" l10n="U" oldref="52"><ahelp hid="HID_AAI_FUNC_FVSCHEDULE">Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3149571" xml-lang="en-US" level="3" l10n="U" oldref="53">Syntax</paragraph>
<paragraph role="code" id="par_id3148891" xml-lang="en-US" l10n="U" oldref="54">FVSCHEDULE(Principal; Schedule)</paragraph>