Updated July 5th, 2023 by Raphaël Candalot
MM_CHECKISIN function
Description Checks that the International Securities Identification Number (ISIN) input in the function is valid. Returns 1 if the ISIN is valid, 0 otherwise. Syntax =MM_CHECKISIN("ISINCodeValue") "ISINCodeValue" String. ISIN to check.Returns 1 if the ISIN is valid, 0 otherwise. Remarks The algorithm used to check if the ISIN code is valid is the fo...
0 min reading time
Updated February 28th, 2023 by Raphaël Candalot
MM_VLOOKUPOPTIMIZED function
Description Returns the value of the item corresponding to the lookupvalue in the corresponding column (works by row). Optimized runtime version of classic VLOOKUP function (without dimensional cells in range). Syntax =MM_VLOOKUPOPTIMIZED(Lookup_value, Table_array, Col_index_num, [Range_lookup]) Lookup_value The value you want to lookup (could be a ...
0 min reading time
Updated February 28th, 2023 by Raphaël Candalot
MM_HLOOKUPOPTIMIZED function
Description Returns the value of the item corresponding to the lookupvalue in the corresponding column (works by column). Optimized runtime version of classic HLOOKUP function(without dimensional cells in range). Syntax =MM_HLOOKUPOPTIMIZED(Lookup_value, Table_array, Col_index_num, [Range_lookup]) Lookup_value The value you want to lookup (could be ...
0 min reading time
Updated September 13th, 2023 by Raphaël Candalot
MM_SIMQUANTILE function
Description Returns the value of the simulation corresponding to the desired quantile. Syntax =MM_SIMQUANTILE(Value, Quantile) Value Cell in which simulations are generated (with functions such as RANDOM, MM_SIMULATE_MS , and so on.) . Quantile The value at which the cumulative distribution function is evaluated. Remarks Note that in Excel, the de...
0 min reading time
Updated February 28th, 2023 by Raphaël Candalot
MM_MATCHOPTIMIZED function
Description Returns the relative position of the specified item in a range of cells. Optimized runtime version of classic MATCH function (without dimensional cells in range). Syntax =MM_MATCHOPTIMIZED(Lookup_value, Lookup_array, Match_type) Lookup_value The value you want to match in the lookup_array. Lookup_array The range of cells being searched. ...
0 min reading time
