From 816284668c5fece9eaa275fb94899e8d57e2e502 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Mon, 3 Jan 2022 11:55:50 -0300 Subject: 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 --- 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(-) (limited to 'source/text') 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 @@ OPT_BARRIER function - +

OPT_BARRIER

Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model. - OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring [; Greek]) @@ -44,6 +43,10 @@ =OPT_BARRIER(30;0.2;0.06;0;1;40;25;0;0;"c";"o";"c") returns the value 0.4243. =OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;"p";"o";"c";"e") returns the value 10.1585. + + + + COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER
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 @@ OPT_PROB_HIT function - +

OPT_PROB_HIT

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, as follows. @@ -29,7 +29,6 @@ µ is the asset’s percentage drift, vol is the percentage volatility of the stock, and dW is a random sample drawn from a normal distribution with a zero mean. W is a Wiener process or Brownian motion.
- OPT_PROB_HIT(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier) @@ -42,6 +41,10 @@ =OPT_PROB_HIT(30;0.2;0.3;1;0;40) returns the value 0.6119. =OPT_PROB_HIT(70;0.3;0.1;0.5;60;0) returns the value 0.4239. + + + + COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBHIT
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 @@ OPT_PROB_INMONEY function - +

OPT_PROB_INMONEY

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, as follows. @@ -39,7 +39,6 @@ The function ignores the possibility of knock-out before maturity.
- OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier [; Strike [; PutCall]]) @@ -51,6 +50,10 @@ =OPT_PROB_INMONEY(30;0.2;0.1;1;0;50) returns the value 0.9844. =OPT_PROB_INMONEY(70;0.3;0.15;1;60;0;80;"p") returns the value 0.3440. + + + + COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBINMONEY
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 @@ OPT_TOUCH function - +

OPT_TOUCH

Returns the pricing of a touch / no-touch option, calculated using the Black-Scholes option pricing model.
@@ -28,7 +28,6 @@ For relevant background information, visit the Options (finance) and Black-Scholes model Wikipedia pages. Further information about touch / no-touch options may be found on many financial websites. - OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring [; Greek]) @@ -74,6 +73,10 @@ =OPT_TOUCH(50;0.25;0.05;0;1;0;55;"d";"i";"c") returns the value 0.6876. =OPT_TOUCH(80;0.2;0.05;0;0.5;60;0;"f";"o";"c";"r") returns the value 15.5516. + + + + COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH
-- cgit