Browsing Basque translation

13.

@FUNCTION=OPT_RGW
@SYNTAX=OPT_RGW(call_put_flag,spot,strike,t1,t2,rate,d,volatility)
@DESCRIPTION=OPT_RGW models the theoretical price of an american option according to the Roll-Geske-Whaley approximation where:
@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
@spot is the spot price of the underlying asset.
@strike is the strike price at which the option is struck.
@t1 is the time to the dividend payout.
@t2 is the time to option expiration.
@rate is the annualized rate of interest.
@d is the amount of the dividend to be paid.
@volatility is the annualized rate of volatility of the underlying asset.

@EXAMPLES=

@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA

15.

@FUNCTION=OPT_BJER_STENS
@SYNTAX=OPT_BJER_STENS(call_put_flag,spot,strike,time,rate,volatility[,cost_of_carry])
@DESCRIPTION=OPT_BJER_STENS models the theoretical price of american options according to the Bjerksund & Stensland approximation technique.
@call_put_flag is 'c' or 'p' to indicate whether the option is a call or a put.
@spot is the spot price of the underlying asset.
@strike is the strike price at which the option is struck.
@time is the number of days to maturity of the option.
@rate is the annualized risk-free rate of interest.
@volatility is the annualized volatility in price of the underlying asset.
@cost_of_carry is the leakage in value of the underlying asset, for common stocks, this would be the dividend yield.

@EXAMPLES=

@SEEALSO=OPT_BS, OPT_BS_DELTA, OPT_BS_RHO, OPT_BS_THETA, OPT_BS_GAMMA

124.

@FUNCTION=BESSELI
@SYNTAX=BESSELI(x,y)
@DESCRIPTION=BESSELI function returns the Neumann, Weber or Bessel function.

@x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.

* If @x or @y are not numeric a #VALUE! error is returned.
* If @y < 0 a #NUM! error is returned.
* This function is Excel compatible.

@EXAMPLES=
BESSELI(0.7,3) equals 0.007367374.

@SEEALSO=BESSELJ,BESSELK,BESSELY

125.

@FUNCTION=BESSELK
@SYNTAX=BESSELK(x,y)
@DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.

* If @x or @y are not numeric a #VALUE! error is returned.
* If @y < 0 a #NUM! error is returned.
* This function is Excel compatible.

@EXAMPLES=
BESSELK(3,9) equals 397.95880.

@SEEALSO=BESSELI,BESSELJ,BESSELY

158.

@FUNCTION=RATE
@SYNTAX=RATE(nper,pmt,pv[,fv,type,guess])
@DESCRIPTION=RATE calculates the rate of an investment.

* If @pmt is ommitted it defaults to 0
* If @nper <= 0, RATE returns #NUM! error.
* If @type != 0 and @type != 1, RATE returns #VALUE! error.

@EXAMPLES=

@SEEALSO=PV,FV

229.

@FUNCTION=INDIRECT
@SYNTAX=INDIRECT(ref_text[,format])
@DESCRIPTION=INDIRECT function returns the contents of the cell pointed to by the @ref_text string. The string specifies a single cell reference the format of which is either A1 or R1C1 style. The style is set by the @format boolean, which defaults to the A1 style.

* If @ref_text is not a valid reference returns #REF!
@EXAMPLES=
If A1 contains 3.14 and A2 contains A1, then
INDIRECT(A2) equals 3.14.

@SEEALSO=AREAS,INDEX,CELL

570.

@FUNCTION=ZTEST
@SYNTAX=ZTEST(ref,x)
@DESCRIPTION=ZTEST returns the two-tailed probability of a z-test.

@ref is the data set and @x is the value to be tested.

* If @ref contains less than two data items ZTEST returns #DIV/0! error.
* This function is Excel compatible.

@EXAMPLES=
Let us assume that the cells A1, A2, ..., A5 contain numbers 11.4, 17.3, 21.3, 25.9, and 40.1. Then
ZTEST(A1:A5,20) equals 0.254717826.

@SEEALSO=CONFIDENCE,NORMDIST,NORMINV,NORMSDIST,NORMSINV,STANDARDIZE

600.

@FUNCTION=EXPPOWDIST
@SYNTAX=EXPPOWDIST(x,a,b)
@DESCRIPTION=EXPPOWDIST returns the probability density p(x) at @x for Exponential Power distribution with scale parameter @a and exponent @b.
This distribution has been recommended for lifetime analysis when a U-shaped hazard function is desired. This corresponds to rapid failure once the product starts to wear out after a period of steady or even improving reliability.
@EXAMPLES=
EXPPOWDIST(0.4,1,2).

@SEEALSO=RANDEXPPOW

629.

@FUNCTION=interpolation
@SYNTAX=interpolation(abscissas,ordinates,targets[,interpolation])
@DESCRIPTION=
interpolation returns interpolated values corresponding
to the given abscissa targets as a one column matrix.

@abscissas are the absicssas of the data to interpolate.
@ordinates are the ordinates of the data to interpolate.
* Strings and empty cells in @abscissas and @ordinates are simply ignored.
@targets are the abscissas of the interpolated data. If several data
are provided, they must be in the same column, in consecutive cells
@interpolation is the method to be used for the interpolation;
possible values are:
- 0: linear;
- 1: linear with averaging;
- 2: staircase;
- 3: staircase with averaging;
- 4: natural cubic spline;
- 5: natural cubic spline with averaging.

If an averaging method is used, the number of returned values
is one less than the number of targets since the evaluation is made by
averaging the interpolation over the interval between two consecutive data;
in that case, the targets values must be given in increasing order.

630.

@FUNCTION=periodogram
@SYNTAX=periodogram(ordinates,[filter,[abscissas,[interpolation,[number]]]])
@DESCRIPTION=
periodogram returns the periodogram of the data
as a one column matrix.

@ordinates are the ordinates of the data to interpolate.
@filter gives the window function to be used. Possible values are:
- 0: no filter (rectangular window);
- 1: Bartlett (triangular window);
- 2: Hahn (cosine window);
- 3: Welch (parabolic window);
@abscissas are the absicssas of the data to interpolate. If no
abscissa is given, it is supposed that the data absicssas are regularly
spaced. Otherwise, an interpolation method will be used to evaluate
regularly spaced data.
* Strings and empty cells in @abscissas and @ordinates are simply ignored.
@interpolation is the method to be used for the interpolation;
possible values are:
- 0: linear;
- 1: linear with averaging;
- 2: staircase;
- 3: staircase with averaging;
- 4: natural cubic spline;
- 5: natural cubic spline with averaging.
@number is the number of interpolated data to be used. If not given,
a default number is automatically evaluated.