diff options
Diffstat (limited to 'source/is/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/is/helpcontent2/source/text/scalc/01.po | 711 |
1 files changed, 648 insertions, 63 deletions
diff --git a/source/is/helpcontent2/source/text/scalc/01.po b/source/is/helpcontent2/source/text/scalc/01.po index d1861d30bc1..6668c843168 100644 --- a/source/is/helpcontent2/source/text/scalc/01.po +++ b/source/is/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2019-11-13 13:46+0100\n" +"POT-Creation-Date: 2019-12-17 23:04+0100\n" "PO-Revision-Date: 2018-11-12 13:45+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -7045,23 +7045,23 @@ msgctxt "" msgid "<item type=\"input\">=DISC(\"2001-01-25\";\"2001-11-15\";97;100;3)</item> returns about 0.0372 or 3.72 per cent." msgstr "" -#. hm7Tq +#. pLhCb #: 04060103.xhp msgctxt "" "04060103.xhp\n" "bm_id3154695\n" "help.text" -msgid "<bookmark_value>DURATION_ADD function</bookmark_value> <bookmark_value>Microsoft Excel functions</bookmark_value> <bookmark_value>durations;fixed interest securities</bookmark_value>" +msgid "<bookmark_value>DURATION function</bookmark_value> <bookmark_value>durations;fixed interest securities</bookmark_value>" msgstr "" -#. bD2zQ +#. coRDF #: 04060103.xhp msgctxt "" "04060103.xhp\n" "hd_id3154695\n" "help.text" -msgid "DURATION_ADD" -msgstr "DURATION_ADD" +msgid "DURATION" +msgstr "" #. oA2tj #: 04060103.xhp @@ -7072,13 +7072,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>" msgstr "" -#. MEAyR +#. bJZPP #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153373\n" "help.text" -msgid "DURATION_ADD(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)" +msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)" msgstr "" #. JeeVp @@ -7135,13 +7135,13 @@ msgctxt "" msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the duration?" msgstr "" -#. vGsKM +#. ggYzf #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3154902\n" "help.text" -msgid "<item type=\"input\">=DURATION_ADD(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>" +msgid "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>" msgstr "" #. TjeEJ @@ -14452,13 +14452,13 @@ msgctxt "" msgid "To sum up only negative numbers: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>" msgstr "" -#. rxMQ3 +#. GGT9C #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id6670125\n" "help.text" -msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0." +msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0." msgstr "" #. G5vdm @@ -15136,13 +15136,13 @@ msgctxt "" msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5." msgstr "<item type=\"input\">=ODD(-3.1)</item> skilar -5." -#. Tkdj9 +#. CR7gG #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id2957404\n" "help.text" -msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>FLOOR.XCL function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" msgstr "" #. ticPN @@ -15199,13 +15199,13 @@ msgctxt "" msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12" msgstr "<item type=\"input\">=FLOOR( -11;-2)</item> skilar -12" -#. qdxiZ +#. aDgE5 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id3157404\n" "help.text" -msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>FLOOR.MATH function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" msgstr "" #. BAZE3 @@ -30886,13 +30886,13 @@ msgctxt "" msgid "A security is purchased on 1999-02-15; the maturity date is 2007-11-15. The nominal rate of interest is 5.75%. The yield is 6.5%. The redemption value is 100 currency units. Interest is paid half-yearly (frequency is 2). With calculation on basis 0, the price is as follows:" msgstr "" -#. SGB87 +#. mvRnh #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3147273\n" "help.text" -msgid "=PRICE(\"1999-02-15\"; \"2007-11-15\"; 0.0575; 0.065; 100; 2; 0) returns 95.04287." +msgid "<input>=PRICE(\"1999-02-15\"; \"2007-11-15\"; 0.0575; 0.065; 100; 2; 0)</input> returns 95.04287." msgstr "" #. sQGxa @@ -30976,13 +30976,13 @@ msgctxt "" msgid "A security is purchased on 1999-02-15; the maturity date is 1999-03-01. Discount in per cent is 5.25%. The redemption value is 100. When calculating on basis 2 the price discount is as follows:" msgstr "" -#. zWwmn +#. ZeFG7 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3151178\n" "help.text" -msgid "=PRICEDISC(\"1999-02-15\"; \"1999-03-01\"; 0.0525; 100; 2) returns 99.79583." +msgid "<input>=PRICEDISC(\"1999-02-15\"; \"1999-03-01\"; 0.0525; 100; 2)</input> returns 99.79583." msgstr "" #. hbGNH @@ -31084,32 +31084,32 @@ msgctxt "" msgid "The price is calculated as follows:" msgstr "" -#. ed6RY +#. fi4NY #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3158409\n" "help.text" -msgid "=PRICEMAT(\"1999-02-15\";\"1999-04-13\";\"1998-11-11\"; 0.061; 0.061;0) returns 99.98449888." +msgid "<input>=PRICEMAT(\"1999-02-15\";\"1999-04-13\";\"1998-11-11\"; 0.061; 0.061;0)</input> returns 99.98449888." msgstr "" -#. crj7S +#. GAN7n #: 04060119.xhp msgctxt "" "04060119.xhp\n" "bm_id3148448\n" "help.text" -msgid "<bookmark_value>calculating; durations</bookmark_value><bookmark_value>durations;calculating</bookmark_value><bookmark_value>DURATION function</bookmark_value>" +msgid "<bookmark_value>calculating; durations</bookmark_value><bookmark_value>durations;calculating</bookmark_value><bookmark_value>PDURATION function</bookmark_value>" msgstr "" -#. HUEcU +#. EjWXp #: 04060119.xhp msgctxt "" "04060119.xhp\n" "hd_id3148448\n" "help.text" -msgid "DURATION" -msgstr "DURATION" +msgid "PDURATION" +msgstr "" #. mQkqy #: 04060119.xhp @@ -31120,13 +31120,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LAUFZEIT\">Calculates the number of periods required by an investment to attain the desired value.</ahelp>" msgstr "" -#. brSXj +#. wLSMC #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3148933\n" "help.text" -msgid "DURATION(Rate; PV; FV)" +msgid "PDURATION(Rate; PV; FV)" msgstr "" #. Rzxhq @@ -31336,13 +31336,13 @@ msgctxt "" msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The nominal rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the modified duration?" msgstr "" -#. uvE3L +#. PWSr2 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3145378\n" "help.text" -msgid "=MDURATION(\"2001-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 3) returns 4.02 years." +msgid "<input>=MDURATION(\"2001-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 3)</input> returns 4.02 years." msgstr "" #. BrDKP @@ -31885,13 +31885,13 @@ msgctxt "" msgid "A security is purchased on 1999-02-15. It matures on 2007-11-15. The rate of interest is 5.75%. The price is 95.04287 currency units per 100 units of par value, the redemption value is 100 units. Interest is paid half-yearly (frequency = 2) and the basis is 0. How high is the yield?" msgstr "" -#. UfrLb +#. iewbU #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3154194\n" "help.text" -msgid "=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0) returns 0.065 or 6.50 per cent." +msgid "<input>=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0)</input> returns 0.065 or 6.50 per cent." msgstr "" #. AeJmf @@ -31975,13 +31975,13 @@ msgctxt "" msgid "A non-interest-bearing security is purchased on 1999-02-15. It matures on 1999-03-01. The price is 99.795 currency units per 100 units of par value, the redemption value is 100 units. The basis is 2. How high is the yield?" msgstr "" -#. 7YN9G +#. DMev8 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3155187\n" "help.text" -msgid "=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2) returns 0.052823 or 5.2823 per cent." +msgid "<input>=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2)</input> returns 0.052823 or 5.2823 per cent." msgstr "" #. 5mbhE @@ -32074,13 +32074,13 @@ msgctxt "" msgid "A security is purchased on 1999-03-15. It matures on 1999-11-03. The issue date was 1998-11-08. The rate of interest is 6.25%, the price is 100.0123 units. The basis is 0. How high is the yield?" msgstr "" -#. EgFWh +#. DswXC #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3155311\n" "help.text" -msgid "=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0) returns 0.060954 or 6.0954 per cent." +msgid "<input>=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0)</input> returns 0.060954 or 6.0954 per cent." msgstr "" #. 2ZC4E @@ -32263,13 +32263,13 @@ msgctxt "" msgid "The return on the treasury bill corresponding to a security is worked out as follows:" msgstr "" -#. PGMJB +#. QzDeZ #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3154382\n" "help.text" -msgid "=TBILLEQ(\"1999-03-31\";\"1999-06-01\"; 0.0914) returns 0.094151 or 9.4151 per cent." +msgid "<input>=TBILLEQ(\"1999-03-31\";\"1999-06-01\"; 0.0914)</input> returns 0.094151 or 9.4151 per cent." msgstr "" #. zcFRa @@ -32353,13 +32353,13 @@ msgctxt "" msgid "The price of the treasury bill is worked out as follows:" msgstr "" -#. 2oCRv +#. VfuXC #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3154592\n" "help.text" -msgid "=TBILLPRICE(\"1999-03-31\";\"1999-06-01\"; 0.09) returns 98.45." +msgid "<input>=TBILLPRICE(\"1999-03-31\";\"1999-06-01\"; 0.09)</input> returns 98.45." msgstr "" #. yEHpt @@ -32443,13 +32443,13 @@ msgctxt "" msgid "The yield of the treasury bill is worked out as follows:" msgstr "" -#. vwDmA +#. CrxD8 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3148528\n" "help.text" -msgid "=TBILLYIELD(\"1999-03-31\";\"1999-06-01\"; 98.45) returns 0.091417 or 9.1417 per cent." +msgid "<input>=TBILLYIELD(\"1999-03-31\";\"1999-06-01\"; 98.45)</input> returns 0.091417 or 9.1417 per cent." msgstr "" #. NF5nu @@ -44402,14 +44402,14 @@ msgctxt "" msgid "Insert Function into calculation sheet" msgstr "Setja fallið inn í reikniblað" -#. 7J4VW +#. UPFoX #: 04080000.xhp msgctxt "" "04080000.xhp\n" "par_id3150043\n" "help.text" -msgid "<image id=\"img_id3159267\" src=\"sc/res/fx.png\"><alt id=\"alt_id3159267\">Icon</alt></image>" -msgstr "<image id=\"img_id3159267\" src=\"sc/res/fx.png\"><alt id=\"alt_id3159267\">Táknmynd</alt></image>" +msgid "<image id=\"img_id3159267\" src=\"sc/res/fx.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3159267\">Icon Insert Function</alt></image>" +msgstr "" #. 4Hfgb #: 04080000.xhp @@ -46229,14 +46229,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>" msgstr "" -#. vDDA3 +#. JcMEc #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3150751\n" "help.text" -msgid "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\"><alt id=\"alt_id3153714\">Icon</alt></image>" -msgstr "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\"><alt id=\"alt_id3153714\">Táknmynd</alt></image>" +msgid "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153714\">Icon Cell Styles</alt></image>" +msgstr "" #. HKD2C #: 05100000.xhp @@ -46265,13 +46265,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>" msgstr "" -#. oCa5C +#. cM9f4 #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3159100\n" "help.text" -msgid "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\"><alt id=\"alt_id3149814\">Icon</alt></image>" +msgid "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149814\">Icon Page Styles</alt></image>" msgstr "" #. BnFvb @@ -46301,14 +46301,14 @@ msgctxt "" msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles window.</ahelp>" msgstr "" -#. JM3as +#. ChsD7 #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3155087\n" "help.text" -msgid "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\"><alt id=\"alt_id3153068\">Icon</alt></image>" -msgstr "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\"><alt id=\"alt_id3153068\">Táknmynd</alt></image>" +msgid "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153068\">Icon Fill Format Mode</alt></image>" +msgstr "" #. TEEFF #: 05100000.xhp @@ -46382,14 +46382,14 @@ msgctxt "" msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_NEWBYEXAMPLE\">Creates a new style based on the formatting of a selected object.</ahelp> Assign a name for the style in the <link href=\"text/shared/01/05140100.xhp\" name=\"Create Style\">Create Style</link> dialog." msgstr "" -#. AGMAe +#. T967y #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3150050\n" "help.text" -msgid "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\"><alt id=\"alt_id3154649\">Icon</alt></image>" -msgstr "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\"><alt id=\"alt_id3154649\">Táknmynd</alt></image>" +msgid "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3154649\">Icon New Style from Selection</alt></image>" +msgstr "" #. aE4gp #: 05100000.xhp @@ -46418,14 +46418,14 @@ msgctxt "" msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles window with the current formatting of the selected object.</ahelp>" msgstr "" -#. 5cyG3 +#. F3Lph #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3145118\n" "help.text" -msgid "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\"><alt id=\"alt_id3155754\">Icon</alt></image>" -msgstr "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\"><alt id=\"alt_id3155754\">Táknmynd</alt></image>" +msgid "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3155754\">Icon Update Style</alt></image>" +msgstr "" #. AbPzG #: 05100000.xhp @@ -60495,14 +60495,14 @@ msgctxt "" msgid "NETWORKDAYS" msgstr "NETWORKDAYS" -#. 7srBV +#. v4yGQ #: func_networkdays.xhp msgctxt "" "func_networkdays.xhp\n" "bm_id3151254\n" "help.text" -msgid "<bookmark_value>NETWORKDAYS function</bookmark_value>" -msgstr "<bookmark_value>NETWORKDAYS fall</bookmark_value>" +msgid "<bookmark_value>NETWORKDAYS function</bookmark_value> <bookmark_value>NETWORKDAYS_EXCEL2003 function</bookmark_value>" +msgstr "" #. HzF8v #: func_networkdays.xhp @@ -60767,6 +60767,591 @@ msgctxt "" msgid "<item type=\"input\">=NUMBERVALUE(\"123.456\";\".\";\",\")</item> yields 123.456" msgstr "" +#. EJhfD +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"tit\n" +"help.text" +msgid "Function OPT_BARRIER" +msgstr "" + +#. 4HRGX +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"bm_id511575065323638\n" +"help.text" +msgid "<bookmark_value>OPT_BARRIER function</bookmark_value>" +msgstr "" + +#. KrCYn +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"hd_id241575063871994\n" +"help.text" +msgid "<variable id=\"optbrarrierh1\"><link href=\"text/scalc/01/func_opt_barrier.xhp\" name=\"OPT_BARRIER\">OPT_BARRIER</link></variable>" +msgstr "" + +#. uFKBs +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id121575063871995\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable>" +msgstr "" + +#. xjXe5 +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id371575067051846\n" +"help.text" +msgid "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; Lower Barrier; Upper Barrier; Rebate; Put or Call; In or Out; Barrier Monitoring; Greek)" +msgstr "" + +#. XEMff +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id681575073426941\n" +"help.text" +msgid "<emph>Strike</emph> is the strike price of the option and should be non-negative." +msgstr "" + +#. 8tgWG +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id671575073495724\n" +"help.text" +msgid "<emph>Rebate</emph> is the amount of money to be paid at maturity if the barrier is hit." +msgstr "" + +#. uAzky +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id691575073511191\n" +"help.text" +msgid "<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>" +msgstr "" + +#. wKSr7 +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id651575073773761\n" +"help.text" +msgid "<input>=OPT_BARRIER(30,0.2,0.06,0,1,40,25,0,0,\"c\",\"o\",\"c\")</input> returns the value 0.4243." +msgstr "" + +#. vvTiB +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id401575073777593\n" +"help.text" +msgid "<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." +msgstr "" + +#. HWhRY +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"tit\n" +"help.text" +msgid "Function OPT_PROB_HIT" +msgstr "" + +#. 5Naq2 +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"bm_id961575074485125\n" +"help.text" +msgid "<bookmark_value>OPT_PROB_HIT function</bookmark_value>" +msgstr "" + +#. jn8fF +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"hd_id71575063908363\n" +"help.text" +msgid "<variable id=\"optprobhith1\"><link href=\"text/scalc/01/func_opt_prob_hit.xhp\" name=\"OPT_PROB_HIT\">OPT_PROB_HIT</link></variable>" +msgstr "" + +#. fWecm +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id591575063908364\n" +"help.text" +msgid "<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." +msgstr "" + +#. PF9tf +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id21575078735992\n" +"help.text" +msgid "<image src=\"media/helpimg/sc_func_opt01.svg\" id=\"img_id211575078735993\" width=\"4cm\" height=\"1cm\"><alt id=\"alt_id401575078735994\">OPT_PROB_HIT equation</alt></image>" +msgstr "" + +#. FnaCP +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id821575074114118\n" +"help.text" +msgid "<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." +msgstr "" + +#. Fpb3w +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id211575074192954\n" +"help.text" +msgid "OPT_PROB_HIT(Spot; Volatility; Drift; Maturity; Lower Barrier; Upper Barrier)" +msgstr "" + +#. XaA8K +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id901575074339820\n" +"help.text" +msgid "<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>" +msgstr "" + +#. 6yrWk +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id681575073426941\n" +"help.text" +msgid "<variable id=\"optstrike\"><emph>Strike</emph> is the strike price of the option and should be non-negative.</variable>" +msgstr "" + +#. yoxSg +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id971575074431070\n" +"help.text" +msgid "<input>=OPT_PROB_HIT(30,0.2,0.3,1,0,40)</input> returns the value 0.6119." +msgstr "" + +#. 4GDy6 +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id171575074434932\n" +"help.text" +msgid "<input>=OPT_PROB_HIT(70,0.3,0.1,0.5,60,0)</input> returns the value 0.4239." +msgstr "" + +#. RFprF +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"tit\n" +"help.text" +msgid "Function OPT_PROB_INMONEY" +msgstr "" + +#. QQBrZ +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"bm_id961575065633373\n" +"help.text" +msgid "<bookmark_value>OPT_PROB_INMONEY function</bookmark_value>" +msgstr "" + +#. kMBbw +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"hd_id941575063929082\n" +"help.text" +msgid "<variable id=\"optprobinmoneyh1\"><link href=\"text/scalc/01/func_opt_prob_inmoney.xhp\" name=\"OPT_PROB_INMONEY\">OPT_PROB_INMONEY</link></variable>" +msgstr "" + +#. QDryb +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id941575063929083\n" +"help.text" +msgid "<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." +msgstr "" + +#. HDuce +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id21575078735992\n" +"help.text" +msgid "<image src=\"media/helpimg/sc_func_opt01.svg\" id=\"img_id211575078735993\" width=\"4cm\" height=\"1cm\"><alt id=\"alt_id401575078735994\">OPT_PROB_INMONEY equation</alt></image>" +msgstr "" + +#. 7ja6D +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id941575074893788\n" +"help.text" +msgid "<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." +msgstr "" + +#. Q5kQE +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id241575075282150\n" +"help.text" +msgid "If the optional <emph>Strike</emph> and <emph>Put or Call</emph> arguments are included, then" +msgstr "" + +#. woEub +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id931575075314553\n" +"help.text" +msgid "For a call option, the function returns the probability that the asset will end up between <emph>Strike</emph> and <emph>Upper Barrier</emph>." +msgstr "" + +#. TSjbw +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id531575075321659\n" +"help.text" +msgid "For a put option, the function returns the probability that the asset will end up between <emph>Lower Barrier</emph> and <emph>Strike</emph>." +msgstr "" + +#. 9VazP +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id191575075304900\n" +"help.text" +msgid "The function ignores the possibility of knock-out before maturity." +msgstr "" + +#. FrdBP +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id761575075027094\n" +"help.text" +msgid "OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; Lower Barrier; Upper Barrier; Strike; Put or Call)" +msgstr "" + +#. ykBLq +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id601575074993334\n" +"help.text" +msgid "<input>=OPT_PROB_INMONEY(30,0.2,0.1,1,0,50)</input> returns the value 0.9844." +msgstr "" + +#. YJ5Rn +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id261575074997216\n" +"help.text" +msgid "<input>=OPT_PROB_INMONEY(70,0.3,0.15,1,60,0,80,\"p\")</input> returns the value 0.3440." +msgstr "" + +#. muQEH +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"tit\n" +"help.text" +msgid "OPT_TOUCH" +msgstr "" + +#. r3Awi +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"bm_id951575065400504\n" +"help.text" +msgid "<bookmark_value>OPT_TOUCH function</bookmark_value>" +msgstr "" + +#. DBPBG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"hd_id41575062825964\n" +"help.text" +msgid "<variable id=\"opttouchh1\"><link href=\"text/scalc/01/func_opt_touch.xhp\" name=\"function_opt_touch\">OPT_TOUCH</link></variable>" +msgstr "" + +#. HwW6c +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id531575062825965\n" +"help.text" +msgid "<ahelp hid=\".\">Returns the pricing of a touch / no-touch option, calculated using the Black-Scholes option pricing model.</ahelp>" +msgstr "" + +#. DE8qf +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id371575066515276\n" +"help.text" +msgid "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." +msgstr "" + +#. 29Wsy +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id571575080642652\n" +"help.text" +msgid "Further information about touch / no-touch options may be found on many financial websites." +msgstr "" + +#. EhEcC +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id151575063296819\n" +"help.text" +msgid "OPT_TOUCH(Spot; Volatility; Rate; Foreign Rate; Maturity; Lower Barrier; Upper Barrier; Domestic or Foreign; In or Out; Barrier Monitoring; Greek)" +msgstr "" + +#. 6rD5u +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id321575066304659\n" +"help.text" +msgid "<variable id=\"optspot\"><emph>Spot</emph> is the price / value of the underlying asset and should be greater than 0.0.</variable>" +msgstr "" + +#. CoALG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id31575066315078\n" +"help.text" +msgid "<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>" +msgstr "" + +#. iCEkw +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id681575066324254\n" +"help.text" +msgid "<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>" +msgstr "" + +#. xoi6x +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id71575066333773\n" +"help.text" +msgid "<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>" +msgstr "" + +#. hzfJp +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id21575066338734\n" +"help.text" +msgid "<variable id=\"optmaturity\"><emph>Maturity</emph> is the time to maturity of the option, in years, and should be non-negative.</variable>" +msgstr "" + +#. GS3cC +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id671575066343182\n" +"help.text" +msgid "<variable id=\"optlowbar\"><emph>Lower Barrier</emph> is the predetermined lower barrier price; set to zero for no lower barrier.</variable>" +msgstr "" + +#. Lz4Ei +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id301575066347357\n" +"help.text" +msgid "<variable id=\"optupbar\"><emph>Upper Barrier</emph> is the predetermined upper barrier price; set to zero for no upper barrier.</variable>" +msgstr "" + +#. B7jzn +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id561575066355924\n" +"help.text" +msgid "<variable id=\"optdomestic\"><emph>Domestic or Foreign</emph> is a string that defines whether the option pays domestic (“d”) or foreign (“f”) currency.</variable>" +msgstr "" + +#. rdx6A +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id251575066360596\n" +"help.text" +msgid "<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>" +msgstr "" + +#. 6L3fG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id861575066366861\n" +"help.text" +msgid "<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>" +msgstr "" + +#. xyF8R +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id721575066374340\n" +"help.text" +msgid "<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." +msgstr "" + +#. NhW28 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id951575063536153\n" +"help.text" +msgid "“delta” or “d”." +msgstr "" + +#. DVKPe +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id361575063554232\n" +"help.text" +msgid "“gamma” or “g”." +msgstr "" + +#. mY7eD +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id961575063563017\n" +"help.text" +msgid "“theta” or “t”." +msgstr "" + +#. 7BNpN +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id971575063570632\n" +"help.text" +msgid "“vega” or “e”." +msgstr "" + +#. F4AQk +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id631575063580705\n" +"help.text" +msgid "“volga” or “o”." +msgstr "" + +#. DcBfK +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id981575063594505\n" +"help.text" +msgid "“vanna” or “a”." +msgstr "" + +#. vjCq4 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id191575063598656\n" +"help.text" +msgid "“rho” or “r”." +msgstr "" + +#. NGCqj +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id751575063602288\n" +"help.text" +msgid "“rhof” or “f”." +msgstr "" + +#. qxDa7 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id181575063666675\n" +"help.text" +msgid "<input>=OPT_TOUCH(50,0.25,0.05,0,1,0,55,\"d\",\"i\",\"c\")</input> returns the value 0.6876." +msgstr "" + +#. gyEVF +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id811575063677250\n" +"help.text" +msgid "<input>=OPT_TOUCH(80,0.2,0.05,0,0.5,60,0,\"f\",\"o\",\"c\",\"r\")</input> returns the value 15.5516." +msgstr "" + +#. ychjG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id121575125779535\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060103.xhp\">Financial Functions Part One</link>" +msgstr "" + +#. aX7LC +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id251575125873714\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060119.xhp\">Financial Functions Part Two</link>" +msgstr "" + +#. Q7SFh +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id191575125878595\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060118.xhp\">Financial Functions Part Three</link>" +msgstr "" + #. zr5G3 #: func_rawsubtract.xhp msgctxt "" |