313
313
"@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA"
316
#: ../plugins/derivatives/options.c:1048
316
#: ../plugins/derivatives/options.c:1050
319
319
"@FUNCTION=OPT_RGW\n"
320
"@SYNTAX=OPT_RGW(call_put_flag,spot,strike,t1,t2,rate,d,volatility)\n"
321
"@DESCRIPTION=OPT_RGW models the theoretical price of an american option "
320
"@SYNTAX=OPT_RGW(spot,strike,t1,t2,rate,d,volatility)\n"
321
"@DESCRIPTION=OPT_RGW models the theoretical price of an American option "
322
322
"according to the Roll-Geske-Whaley approximation where: \n"
323
"@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a "
325
323
"@spot is the spot price of the underlying asset.\n"
326
324
"@strike is the strike price at which the option is struck.\n"
327
325
"@t1 is the time to the dividend payout.\n"
328
326
"@t2 is the time to option expiration.\n"
329
327
"@rate is the annualized rate of interest.\n"
330
"@d is the amount of the dividend to be paid.\n"
328
"@d is the amount of the dividend to be paid expressed in currency.\n"
331
329
"@volatility is the annualized rate of volatility of the underlying asset.\n"
6161
6195
"@SEEALSO=LOOKUP"
6164
#: ../plugins/fn-lookup/functions.c:809
6198
#: ../plugins/fn-lookup/functions.c:971
6166
6200
"@FUNCTION=INDIRECT\n"
6167
6201
"@SYNTAX=INDIRECT(ref_text[,format])\n"
6168
6202
"@DESCRIPTION=INDIRECT function returns the contents of the cell pointed to "
6169
6203
"by the @ref_text string. The string specifies a single cell reference the "
6170
"format of which is either A1 or R1C1 style. The style is set by the @format "
6171
"boolean, which defaults to the A1 style.\n"
6204
"format of which is either A1 or R1C1 style. The boolean @format controls how "
6205
"@ref_text is to be interpreted: TRUE (the default) for A1 style and FALSE "
6173
"* If @ref_text is not a valid reference returns #REF! \n"
6208
"* If @ref_text is not a valid reference in the style controlled by @format, "
6175
"If A1 contains 3.14 and A2 contains A1, then\n"
6211
"If A1 contains 3.14 and A2 contains \"A1\", then\n"
6176
6212
"INDIRECT(A2) equals 3.14.\n"
6214
"If B1 contains 23 and A1 contains \"R1C2\", then\n"
6215
"INDIRECT(A1,FALSE) equals 23.\n"
6178
6216
"@SEEALSO=AREAS,INDEX,CELL"
6181
#: ../plugins/fn-lookup/functions.c:858
6219
#: ../plugins/fn-lookup/functions.c:1023
6183
6221
"@FUNCTION=INDEX\n"
6184
6222
"@SYNTAX=INDEX(array[,row, col, area])\n"
7036
7074
"@SEEALSO=IMCOS,IMTAN"
7038
#: ../plugins/fn-math/functions.c:1048
7076
#: ../plugins/fn-math/functions.c:1055
7039
7077
msgid "FLOOR:rounds down."
7042
#: ../plugins/fn-math/functions.c:1049
7080
#: ../plugins/fn-math/functions.c:1056
7043
7081
msgid "x:value."
7046
#: ../plugins/fn-math/functions.c:1050
7084
#: ../plugins/fn-math/functions.c:1057
7047
7085
msgid "significance:base multiple (defaults to 1 for @x > 0 and -1 for @x <0)"
7050
#: ../plugins/fn-math/functions.c:1052
7088
#: ../plugins/fn-math/functions.c:1059
7052
7090
"FLOOR function rounds @x down to the next nearest multiple of @significance."
7055
#: ../plugins/fn-math/functions.c:1054
7093
#: ../plugins/fn-math/functions.c:1061
7056
7094
msgid "FLOOR(0.5) equals 0."
7059
#: ../plugins/fn-math/functions.c:1055
7097
#: ../plugins/fn-math/functions.c:1062
7060
7098
msgid "FLOOR(5,2) equals 4."
7063
#: ../plugins/fn-math/functions.c:1056
7101
#: ../plugins/fn-math/functions.c:1063
7064
7102
msgid "FLOOR(-5,-2) equals -4."
7067
#: ../plugins/fn-math/functions.c:1057
7105
#: ../plugins/fn-math/functions.c:1064
7068
7106
msgid "FLOOR(-5,2) equals #NUM!."
7071
#: ../plugins/fn-math/functions.c:1084
7109
#: ../plugins/fn-math/functions.c:1091
7073
7111
"@FUNCTION=INT\n"
7074
7112
"@SYNTAX=INT(a)\n"
12616
12655
"@FUNCTION=atl_last\n"
12617
12656
"@SYNTAX=ATL_LAST (tag)\n"
12657
"@DESCRIPTION=ATL_LAST is a sample implementation of a real time data source. "
12658
"It takes a string tag and monitors the named pipe /tmp/atl for changes to "
12659
"the value of that tag.\n"
12661
"* This is not intended to be generally enabled and is OFF by default.\n"
12664
"ATL_LAST(\"IBM\")\n"
12668
#: ../plugins/derivatives/options.c:1048
12671
"@FUNCTION=OPT_RGW\n"
12672
"@SYNTAX=OPT_RGW(call_put_flag,spot,strike,t1,t2,rate,d,volatility)\n"
12673
"@DESCRIPTION=OPT_RGW models the theoretical price of an american option "
12674
"according to the Roll-Geske-Whaley approximation where: \n"
12675
"@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a "
12677
"@spot is the spot price of the underlying asset.\n"
12678
"@strike is the strike price at which the option is struck.\n"
12679
"@t1 is the time to the dividend payout.\n"
12680
"@t2 is the time to option expiration.\n"
12681
"@rate is the annualized rate of interest.\n"
12682
"@d is the amount of the dividend to be paid.\n"
12683
"@volatility is the annualized rate of volatility of the underlying asset.\n"
12687
"@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA"
12690
#: ../plugins/derivatives/options.c:1291
12693
"@FUNCTION=OPT_BJER_STENS\n"
12694
"@SYNTAX=OPT_BJER_STENS(call_put_flag,spot,strike,time,rate,volatility[,"
12695
"cost_of_carry])\n"
12696
"@DESCRIPTION=OPT_BJER_STENS models the theoretical price of american options "
12697
"according to the Bjerksund & Stensland approximation technique.\n"
12698
"@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a "
12700
"@spot is the spot price of the underlying asset.\n"
12701
"@strike is the strike price at which the option is struck.\n"
12702
"@time is the number of days to maturity of the option.\n"
12703
"@rate is the annualized risk-free rate of interest.\n"
12704
"@volatility is the annualized volatility in price of the underlying asset.\n"
12705
"@cost_of_carry is the leakage in value of the underlying asset, for common "
12706
"stocks, this would be the dividend yield.\n"
12710
"@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA"
12713
#: ../plugins/fn-eng/functions.c:650
12715
"@FUNCTION=BESSELI\n"
12716
"@SYNTAX=BESSELI(x,y)\n"
12717
"@DESCRIPTION=BESSELI function returns the Neumann, Weber or Bessel "
12720
"@x is where the function is evaluated. @y is the order of the Bessel "
12721
"function, if non-integer it is truncated.\n"
12723
"* If @x or @y are not numeric a #VALUE! error is returned.\n"
12724
"* If @y < 0 a #NUM! error is returned.\n"
12725
"* This function is Excel compatible.\n"
12728
"BESSELI(0.7,3) equals 0.007367374.\n"
12730
"@SEEALSO=BESSELJ,BESSELK,BESSELY"
12732
"@FUNCTION=IMSIN\n"
12733
"@SYNTAX=IMSIN(inumber)\n"
12734
"@DESCRIPTION=IMSIN는 복소수의 사인 값을 구합니다.\n"
12736
"* 만약 @inumber 가 적절한 복소수 값이 아니라면, IMSIN는 #VALUE! 에러를 돌려줍"
12738
"* 이 함수는 엑셀과 호환됩니다.\n"
12741
"IMSIN(\"1+j\")의 값은 1.29846+0.63496j 입니다.\n"
12743
"@SEEALSO=IMCOS,IMTAN"
12745
#: ../plugins/fn-eng/functions.c:693
12747
"@FUNCTION=BESSELK\n"
12748
"@SYNTAX=BESSELK(x,y)\n"
12749
"@DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. "
12750
"@x is where the function is evaluated. @y is the order of the Bessel "
12751
"function, if non-integer it is truncated.\n"
12753
"* If @x or @y are not numeric a #VALUE! error is returned.\n"
12754
"* If @y < 0 a #NUM! error is returned.\n"
12755
"* This function is Excel compatible.\n"
12758
"BESSELK(3,9) equals 397.95880.\n"
12760
"@SEEALSO=BESSELI,BESSELJ,BESSELY"
12762
"@FUNCTION=IMSIN\n"
12763
"@SYNTAX=IMSIN(inumber)\n"
12764
"@DESCRIPTION=IMSIN는 복소수의 사인 값을 구합니다.\n"
12766
"* 만약 @inumber 가 적절한 복소수 값이 아니라면, IMSIN는 #VALUE! 에러를 돌려줍"
12768
"* 이 함수는 엑셀과 호환됩니다.\n"
12771
"IMSIN(\"1+j\")의 값은 1.29846+0.63496j 입니다.\n"
12773
"@SEEALSO=IMCOS,IMTAN"
12775
#: ../plugins/fn-financial/functions.c:1481
12778
"@SYNTAX=RATE(nper,pmt,pv[,fv,type,guess])\n"
12779
"@DESCRIPTION=RATE calculates the rate of an investment.\n"
12781
"* If @pmt is ommitted it defaults to 0\n"
12782
"* If @nper <= 0, RATE returns #NUM! error.\n"
12783
"* If @type != 0 and @type != 1, RATE returns #VALUE! error.\n"
12790
#: ../plugins/fn-lookup/functions.c:809
12792
"@FUNCTION=INDIRECT\n"
12793
"@SYNTAX=INDIRECT(ref_text[,format])\n"
12794
"@DESCRIPTION=INDIRECT function returns the contents of the cell pointed to "
12795
"by the @ref_text string. The string specifies a single cell reference the "
12796
"format of which is either A1 or R1C1 style. The style is set by the @format "
12797
"boolean, which defaults to the A1 style.\n"
12799
"* If @ref_text is not a valid reference returns #REF! \n"
12801
"If A1 contains 3.14 and A2 contains A1, then\n"
12802
"INDIRECT(A2) equals 3.14.\n"
12804
"@SEEALSO=AREAS,INDEX,CELL"
12807
#: ../plugins/fn-stat/functions.c:3015
12809
"@FUNCTION=ZTEST\n"
12810
"@SYNTAX=ZTEST(ref,x)\n"
12811
"@DESCRIPTION=ZTEST returns the two-tailed probability of a z-test.\n"
12813
"@ref is the data set and @x is the value to be tested.\n"
12815
"* If @ref contains less than two data items ZTEST returns #DIV/0! error.\n"
12816
"* This function is Excel compatible.\n"
12819
"Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, "
12820
"21.3, 25.9, and 40.1. Then\n"
12821
"ZTEST(A1:A5,20) equals 0.254717826.\n"
12823
"@SEEALSO=CONFIDENCE,NORMDIST,NORMINV,NORMSDIST,NORMSINV,STANDARDIZE"
12826
#: ../plugins/sample_datasource/sample_datasource.c:272
12829
"@FUNCTION=atl_last\n"
12830
"@SYNTAX=ATL_LAST (tag)\n"
12618
12831
"@DESCRIPTION=ATL_LAST is a sample implemention of a real time data source. "
12619
12832
"It takes a string tag and monitors the named pipe /tmp/atl for changes to "
12620
12833
"the value of that tag.\n"