diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-01-03 11:55:50 -0300 |
---|---|---|
committer | Eike Rathke <erack@redhat.com> | 2022-01-04 01:56:16 +0100 |
commit | 816284668c5fece9eaa275fb94899e8d57e2e502 (patch) | |
tree | 985cdbbb62fd872eadb9c222e30622948e538fa4 | |
parent | b79052ed393b4e006658816c7e611b7a6ef6b2f6 (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.xhp | 7 | ||||
-rw-r--r-- | source/text/scalc/01/func_opt_prob_hit.xhp | 7 | ||||
-rw-r--r-- | source/text/scalc/01/func_opt_prob_inmoney.xhp | 7 | ||||
-rw-r--r-- | source/text/scalc/01/func_opt_touch.xhp | 7 |
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"/> |