source/text/scalc/01/func_opt_barrier.xhp | 7 +++++--
source/text/scalc/01/func_opt_prob_hit.xhp | 7 +++++--
source/text/scalc/01/func_opt_prob_inmoney.xhp | 7 +++++--
source/text/scalc/01/func_opt_touch.xhp | 7 +++++--
4 files changed, 20 insertions(+), 8 deletions(-)
New commits:
commit 816284668c5fece9eaa275fb94899e8d57e2e502
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Jan 3 11:55:50 2022 -0300
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Tue Jan 4 01:56:16 2022 +0100
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 <er...@redhat.com>
diff --git a/source/text/scalc/01/func_opt_barrier.xhp
b/source/text/scalc/01/func_opt_barrier.xhp
index 7038d2278..3c9b23401 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 fd2f6477b..3737e6c7c 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 66b939432..c5a6cab98 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 a71c2a087..9abb0c37b 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"/>
