summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2022-01-03 11:55:50 -0300
committerEike Rathke <erack@redhat.com>2022-01-04 01:56:16 +0100
commit816284668c5fece9eaa275fb94899e8d57e2e502 (patch)
tree985cdbbb62fd872eadb9c222e30622948e538fa4
parentb79052ed393b4e006658816c7e611b7a6ef6b2f6 (diff)
tdf#94537 OPT_* functions help ID's
+ Added reference to not-ODFF + Changed suggested help ID's to match If275d804fc81b535c422a29ba594eb88ce5e70c0 Change-Id: I81664d85d8b589db86a51cecc759580a8086e336 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/127897 Tested-by: Jenkins Reviewed-by: Eike Rathke <erack@redhat.com>
-rw-r--r--source/text/scalc/01/func_opt_barrier.xhp7
-rw-r--r--source/text/scalc/01/func_opt_prob_hit.xhp7
-rw-r--r--source/text/scalc/01/func_opt_prob_inmoney.xhp7
-rw-r--r--source/text/scalc/01/func_opt_touch.xhp7
4 files changed, 20 insertions, 8 deletions
diff --git a/source/text/scalc/01/func_opt_barrier.xhp b/source/text/scalc/01/func_opt_barrier.xhp
index 7038d22782..3c9b234010 100644
--- a/source/text/scalc/01/func_opt_barrier.xhp
+++ b/source/text/scalc/01/func_opt_barrier.xhp
@@ -20,12 +20,11 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id511575065323638">
<bookmark_value>OPT_BARRIER function</bookmark_value>
</bookmark>
- <bookmark id="bm_id941575063871993" xml-lang="en-US" branch="hid/SC_HID_FUNC_OPT_BARRIER" localize="false"/>
+ <bookmark id="bm_id941575063871993" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_BARRIER" localize="false"/>
<h2 id="hd_id241575063871994"><variable id="optbrarrierh1"><link href="text/scalc/01/func_opt_barrier.xhp" name="OPT_BARRIER">OPT_BARRIER</link></variable></h2>
<paragraph id="par_id121575063871995" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable></paragraph>
</section>
<embed href="text/scalc/01/func_opt_touch.xhp#opttip"/>
- <embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id371575067051846">OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring [; Greek])</paragraph>
<paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph>
@@ -44,6 +43,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id651575073773761"><input>=OPT_BARRIER(30;0.2;0.06;0;1;40;25;0;0;"c";"o";"c")</input> returns the value 0.4243.</paragraph>
<paragraph role="paragraph" id="par_id401575073777593"><input>=OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;"p";"o";"c";"e")</input> returns the value 10.1585.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.0"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
diff --git a/source/text/scalc/01/func_opt_prob_hit.xhp b/source/text/scalc/01/func_opt_prob_hit.xhp
index fd2f6477b5..3737e6c7c5 100644
--- a/source/text/scalc/01/func_opt_prob_hit.xhp
+++ b/source/text/scalc/01/func_opt_prob_hit.xhp
@@ -20,7 +20,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id961575074485125">
<bookmark_value>OPT_PROB_HIT function</bookmark_value>
</bookmark>
- <bookmark id="bm_id391575063908362" xml-lang="en-US" branch="hid/SC_HID_FUNC_OPT_PROB_HIT" localize="false"/>
+ <bookmark id="bm_id391575063908362" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_PROB_HIT" localize="false"/>
<h2 id="hd_id71575063908363"><variable id="optprobhith1"><link href="text/scalc/01/func_opt_prob_hit.xhp" name="OPT_PROB_HIT">OPT_PROB_HIT</link></variable></h2>
<paragraph id="par_id591575063908364" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the probability that an asset hits a predetermined barrier price, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows.</paragraph>
<paragraph role="paragraph" id="par_id21575078735992" xml-lang="en-US">
@@ -29,7 +29,6 @@
<paragraph role="paragraph" id="par_id821575074114118"><literal>µ</literal> is the asset’s percentage drift, <literal>vol</literal> is the percentage volatility of the stock, and <literal>dW</literal> is a random sample drawn from a normal distribution with a zero mean. <literal>W</literal> is a Wiener process or Brownian motion.</paragraph>
</section>
<embed href="text/scalc/01/func_opt_touch.xhp#opttip"/>
- <embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id211575074192954">OPT_PROB_HIT(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier)</paragraph>
<paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph>
@@ -42,6 +41,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id971575074431070"><input>=OPT_PROB_HIT(30;0.2;0.3;1;0;40)</input> returns the value 0.6119.</paragraph>
<paragraph role="paragraph" id="par_id171575074434932"><input>=OPT_PROB_HIT(70;0.3;0.1;0.5;60;0)</input> returns the value 0.4239.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.0"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBHIT</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
diff --git a/source/text/scalc/01/func_opt_prob_inmoney.xhp b/source/text/scalc/01/func_opt_prob_inmoney.xhp
index 66b9394320..c5a6cab98b 100644
--- a/source/text/scalc/01/func_opt_prob_inmoney.xhp
+++ b/source/text/scalc/01/func_opt_prob_inmoney.xhp
@@ -20,7 +20,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id961575065633373">
<bookmark_value>OPT_PROB_INMONEY function</bookmark_value>
</bookmark>
- <bookmark id="bm_id971575063929082" xml-lang="en-US" branch="hid/SC_HID_FUNC_OPT_PROB_INMONEY" localize="false"/>
+ <bookmark id="bm_id971575063929082" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_PROB_INMONEY" localize="false"/>
<h2 id="hd_id941575063929082"><variable id="optprobinmoneyh1"><link href="text/scalc/01/func_opt_prob_inmoney.xhp" name="OPT_PROB_INMONEY">OPT_PROB_INMONEY</link></variable></h2>
<paragraph id="par_id941575063929083" role="paragraph" xml-lang="en-US"><variable id="variable name"><ahelp hid=".">Returns the probability that an asset will end up between two barrier levels at maturity, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows.</paragraph>
<paragraph role="paragraph" id="par_id21575078735992" xml-lang="en-US">
@@ -39,7 +39,6 @@
<paragraph role="paragraph" id="par_id191575075304900">The function ignores the possibility of knock-out before maturity.</paragraph>
</section>
<embed href="text/scalc/01/func_opt_touch.xhp#opttip"/>
- <embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id761575075027094">OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier [; Strike [; PutCall]])</paragraph>
<paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph>
@@ -51,6 +50,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id601575074993334"><input>=OPT_PROB_INMONEY(30;0.2;0.1;1;0;50)</input> returns the value 0.9844.</paragraph>
<paragraph role="paragraph" id="par_id261575074997216"><input>=OPT_PROB_INMONEY(70;0.3;0.15;1;60;0;80;"p")</input> returns the value 0.3440.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.0"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBINMONEY</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
diff --git a/source/text/scalc/01/func_opt_touch.xhp b/source/text/scalc/01/func_opt_touch.xhp
index a71c2a0879..9abb0c37b6 100644
--- a/source/text/scalc/01/func_opt_touch.xhp
+++ b/source/text/scalc/01/func_opt_touch.xhp
@@ -20,7 +20,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id951575065400504">
<bookmark_value>OPT_TOUCH function</bookmark_value>
</bookmark>
- <bookmark id="bm_id971575062825963" xml-lang="en-US" branch="hid/SC_HID_FUNC_OPT_TOUCH" localize="false"/>
+ <bookmark id="bm_id971575062825963" xml-lang="en-US" branch="hid/SC_HID_PAI_FUNC_OPT_TOUCH" localize="false"/>
<h2 id="hd_id41575062825964"><variable id="opttouchh1"><link href="text/scalc/01/func_opt_touch.xhp" name="function_opt_touch">OPT_TOUCH</link></variable></h2>
<paragraph id="par_id531575062825965" role="paragraph" xml-lang="en-US"><ahelp hid=".">Returns the pricing of a touch / no-touch option, calculated using the Black-Scholes option pricing model.</ahelp></paragraph>
</section>
@@ -28,7 +28,6 @@
<tip id="par_id371575066515276">For relevant background information, visit the <link href="https://en.wikipedia.org/wiki/Option_(finance)" name="optionfinance">Options (finance)</link> and <link href="https://en.wikipedia.org/wiki/Black–Scholes_model" name="blackscholes">Black-Scholes</link> model Wikipedia pages.</tip>
</section>
<paragraph role="paragraph" id="par_id571575080642652">Further information about touch / no-touch options may be found on many financial websites.</paragraph>
- <embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id151575063296819">OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring [; Greek])</paragraph>
@@ -74,6 +73,10 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph role="paragraph" id="par_id181575063666675"><input>=OPT_TOUCH(50;0.25;0.05;0;1;0;55;"d";"i";"c")</input> returns the value 0.6876.</paragraph>
<paragraph role="paragraph" id="par_id811575063677250"><input>=OPT_TOUCH(80;0.2;0.05;0;0.5;60;0;"f";"o";"c";"r")</input> returns the value 15.5516.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/>
+ <embed href="text/scalc/00/avail_release.xhp#4.0"/>
+ <embed href="text/scalc/01/common_func.xhp#notODFF"/>
+ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH</literal></paragraph>
<section id="relatedtopics">
<embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
<embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>