SERIES SPL Directory

 

The Series directory contains SPL functions for manipulating series, and identifying points of interest in a series. The following functions are included:

 

ALL

Returns 1 if all elements of the input are non-zero.

ANY

Returns 1 if any element of the input is non-zero.

COLPROD

Calculates the product of each column of an array.

FINDCOL

Returns the column numbers that meet a condition.

FINDMAX

Returns the X and Y value of the maximum of a series.

FINDMIN

Returns the X and Y value of the minimum of a series.

FINDROW

Returns the row numbers that meet a condition.

FINDVAL

Returns the X and Y values of a series from a specified Y value.

FIX

Rounds a value towards zero.

IDXTOX

Converts index values of a series to X values.

MARKMAX

Marks the maximum of a series with a symbol.

MARKMIN

Marks the minimum of a series with a symbol.

MAXVAL

Returns the maximum of one or two input arguments.

MINVAL

Returns the minimum of one or two input arguments.

NIBBLE

Extracts a 4 bit nibble from a value.

NUMEL

Returns the total number of array elements.

OUTLIER

Replace outliers with linear interpolation of neighboring values.

PROD

Calculates the product of all values of a series or array.

RAT

Calculates a rational approximation using the continued fraction.

RELEASE

Releases an ActiveX server object.

REM

Determine the remainder from a division.

REPLACE

Replaces values based on a logical condition.

SIZE

Returns a 2 point series containing the dimensions of an array.

SIGN

Returns the sign of a real, complex or series.

VALFILL

Replaces a value with previous or next value.

VMAX

Returns the maximum of one or more input arguments.

VMIN

Returns the minimum of one or more input arguments.

XTOIDX

Converts X values of a series to indices.

XYLOOKUP

Interpolates Y values from arbitrary X values.