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) |