summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/scalc/01/04060118.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060118.xhp')
-rw-r--r--helpcontent2/source/text/scalc/01/04060118.xhp40
1 files changed, 20 insertions, 20 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060118.xhp b/helpcontent2/source/text/scalc/01/04060118.xhp
index 5983f5d76c..a0efc2347d 100644
--- a/helpcontent2/source/text/scalc/01/04060118.xhp
+++ b/helpcontent2/source/text/scalc/01/04060118.xhp
@@ -44,7 +44,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3145112"><bookmark_value>ODDFPRICE function</bookmark_value>
<bookmark_value>prices;securities with irregular first interest date</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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -70,7 +70,7 @@
<section id="oddfyield">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -96,7 +96,7 @@
<section id="oddlprice">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -124,7 +124,7 @@
<section id="oddlyield">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -154,7 +154,7 @@
<bookmark_value>depreciations;variable declining</bookmark_value>
<bookmark_value>VDB function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VDB" id="bm_id3145624" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VDB" id="bm_id3145624" localize="false"/>
<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="2" oldref="222">VDB</paragraph>
<paragraph role="paragraph" id="par_id3154636" xml-lang="en-US" l10n="U" oldref="223"><ahelp hid="HID_FUNC_VDB">Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3155519" xml-lang="en-US" level="3" l10n="U" oldref="224">Syntax</paragraph>
@@ -186,7 +186,7 @@
<bookmark_value>internal rates of return;irregular payments</bookmark_value>
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -293,7 +293,7 @@
<section id="xnpv">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -312,7 +312,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3148822"><bookmark_value>calculating;rates of return</bookmark_value>
<bookmark_value>RRI function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZGZ" id="bm_id3146996" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZGZ" id="bm_id3146996" localize="false"/>
<paragraph role="heading" id="hd_id3148822" xml-lang="en-US" level="2" oldref="237">RRI</paragraph>
<paragraph role="paragraph" id="par_id3154293" xml-lang="en-US" l10n="U" oldref="238"><ahelp hid="HID_FUNC_ZGZ">Calculates the interest rate resulting from the profit (return) of an investment.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3148444" xml-lang="en-US" level="3" l10n="U" oldref="239">Syntax</paragraph>
@@ -334,7 +334,7 @@
<bookmark_value>constant interest rates</bookmark_value>
<bookmark_value>RATE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZINS" id="bm_id3153581" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZINS" id="bm_id3153581" localize="false"/>
<paragraph role="heading" id="hd_id3154267" xml-lang="en-US" level="2" oldref="249">RATE</paragraph>
<paragraph role="paragraph" id="par_id3151052" xml-lang="en-US" l10n="U" oldref="250"><ahelp hid="HID_FUNC_ZINS">Returns the constant interest rate per period of an annuity.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3154272" xml-lang="en-US" level="3" l10n="U" oldref="251">Syntax</paragraph>
@@ -362,7 +362,7 @@
<section id="intrate">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -383,7 +383,7 @@
<section id="coupncd">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -402,7 +402,7 @@
<section id="coupdays">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -421,7 +421,7 @@
<section id="coupdaysnc">
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -442,7 +442,7 @@
<bookmark_value>durations;first interest payment until settlement date</bookmark_value>
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -462,7 +462,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3152957"><bookmark_value>COUPPCD function</bookmark_value>
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -482,7 +482,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3150673"><bookmark_value>COUPNUM function</bookmark_value>
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -502,7 +502,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149339"><bookmark_value>IPMT function</bookmark_value>
<bookmark_value>periodic amortizement rates</bookmark_value>
</bookmark><comment>mw added "periodic..."</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZINSZ" id="bm_id3149737" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZINSZ" id="bm_id3149737" localize="false"/>
<paragraph role="heading" id="hd_id3149339" xml-lang="en-US" level="2" oldref="263">IPMT</paragraph>
<paragraph role="paragraph" id="par_id3154522" xml-lang="en-US" l10n="U" oldref="264"><ahelp hid="HID_FUNC_ZINSZ">Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3153266" xml-lang="en-US" level="3" l10n="U" oldref="265">Syntax</paragraph>
@@ -529,7 +529,7 @@
<bookmark_value>future values;constant interest rates</bookmark_value>
<bookmark_value>FV function</bookmark_value>
</bookmark><comment>mw made "future values..." a two level entry</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZW" id="bm_id3156049" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZW" id="bm_id3156049" localize="false"/>
<paragraph role="heading" id="hd_id3151205" xml-lang="en-US" level="2" oldref="277">FV</paragraph>
<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US" l10n="U" oldref="278"><ahelp hid="HID_FUNC_ZW">Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</ahelp></paragraph>
<paragraph role="heading" id="hd_id3155178" xml-lang="en-US" level="3" l10n="U" oldref="279">Syntax</paragraph>
@@ -556,7 +556,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3155912"><bookmark_value>FVSCHEDULE function</bookmark_value>
<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"/>
+<bookmark xml-lang="en-US" branch="hid/SC_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>
<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>
@@ -576,7 +576,7 @@
<bookmark_value>number of payment periods</bookmark_value>
<bookmark_value>NPER function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZZR" id="bm_id3154917" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZZR" id="bm_id3154917" localize="false"/>
<paragraph role="heading" id="hd_id3156435" xml-lang="en-US" level="2" oldref="290">NPER</paragraph>
<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US" l10n="U" oldref="291"><ahelp hid="HID_FUNC_ZZR">Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3147216" xml-lang="en-US" level="3" l10n="U" oldref="292">Syntax</paragraph>