[Libreoffice-commits] help.git: AllLangHelp_scalc.mk Package_html_media.mk source/media source/text
Steve Fanning (via logerrit)
logerrit at kemper.freedesktop.org
Sat Nov 30 15:44:52 UTC 2019
AllLangHelp_scalc.mk | 4
Package_html_media.mk | 1
source/media/helpimg/sc_func_opt01.svg | 174 +++++++++++++++++++++++++
source/text/scalc/01/common_func.xhp | 4
source/text/scalc/01/func_opt_barrier.xhp | 55 +++++++
source/text/scalc/01/func_opt_prob_hit.xhp | 53 +++++++
source/text/scalc/01/func_opt_prob_inmoney.xhp | 62 ++++++++
source/text/scalc/01/func_opt_touch.xhp | 89 ++++++++++++
8 files changed, 440 insertions(+), 2 deletions(-)
New commits:
commit d224d5be730b942c59f2942482e6704c9f51e2c3
Author: Steve Fanning <stevemfanning.wh at gmail.com>
AuthorDate: Sat Nov 30 12:14:44 2019 -0300
Commit: Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Sat Nov 30 16:44:27 2019 +0100
tdf#92084 Help Pages for OPT_* Calc functions
Note: The OPT_* functions implemented in release 4.0
have no HID_ defined.
Dummy HID contants were inserted waiting for tdf#129115.
Change-Id: Iac253a86ff8cbf8fd1a222c6326abc7e0c9f4f76
Signed-off-by: Olivier Hallot <olivier.hallot at libreoffice.org>
Reviewed-on: https://gerrit.libreoffice.org/84122
Tested-by: Jenkins
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 538b4ecad..eeca4db24 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -235,6 +235,10 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_workday.intl \
helpcontent2/source/text/scalc/01/func_numbervalue \
helpcontent2/source/text/scalc/01/func_now \
+ helpcontent2/source/text/scalc/01/func_opt_barrier \
+ helpcontent2/source/text/scalc/01/func_opt_prob_hit \
+ helpcontent2/source/text/scalc/01/func_opt_prob_inmoney \
+ helpcontent2/source/text/scalc/01/func_opt_touch \
helpcontent2/source/text/scalc/01/func_rawsubtract \
helpcontent2/source/text/scalc/01/func_regex \
helpcontent2/source/text/scalc/01/func_replaceb \
diff --git a/Package_html_media.mk b/Package_html_media.mk
index 8f1c0078e..a9a4625fd 100644
--- a/Package_html_media.mk
+++ b/Package_html_media.mk
@@ -86,6 +86,7 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE
helpimg/sc_func_imsec.png \
helpimg/sc_func_imsech.png \
helpimg/sc_func_imtan.png \
+ helpimg/sc_func_opt01.svg \
helpimg/sd_drawing_with_comment.png \
helpimg/sd_PresenterConsole01.png \
helpimg/sd_PresenterConsole02.png \
diff --git a/source/media/helpimg/sc_func_opt01.svg b/source/media/helpimg/sc_func_opt01.svg
new file mode 100644
index 000000000..ed63eaef2
--- /dev/null
+++ b/source/media/helpimg/sc_func_opt01.svg
@@ -0,0 +1,174 @@
+<?xml version="1.0" encoding="UTF-8" standalone="no"?>
+<!-- Created with Inkscape (http://www.inkscape.org/) -->
+
+<svg
+ xmlns:dc="http://purl.org/dc/elements/1.1/"
+ xmlns:cc="http://creativecommons.org/ns#"
+ xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
+ xmlns:svg="http://www.w3.org/2000/svg"
+ xmlns="http://www.w3.org/2000/svg"
+ xmlns:sodipodi="http://sodipodi.sourceforge.net/DTD/sodipodi-0.dtd"
+ xmlns:inkscape="http://www.inkscape.org/namespaces/inkscape"
+ width="82.03244mm"
+ height="19.987125mm"
+ viewBox="0 0 82.03244 19.987125"
+ version="1.1"
+ id="svg8"
+ inkscape:version="0.92.4 (5da689c313, 2019-01-14)"
+ sodipodi:docname="func_opt.svg">
+ <defs
+ id="defs2">
+ <inkscape:perspective
+ sodipodi:type="inkscape:persp3d"
+ inkscape:vp_x="0 : 148.49999 : 1"
+ inkscape:vp_y="0 : 999.99993 : 0"
+ inkscape:vp_z="210.00001 : 148.49999 : 1"
+ inkscape:persp3d-origin="105.00001 : 98.999993 : 1"
+ id="perspective3713" />
+ </defs>
+ <sodipodi:namedview
+ id="base"
+ pagecolor="#ffffff"
+ bordercolor="#666666"
+ borderopacity="1.0"
+ inkscape:pageopacity="0.0"
+ inkscape:pageshadow="2"
+ inkscape:zoom="1.4"
+ inkscape:cx="-71.400467"
+ inkscape:cy="-53.95527"
+ inkscape:document-units="mm"
+ inkscape:current-layer="g78"
+ showgrid="false"
+ inkscape:window-width="1920"
+ inkscape:window-height="995"
+ inkscape:window-x="0"
+ inkscape:window-y="0"
+ inkscape:window-maximized="1"
+ fit-margin-top="0"
+ fit-margin-left="0"
+ fit-margin-right="0"
+ fit-margin-bottom="0" />
+ <metadata
+ id="metadata5">
+ <rdf:RDF>
+ <cc:Work
+ rdf:about="">
+ <dc:format>image/svg+xml</dc:format>
+ <dc:type
+ rdf:resource="http://purl.org/dc/dcmitype/StillImage" />
+ <dc:title></dc:title>
+ </cc:Work>
+ </rdf:RDF>
+ </metadata>
+ <g
+ inkscape:label="Camada 1"
+ inkscape:groupmode="layer"
+ id="layer1"
+ transform="translate(-34.584674,-109.78095)">
+ <g
+ id="g78">
+ <g
+ aria-label="= µ dt + vol dW"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ id="flowRoot3715" />
+ <g
+ id="g158">
+ <path
+ id="path99"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 138.7582,451.75469 v -2.64 h -20.16 v 2.64 z m 0,8 v -2.64 h -20.16 v 2.64 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path101"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 172.06945,447.43469 h -3.52 l -2.92,12.52 c -1.4,1.8 -3.16,2.8 -4.88,2.8 -1.68,0 -2.76,-1.08 -2.76,-2.76 0,-0.4 0.04,-0.92 0.12,-1.2 l 2.68,-11.36 h -3.52 l -3.4,14.96 c -0.24,1.08 -0.64,2.2 -1.36,4 -1.2,2.32 -1.52,3.32 -1.52,4.72 0,1.24 0.44,1.8 1.36,1.8 1.72,0 2.84,-2.2 2.84,-5.68 0,-0.32 0,-1.04 -0.04,-1.72 -0.04,-0.68 -0.04,-1.24 -0.04,-1.68 0,-0.72 0,-1.08 0.08,-1.92 0.76,2.12 2,3.04 4.12,3.04 2.12,0 4.04,-1.12 6.16,-3.6 -0.12,0.56 -0.16,0.84 -0.16,1.24 0,1.56 0.76,2.36 2.28,2.36 1.56,0 2.6,-0.56 4.28,-2.28 l 0.12,-0.36 c -1,0.8 -1.56,1.04 -2.24,1.04 -0.68,0 -1.04,-0.4 -1.04,-1.12 0,-0.36 0.08,-0.64 0.24,-1.36 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path103"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 203.02945,437.23469 c -2.12,0.44 -3.56,0.68 -6.12,0.92 v 0.68 c 2.2,0.08 2.56,0.2 2.56,1.04 0,0.56 0.04,0.72 -0.56,2.84 l -1.8,6.52 h -0.04 c -0.24,-1.56 -0.92,-2.32 -2.6,-2.32 -5.2,0 -11.68,6.92 -11.68,13.4 0,3.04 1.68,4.68 4.28,4.68 2.72,0 4.76,-1.32 7.12,-5.28 -0.44,2 -0.52,2.64 -0.52,3.56 0,1.08 0.6,1.8 1.64,1.8 2,0 3.92,-1.64 5.88,-4.56 l -0.48,-0.4 c -2.16,2.48 -2.6,2.84 -3.28,2.84 -0.52,0 -0.72,-0.32 -0.72,-0.8 0,-0.64 1.36,-5.28 2.6,-9.84 l 2.4,-8.76 1.56,-6.08 z m -6.6,12.88 c 0,6.08 -4.16,12.96 -7.84,12.96 -1.4,0 -2.32,-1.08 -2.32,-2.92 0,-3.32 2,-7.68 4.64,-10.48 1.12,-1.16 2.52,-1.84 3.64,-1.84 0.92,0 1.88,0.84 1.88,2.28 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path105"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 214.02945,447.43469 h -3.2 l 1.12,-4.12 c 0.04,-0.08 0.04,-0.28 0.04,-0.28 0,-0.2 -0.12,-0.32 -0.36,-0.32 -0.16,0 -0.4,0.12 -0.56,0.36 -1.44,2.16 -4.04,4.12 -5.32,4.4 -0.96,0.2 -1.32,0.56 -1.32,1 0,0 0,0.12 0.04,0.24 h 3 l -3.12,11.84 c -0.32,1.28 -0.64,2.52 -0.64,2.96 0,1 0.76,1.48 1.84,1.48 2.08,0 3.32,-1.16 5.72,-4.84 l -0.52,-0.28 c -1.96,2.52 -2.6,3.16 -3.24,3.16 -0.36,0 -0.6,-0.12 -0.6,-0.64 0,-0.12 0.04,-0.4 0.08,-0.56 l 3.48,-13.12 h 3.36 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path107"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 246.8832,455.75469 v -2.64 h -8.76 v -8.8 h -2.64 v 8.8 h -8.76 v 2.64 h 8.76 v 8.8 h 2.64 v -8.8 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path109"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 268.59445,461.75469 c -0.24,-5.4 -0.48,-7.6 -1,-10.28 -0.84,-4.32 -0.84,-4.56 -1.2,-4.56 -0.2,0 -0.48,0.04 -0.8,0.16 -1.28,0.28 -2.68,0.56 -4.48,0.84 v 0.52 c 0.44,-0.04 0.84,-0.04 1.24,-0.04 1.48,0 1.92,0.68 2.44,3.72 0.52,3.04 0.96,8.36 0.96,11.12 v 0.96 c 0,0.68 0.12,1.08 0.36,1.08 0.68,0 1.76,-1.32 3.96,-3.68 0.72,-0.76 2.96,-3.32 4.76,-6.12 1.4,-2.16 2.52,-4.48 2.52,-6.2 0,-1.08 -0.92,-2.36 -2.24,-2.36 -0.84,0 -1.52,0.52 -1.52,1.36 0,0.64 0.28,1.16 1,1.8 0.52,0.48 0.72,0.76 0.72,1.16 0,1.88 -2.6,6.28 -5.48,9.24 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path111"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 296.14383,452.51469 c 0,-3.52 -2.4,-5.6 -5.64,-5.6 -1.64,0 -3.24,0.36 -4.8,1.2 -4.2,2.24 -7.2,6.84 -7.2,11.32 0,3.48 2.12,5.56 5.88,5.56 2.64,0 5.2,-1 7.52,-3.32 2.64,-2.6 4.24,-6.12 4.24,-9.16 z m -3.36,-1 c 0,3.04 -1.12,6.8 -2.96,9.32 -1.56,2.16 -3.08,3.32 -4.84,3.32 -1.88,0 -3.12,-1.24 -3.12,-3.64 0,-3.16 1.12,-6.32 2.96,-9.12 1.6,-2.4 3.36,-3.64 5.12,-3.64 1.72,0 2.84,1.32 2.84,3.76 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path113"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 308.58383,437.43469 -0.24,-0.2 c -2.36,0.52 -3.84,0.8 -6.2,1.08 v 0.64 h 0.72 c 1.28,0 1.96,0.4 1.96,0.88 0,0.12 0,0.36 -0.12,0.76 l -5.48,20.96 c -0.12,0.4 -0.16,0.88 -0.16,1.2 0,1.48 0.68,2.24 1.96,2.24 2.16,0 3.64,-1.2 6.04,-5 l -0.56,-0.4 -1,1.4 c -1.16,1.64 -2.08,2.28 -2.68,2.28 -0.4,0 -0.68,-0.24 -0.68,-0.72 0,-0.32 0.12,-1 0.32,-1.72 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path115"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 339.35758,437.23469 c -2.12,0.44 -3.56,0.68 -6.12,0.92 v 0.68 c 2.2,0.08 2.56,0.2 2.56,1.04 0,0.56 0.04,0.72 -0.56,2.84 l -1.8,6.52 h -0.04 c -0.24,-1.56 -0.92,-2.32 -2.6,-2.32 -5.2,0 -11.68,6.92 -11.68,13.4 0,3.04 1.68,4.68 4.28,4.68 2.72,0 4.76,-1.32 7.12,-5.28 -0.44,2 -0.52,2.64 -0.52,3.56 0,1.08 0.6,1.8 1.64,1.8 2,0 3.92,-1.64 5.88,-4.56 l -0.48,-0.4 c -2.16,2.48 -2.6,2.84 -3.28,2.84 -0.52,0 -0.72,-0.32 -0.72,-0.8 0,-0.64 1.36,-5.28 2.6,-9.84 l 2.4,-8.76 1.56,-6.08 z m -6.6,12.88 c 0,6.08 -4.16,12.96 -7.84,12.96 -1.4,0 -2.32,-1.08 -2.32,-2.92 0,-3.32 2,-7.68 4.64,-10.48 1.12,-1.16 2.52,-1.84 3.64,-1.84 0.92,0 1.88,0.84 1.88,2.28 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path117"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIXGeneral;-inkscape-font-specification:'STIXGeneral, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ d="m 374.75758,438.43469 h -7.36 v 0.64 c 2,0.04 2.68,0.68 2.68,1.68 0,0.76 -0.4,1.72 -0.92,2.72 l -7.52,14.6 -1.6,-16.48 c 0,-0.12 -0.08,-0.36 -0.08,-0.6 0,-1.28 0.68,-1.72 2.72,-1.92 v -0.64 h -9.44 v 0.64 c 2.32,0.08 2.76,0.44 3,2.48 l 0.32,2.6 -6.88,13.92 -1.76,-16.16 c -0.04,-0.28 -0.04,-0.6 -0.04,-0.8 0,-1.52 0.84,-1.84 2.88,-2.04 v -0.64 h -9.4 v 0.64 c 1.28,0.16 1.68,0.24 2.04,0.6 0.56,0.6 0.72,1.28 1.16,5.04 l 2.44,20.56 h 0.76 l 8.88,-18.12 h 0.2 l 2,18.12 h 0.8 l 12.04,-23.2 c 1.16,-2.2 1.56,-2.52 3.08,-3 z"
+ transform="matrix(0.26458333,0,0,0.26458333,17.462505,0)"
+ inkscape:connector-curvature="0" />
+ <g
+ id="flowRoot26"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIX;-inkscape-font-specification:'STIX, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ transform="matrix(0.26458333,0,0,0.26458333,-12.170835,-50.270859)"
+ aria-label="dS">
+ <path
+ id="path120"
+ d="m 198.62711,604.92023 c -2.12,0.44 -3.56,0.68 -6.12,0.92 v 0.68 c 2.2,0.08 2.56,0.2 2.56,1.04 0,0.56 0.04,0.72 -0.56,2.84 l -1.8,6.52 h -0.04 c -0.24,-1.56 -0.92,-2.32 -2.6,-2.32 -5.2,0 -11.68,6.92 -11.68,13.4 0,3.04 1.68,4.68 4.28,4.68 2.72,0 4.76,-1.32 7.12,-5.28 -0.44,2 -0.52,2.64 -0.52,3.56 0,1.08 0.6,1.8 1.64,1.8 2,0 3.92,-1.64 5.88,-4.56 l -0.48,-0.4 c -2.16,2.48 -2.6,2.84 -3.28,2.84 -0.52,0 -0.72,-0.32 -0.72,-0.8 0,-0.64 1.36,-5.28 2.6,-9.84 l 2.4,-8.76 1.56,-6.08 z m -6.6,12.88 c 0,6.08 -4.16,12.96 -7.84,12.96 -1.4,0 -2.32,-1.08 -2.32,-2.92 0,-3.32 2,-7.68 4.64,-10.48 1.12,-1.16 2.52,-1.84 3.64,-1.84 0.92,0 1.88,0.84 1.88,2.28 z"
+ inkscape:connector-curvature="0" />
+ <path
+ id="path122"
+ d="m 218.10711,605.56023 h -0.92 c -0.56,0.84 -0.92,1.04 -1.8,1.04 -0.52,0 -1,-0.12 -1.84,-0.44 -0.84,-0.36 -2.16,-0.56 -3.4,-0.56 -3.84,0 -7.12,2.36 -7.12,6.56 0,2.16 0.6,3.44 3,6 0.52,0.52 1,1.08 1.56,1.68 l 1.56,1.68 c 1.84,2 2.4,3.2 2.4,4.92 0,3.04 -2.16,5.12 -5.24,5.12 -3.36,0 -5.76,-2.76 -5.76,-6.68 0,-0.28 0,-0.56 0.08,-0.92 l -0.8,-0.08 -1.36,8.96 h 0.72 c 0.28,-0.92 0.92,-1.28 1.72,-1.28 0.44,0 0.8,0.08 1.88,0.48 1.84,0.64 2.92,0.92 4.16,0.92 4.6,0 8.08,-3.24 8.08,-7.8 0,-2.6 -0.88,-4.32 -4.52,-8 -3.64,-3.64 -3.96,-4.28 -3.96,-6.24 0,-2.52 1.72,-4 4.48,-4 3.88,0 4.76,2.44 4.76,6.52 l 0.72,0.12 z"
+ inkscape:connector-curvature="0" />
+ </g>
+ <g
+ id="flowRoot34"
+ style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIX;-inkscape-font-specification:'STIX, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ transform="matrix(0.26458333,0,0,0.26458333,-10.054167,-77.258376)"
+ aria-label="S">
+ <path
+ id="path125"
+ d="m 198.10711,755.06219 h -0.92 c -0.56,0.84 -0.92,1.04 -1.8,1.04 -0.52,0 -1,-0.12 -1.84,-0.44 -0.84,-0.36 -2.16,-0.56 -3.4,-0.56 -3.84,0 -7.12,2.36 -7.12,6.56 0,2.16 0.6,3.44 3,6 0.52,0.52 1,1.08 1.56,1.68 l 1.56,1.68 c 1.84,2 2.4,3.2 2.4,4.92 0,3.04 -2.16,5.12 -5.24,5.12 -3.36,0 -5.76,-2.76 -5.76,-6.68 0,-0.28 0,-0.56 0.08,-0.92 l -0.8,-0.08 -1.36,8.96 h 0.72 c 0.28,-0.92 0.92,-1.28 1.72,-1.28 0.44,0 0.8,0.08 1.88,0.48 1.84,0.64 2.92,0.92 4.16,0.92 4.6,0 8.08,-3.24 8.08,-7.8 0,-2.6 -0.88,-4.32 -4.52,-8 -3.64,-3.64 -3.96,-4.28 -3.96,-6.24 0,-2.52 1.72,-4 4.48,-4 3.88,0 4.76,2.44 4.76,6.52 l 0.72,0.12 z"
+ inkscape:connector-curvature="0" />
+ </g>
+ <g
+ id="flowRoot52"
+ style="font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:40px;line-height:1.25;font-family:STIX;-inkscape-font-specification:'STIX, Normal';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-feature-settings:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none"
+ transform="matrix(0.26458333,0,0,0.26458333,5.6696428,-35.340774)"
+ aria-label="—">
+ <path
+ id="path128"
+ d="m 149.28516,588.76469 v -1.96 h -40 v 1.96 z"
+ inkscape:connector-curvature="0" />
+ </g>
+ </g>
+ </g>
+ </g>
+</svg>
diff --git a/source/text/scalc/01/common_func.xhp b/source/text/scalc/01/common_func.xhp
index b3803f646..7031956cb 100644
--- a/source/text/scalc/01/common_func.xhp
+++ b/source/text/scalc/01/common_func.xhp
@@ -16,10 +16,10 @@
</meta>
<body>
<section id="sectionsyntax">
- <paragraph id="hd_id3152015" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
+ <h3 id="hd_id3152015">Syntax</h3>
</section>
<section id="sectionexample">
- <paragraph id="hd_id281171" role="heading" level="3" xml-lang="en-US">Example</paragraph>
+ <h3 id="hd_id281171">Example</h3>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_opt_barrier.xhp b/source/text/scalc/01/func_opt_barrier.xhp
new file mode 100644
index 000000000..805baef58
--- /dev/null
+++ b/source/text/scalc/01/func_opt_barrier.xhp
@@ -0,0 +1,55 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="funcoptbarrier" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Function OPT_BARRIER</title>
+ <filename>/text/scalc/01/func_opt_barrier.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="optbarrier">
+ <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"/>
+ <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; Lower Barrier; Upper Barrier; Rebate; Put or Call; In or Out; Barrier Monitoring; Greek)</paragraph>
+ <paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id731575073617425" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optvolat" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id341575073621215" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optrate" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id391575073625097" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optfrate" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id541575073629073" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optmaturity" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id681575073426941"><emph>Strike</emph> is the strike price of the option and should be non-negative.</paragraph>
+ <paragraph role="paragraph" id="par_id321575073632473" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optlowbar" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id541575073636017" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optupbar" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id671575073495724"><emph>Rebate</emph> is the amount of money to be paid at maturity if the barrier is hit.</paragraph>
+ <paragraph role="paragraph" id="par_id691575073511191"><variable id="optputcall"><emph>Put or Call</emph> is a string that defines whether the option is a put (“p”) or a call (“c”).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id11575073641257" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optinout" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id211575073645423" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optbarmon" markup="keep"/></paragraph>
+ <embed href="text/scalc/01/func_opt_touch.xhp#optgreek"/>
+ <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>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
+ <embed href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
+ <embed href="text/scalc/01/func_opt_prob_hit.xhp#optprobhith1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#relatedfinancial"/>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_opt_prob_hit.xhp b/source/text/scalc/01/func_opt_prob_hit.xhp
new file mode 100644
index 000000000..b8b365c1e
--- /dev/null
+++ b/source/text/scalc/01/func_opt_prob_hit.xhp
@@ -0,0 +1,53 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="functoptprobhit" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Function OPT_PROB_HIT</title>
+ <filename>/text/scalc/01/func_opt_prob_hit.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="optprobhit">
+ <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"/>
+ <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">
+ <image src="media/helpimg/sc_func_opt01.svg" id="img_id211575078735993" width="4cm" height="1cm"><alt xml-lang="en-US" id="alt_id401575078735994">OPT_PROB_HIT equation</alt></image>
+ </paragraph>
+ <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; Lower Barrier; Upper Barrier)</paragraph>
+ <paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id731575073617425" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optvolat" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id901575074339820"><variable id="optdrift"><emph>Drift</emph> is the annual stock price percentage drift rate (µ in the above formula). The value is expressed as a decimal (for example, enter 15% as 0.15).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id541575073629073" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optmaturity" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id681575073426941"><variable id="optstrike"><emph>Strike</emph> is the strike price of the option and should be non-negative.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id321575073632473" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optlowbar" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id541575073636017" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optupbar" markup="keep"/></paragraph>
+ <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>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
+ <embed href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
+ <embed href="text/scalc/01/func_opt_prob_hit.xhp#optprobhith1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#relatedfinancial"/>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_opt_prob_inmoney.xhp b/source/text/scalc/01/func_opt_prob_inmoney.xhp
new file mode 100644
index 000000000..05ee298d4
--- /dev/null
+++ b/source/text/scalc/01/func_opt_prob_inmoney.xhp
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="funcoptprobinmoney" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Function OPT_PROB_INMONEY</title>
+ <filename>/text/scalc/01/func_opt_prob_inmoney.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="optprobinmoney">
+ <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_PRON_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">
+ <image src="media/helpimg/sc_func_opt01.svg" id="img_id211575078735993" width="4cm" height="1cm"><alt xml-lang="en-US" id="alt_id401575078735994">OPT_PROB_INMONEY equation</alt></image>
+ </paragraph>
+ <paragraph role="paragraph" id="par_id941575074893788"><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>
+ <paragraph role="paragraph" id="par_id241575075282150">If the optional <emph>Strike</emph> and <emph>Put or Call</emph> arguments are included, then</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id931575075314553" role="listitem">For a call option, the function returns the probability that the asset will end up between <emph>Strike</emph> and <emph>Upper Barrier</emph>.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id531575075321659" role="listitem">For a put option, the function returns the probability that the asset will end up between <emph>Lower Barrier</emph> and <emph>Strike</emph>.</paragraph>
+ </listitem>
+ </list>
+ <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; Lower Barrier; Upper Barrier; Strike; Put or Call)</paragraph>
+ <paragraph role="paragraph" id="par_id641575073609823" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optspot" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id731575073617425" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optvolat" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id281575079343439" localize="false"><embedvar href="text/scalc/01/func_opt_prob_hit.xhp#optdrift" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id541575073629073" localize="false"><embedvar href="text/scalc/01/func_opt_touch.xhp#optmaturity" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id851575079506442" localize="false"><embedvar href="text/scalc/01/func_opt_prob_hit.xhp#optstrike" markup="keep"/></paragraph>
+ <paragraph role="paragraph" id="par_id861575082252126" localize="false"><embedvar href="text/scalc/01/func_opt_barrier.xhp#optputcall" markup="keep"/></paragraph>
+ <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>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
+ <embed href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
+ <embed href="text/scalc/01/func_opt_prob_hit.xhp#optprobhith1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#relatedfinancial"/>
+ </section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/func_opt_touch.xhp b/source/text/scalc/01/func_opt_touch.xhp
new file mode 100644
index 000000000..86b79fe1f
--- /dev/null
+++ b/source/text/scalc/01/func_opt_touch.xhp
@@ -0,0 +1,89 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="functionopttouch" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">OPT_TOUCH</title>
+ <filename>/text/scalc/01/func_opt_touch.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <section id="opttouch">
+ <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"/>
+ <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>
+ <section id="opttip">
+ <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; Foreign Rate; Maturity; Lower Barrier; Upper Barrier; Domestic or Foreign; In or Out; Barrier Monitoring; Greek)</paragraph>
+
+ <paragraph role="paragraph" id="par_id321575066304659"><variable id="optspot"><emph>Spot</emph> is the price / value of the underlying asset and should be greater than 0.0.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id31575066315078"><variable id="optvolat"><emph>Volatility</emph> is the annual percentage volatility of the underlying asset expressed as a decimal (for example, enter 30% as 0.3). The value should be greater than 0.0.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id681575066324254"><variable id="optrate"><emph>Rate</emph> is the continuously compounded interest rate. This is a percentage expressed as a decimal (for example, enter 40% as 0.4).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id71575066333773"><variable id="optfrate"><emph>Foreign Rate</emph> is the continuously compounded foreign interest rate. This is a percentage expressed as a decimal (for example, enter 50% as 0.5).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id21575066338734"><variable id="optmaturity"><emph>Maturity</emph> is the time to maturity of the option, in years, and should be non-negative.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id671575066343182"><variable id="optlowbar"><emph>Lower Barrier</emph> is the predetermined lower barrier price; set to zero for no lower barrier.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id301575066347357"><variable id="optupbar"><emph>Upper Barrier</emph> is the predetermined upper barrier price; set to zero for no upper barrier.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id561575066355924"><variable id="optdomestic"><emph>Domestic or Foreign</emph> is a string that defines whether the option pays domestic (“d”) or foreign (“f”) currency.</variable></paragraph>
+ <paragraph role="paragraph" id="par_id251575066360596"><variable id="optinout"><emph>In or Out</emph> is a string that defines whether the option is knock-in (“i”) or knock-out (“o”).</variable></paragraph>
+ <paragraph role="paragraph" id="par_id861575066366861"><variable id="optbarmon"><emph>Barrier Monitoring</emph> is a string that defines whether the barrier is monitored continuously (“c”) or only at the end / maturity (“e”).</variable></paragraph>
+ <section id="optgreek">
+ <paragraph role="paragraph" id="par_id721575066374340"><emph>Greek</emph> (optional) is a string argument. If omitted or set to “value”, “v”, “price”, or “p”, then the function simply returns the option price. If another valid string is entered, the function returns price sensitivities (Greeks) to one of the input parameters. The valid options in this case are as follows.</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id951575063536153" role="listitem">“delta” or “d”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id361575063554232" role="listitem">“gamma” or “g”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id961575063563017" role="listitem">“theta” or “t”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id971575063570632" role="listitem">“vega” or “e”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id631575063580705" role="listitem">“volga” or “o”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id981575063594505" role="listitem">“vanna” or “a”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id191575063598656" role="listitem">“rho” or “r”.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id751575063602288" role="listitem">“rhof” or “f”.</paragraph>
+ </listitem>
+ </list>
+ </section>
+ <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>
+ <section id="relatedtopics">
+ <embed href="text/scalc/01/func_opt_barrier.xhp#optbrarrierh1"/>
+ <embed href="text/scalc/01/func_opt_touch.xhp#opttouchh1"/>
+ <embed href="text/scalc/01/func_opt_prob_inmoney.xhp#optprobinmoneyh1"/>
+ <embed href="text/scalc/01/func_opt_prob_hit.xhp#optprobhith1"/>
+ <section id="relatedfinancial">
+ <paragraph role="paragraph" id="par_id121575125779535"><link href="text/scalc/01/04060103.xhp">Financial Functions Part One</link></paragraph>
+ <paragraph role="paragraph" id="par_id251575125873714"><link href="text/scalc/01/04060119.xhp">Financial Functions Part Two</link></paragraph>
+ <paragraph role="paragraph" id="par_id191575125878595"><link href="text/scalc/01/04060118.xhp">Financial Functions Part Three</link></paragraph>
+ </section>
+ </section>
+</body>
+</helpdocument>
More information about the Libreoffice-commits
mailing list