Investment Studio > Expressions > Functions > Matrix

Also see Reference functions.

Result type Function name Arguments
float array[*][2] crosses (float array[*][*] values, integer value_column, float threshold)
    (float array[*][*] values, integer value_column, float array[*][*] thresholds, integer threshold_column)
float array[*][3] extrema (float array[*][*] table, integer column, boolean include_end_points = FALSE)
array[m][n] flipcols (array[m][n] argument)
array[m][n] fliprows (array[m][n] argument)
float array[n][n] m1 (integer n)
float array[n][1] makevector (integer n, float start = 1, float increment = 1)
float mdeterm (float array[n][n] argument)
float array[n][n] minverse (float array[n][n] argument)
float array[rows_a][columns_b] mmult (float array[rows_a][n] a, float array[n][columns_b] b)
array mop (string operation_string, array data [, ...])
float array[n][1] msolve (float array[n][n] a, float array[n][1] b)
array msort (array[*][*] table, boolean ascending = TRUE, boolean rowwise = TRUE)
float array[m][n] msub (float array[m][n] a, float array[m][n] b)
float array[m][n] msum (float array[m][n] a, float array[m][n] b)
float sumproduct (float array a, float array b [, ...])
float sumx2my2 (float array a, float array b)
float sumx2py2 (float array a, float array b)
float sumxmy2 (float array a, float array b)
array[m][n] swapcols (array[m][n] table, integer column_1, integer column_2)
array[m][n] swaprows (array[m][n] table, integer row_1, integer row_2)
array[*][*] sync (array[*][*] a, array[*][*] b, keep_unmatched = TRUE)
array[*][*] transpose (array argument)