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.