316
316
"@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA"
319
#: ../plugins/derivatives/options.c:1048
319
#: ../plugins/derivatives/options.c:1050
322
322
"@FUNCTION=OPT_RGW\n"
323
"@SYNTAX=OPT_RGW(call_put_flag,spot,strike,t1,t2,rate,d,volatility)\n"
324
"@DESCRIPTION=OPT_RGW models the theoretical price of an american option "
323
"@SYNTAX=OPT_RGW(spot,strike,t1,t2,rate,d,volatility)\n"
324
"@DESCRIPTION=OPT_RGW models the theoretical price of an American option "
325
325
"according to the Roll-Geske-Whaley approximation where: \n"
326
"@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a "
328
326
"@spot is the spot price of the underlying asset.\n"
329
327
"@strike is the strike price at which the option is struck.\n"
330
328
"@t1 is the time to the dividend payout.\n"
331
329
"@t2 is the time to option expiration.\n"
332
330
"@rate is the annualized rate of interest.\n"
333
"@d is the amount of the dividend to be paid.\n"
331
"@d is the amount of the dividend to be paid expressed in currency.\n"
334
332
"@volatility is the annualized rate of volatility of the underlying asset.\n"
5119
5151
"@SEEALSO=LOOKUP"
5122
#: ../plugins/fn-lookup/functions.c:809
5154
#: ../plugins/fn-lookup/functions.c:971
5124
5156
"@FUNCTION=INDIRECT\n"
5125
5157
"@SYNTAX=INDIRECT(ref_text[,format])\n"
5126
5158
"@DESCRIPTION=INDIRECT function returns the contents of the cell pointed to "
5127
5159
"by the @ref_text string. The string specifies a single cell reference the "
5128
"format of which is either A1 or R1C1 style. The style is set by the @format "
5129
"boolean, which defaults to the A1 style.\n"
5160
"format of which is either A1 or R1C1 style. The boolean @format controls how "
5161
"@ref_text is to be interpreted: TRUE (the default) for A1 style and FALSE "
5131
"* If @ref_text is not a valid reference returns #REF! \n"
5164
"* If @ref_text is not a valid reference in the style controlled by @format, "
5133
"If A1 contains 3.14 and A2 contains A1, then\n"
5167
"If A1 contains 3.14 and A2 contains \"A1\", then\n"
5134
5168
"INDIRECT(A2) equals 3.14.\n"
5170
"If B1 contains 23 and A1 contains \"R1C2\", then\n"
5171
"INDIRECT(A1,FALSE) equals 23.\n"
5136
5172
"@SEEALSO=AREAS,INDEX,CELL"
5139
#: ../plugins/fn-lookup/functions.c:858
5175
#: ../plugins/fn-lookup/functions.c:1023
5141
5177
"@FUNCTION=INDEX\n"
5142
5178
"@SYNTAX=INDEX(array[,row, col, area])\n"
5707
#: ../plugins/fn-math/functions.c:1048
5743
#: ../plugins/fn-math/functions.c:1055
5708
5744
msgid "FLOOR:rounds down."
5711
#: ../plugins/fn-math/functions.c:1049
5747
#: ../plugins/fn-math/functions.c:1056
5712
5748
msgid "x:value."
5715
#: ../plugins/fn-math/functions.c:1050
5751
#: ../plugins/fn-math/functions.c:1057
5716
5752
msgid "significance:base multiple (defaults to 1 for @x > 0 and -1 for @x <0)"
5719
#: ../plugins/fn-math/functions.c:1052
5755
#: ../plugins/fn-math/functions.c:1059
5721
5757
"FLOOR function rounds @x down to the next nearest multiple of @significance."
5724
#: ../plugins/fn-math/functions.c:1054
5760
#: ../plugins/fn-math/functions.c:1061
5725
5761
msgid "FLOOR(0.5) equals 0."
5728
#: ../plugins/fn-math/functions.c:1055
5764
#: ../plugins/fn-math/functions.c:1062
5729
5765
msgid "FLOOR(5,2) equals 4."
5732
#: ../plugins/fn-math/functions.c:1056
5768
#: ../plugins/fn-math/functions.c:1063
5733
5769
msgid "FLOOR(-5,-2) equals -4."
5736
#: ../plugins/fn-math/functions.c:1057
5772
#: ../plugins/fn-math/functions.c:1064
5737
5773
msgid "FLOOR(-5,2) equals #NUM!."
5740
#: ../plugins/fn-math/functions.c:1084
5776
#: ../plugins/fn-math/functions.c:1091
5742
5778
"@FUNCTION=INT\n"
5743
5779
"@SYNTAX=INT(a)\n"
6426
6462
"@SEEALSO=MMULT, MINVERSE"
6429
#: ../plugins/fn-math/functions.c:3172
6465
#: ../plugins/fn-math/functions.c:3179
6430
6466
msgid "SUMPRODUCT:Multiplies components and adds the results."
6433
#: ../plugins/fn-math/functions.c:3174
6469
#: ../plugins/fn-math/functions.c:3181
6435
6471
"Multiplies corresponding data entries in the given arrays or ranges, and "
6436
6472
"then returns the sum of those products."
6439
#: ../plugins/fn-math/functions.c:3177
6475
#: ../plugins/fn-math/functions.c:3184
6440
6476
msgid "If an entry is not numeric, the value zero is used instead."
6443
#: ../plugins/fn-math/functions.c:3178
6479
#: ../plugins/fn-math/functions.c:3185
6445
6481
"If arrays or range arguments do not have the same dimensions, return #VALUE! "
6449
#: ../plugins/fn-math/functions.c:3180
6485
#: ../plugins/fn-math/functions.c:3187
6451
6487
"SUMPRODUCTs arguments are arrays or ranges. Attempting to use A1:A5>0 will "
6452
6488
"not work, implicit intersection will kick in. Instead use --(A1:A5>0)"
10266
10303
"@FUNCTION=atl_last\n"
10267
10304
"@SYNTAX=ATL_LAST (tag)\n"
10305
"@DESCRIPTION=ATL_LAST is a sample implementation of a real time data source. "
10306
"It takes a string tag and monitors the named pipe /tmp/atl for changes to "
10307
"the value of that tag.\n"
10309
"* This is not intended to be generally enabled and is OFF by default.\n"
10312
"ATL_LAST(\"IBM\")\n"
10316
#: ../plugins/derivatives/options.c:1048
10319
"@FUNCTION=OPT_RGW\n"
10320
"@SYNTAX=OPT_RGW(call_put_flag,spot,strike,t1,t2,rate,d,volatility)\n"
10321
"@DESCRIPTION=OPT_RGW models the theoretical price of an american option "
10322
"according to the Roll-Geske-Whaley approximation where: \n"
10323
"@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a "
10325
"@spot is the spot price of the underlying asset.\n"
10326
"@strike is the strike price at which the option is struck.\n"
10327
"@t1 is the time to the dividend payout.\n"
10328
"@t2 is the time to option expiration.\n"
10329
"@rate is the annualized rate of interest.\n"
10330
"@d is the amount of the dividend to be paid.\n"
10331
"@volatility is the annualized rate of volatility of the underlying asset.\n"
10335
"@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA"
10338
#: ../plugins/derivatives/options.c:1291
10341
"@FUNCTION=OPT_BJER_STENS\n"
10342
"@SYNTAX=OPT_BJER_STENS(call_put_flag,spot,strike,time,rate,volatility[,"
10343
"cost_of_carry])\n"
10344
"@DESCRIPTION=OPT_BJER_STENS models the theoretical price of american options "
10345
"according to the Bjerksund & Stensland approximation technique.\n"
10346
"@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a "
10348
"@spot is the spot price of the underlying asset.\n"
10349
"@strike is the strike price at which the option is struck.\n"
10350
"@time is the number of days to maturity of the option.\n"
10351
"@rate is the annualized risk-free rate of interest.\n"
10352
"@volatility is the annualized volatility in price of the underlying asset.\n"
10353
"@cost_of_carry is the leakage in value of the underlying asset, for common "
10354
"stocks, this would be the dividend yield.\n"
10358
"@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA"
10361
#: ../plugins/fn-eng/functions.c:650
10363
"@FUNCTION=BESSELI\n"
10364
"@SYNTAX=BESSELI(x,y)\n"
10365
"@DESCRIPTION=BESSELI function returns the Neumann, Weber or Bessel "
10368
"@x is where the function is evaluated. @y is the order of the Bessel "
10369
"function, if non-integer it is truncated.\n"
10371
"* If @x or @y are not numeric a #VALUE! error is returned.\n"
10372
"* If @y < 0 a #NUM! error is returned.\n"
10373
"* This function is Excel compatible.\n"
10376
"BESSELI(0.7,3) equals 0.007367374.\n"
10378
"@SEEALSO=BESSELJ,BESSELK,BESSELY"
10381
#: ../plugins/fn-eng/functions.c:693
10383
"@FUNCTION=BESSELK\n"
10384
"@SYNTAX=BESSELK(x,y)\n"
10385
"@DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. "
10386
"@x is where the function is evaluated. @y is the order of the Bessel "
10387
"function, if non-integer it is truncated.\n"
10389
"* If @x or @y are not numeric a #VALUE! error is returned.\n"
10390
"* If @y < 0 a #NUM! error is returned.\n"
10391
"* This function is Excel compatible.\n"
10394
"BESSELK(3,9) equals 397.95880.\n"
10396
"@SEEALSO=BESSELI,BESSELJ,BESSELY"
10399
#: ../plugins/fn-financial/functions.c:1481
10402
"@SYNTAX=RATE(nper,pmt,pv[,fv,type,guess])\n"
10403
"@DESCRIPTION=RATE calculates the rate of an investment.\n"
10405
"* If @pmt is ommitted it defaults to 0\n"
10406
"* If @nper <= 0, RATE returns #NUM! error.\n"
10407
"* If @type != 0 and @type != 1, RATE returns #VALUE! error.\n"
10414
#: ../plugins/fn-lookup/functions.c:809
10416
"@FUNCTION=INDIRECT\n"
10417
"@SYNTAX=INDIRECT(ref_text[,format])\n"
10418
"@DESCRIPTION=INDIRECT function returns the contents of the cell pointed to "
10419
"by the @ref_text string. The string specifies a single cell reference the "
10420
"format of which is either A1 or R1C1 style. The style is set by the @format "
10421
"boolean, which defaults to the A1 style.\n"
10423
"* If @ref_text is not a valid reference returns #REF! \n"
10425
"If A1 contains 3.14 and A2 contains A1, then\n"
10426
"INDIRECT(A2) equals 3.14.\n"
10428
"@SEEALSO=AREAS,INDEX,CELL"
10431
#: ../plugins/fn-stat/functions.c:3015
10433
"@FUNCTION=ZTEST\n"
10434
"@SYNTAX=ZTEST(ref,x)\n"
10435
"@DESCRIPTION=ZTEST returns the two-tailed probability of a z-test.\n"
10437
"@ref is the data set and @x is the value to be tested.\n"
10439
"* If @ref contains less than two data items ZTEST returns #DIV/0! error.\n"
10440
"* This function is Excel compatible.\n"
10443
"Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, "
10444
"21.3, 25.9, and 40.1. Then\n"
10445
"ZTEST(A1:A5,20) equals 0.254717826.\n"
10447
"@SEEALSO=CONFIDENCE,NORMDIST,NORMINV,NORMSDIST,NORMSINV,STANDARDIZE"
10450
#: ../plugins/sample_datasource/sample_datasource.c:272
10453
"@FUNCTION=atl_last\n"
10454
"@SYNTAX=ATL_LAST (tag)\n"
10268
10455
"@DESCRIPTION=ATL_LAST is a sample implemention of a real time data source. "
10269
10456
"It takes a string tag and monitors the named pipe /tmp/atl for changes to "
10270
10457
"the value of that tag.\n"