Returns the value of a specified risk measure evaluated for a given multidimensional cell. You can specify which loop dimensions you want to access. 

Syntax

=MM_RM(Cell, "RM", [Param], ["Name", Index], ["Name2", Index2], ...)

• Cell
  Cell that contains values on which you want to evaluate the risk measure.

• "RM"
  String.
  To check all supported risk measures, check MM_RISKMEASURESLIST function‍. 

• Param (optional)
  Parameter of the risk measure.
  For value at risk and tail value at risk measures, it represents the desired quantile. For probability of ruin measure, it refers to the ruin limit value.

• "Name", Index (optional)
  String, Integer.
  Name and dimension index of the first loop whose results you want to access. 

• "Name2", Index2 (optional)
  String, Integer.
  Name and dimension index of the second loop whose results you want to access. 

• ...
  Other loop specifications. 

Remarks

• If you do not mention one or several loops in the parameters, the function will take all results for this/these loop(s). 

• You cannot specify the same loop with different dimensions. If you want to take into account two different dimensions of the same loop (but not the other dimensions), use twice the MM_RESULT function for each dimension you want to access.

• If you input loop specifications, you must also input Param because Mind does not accept empty parameters. You can put an arbitrary value if the risk measure chosen does not require it.

Example 1: Simulations

Formula 1: =MM_SIMULATE_MS("Poisson",10,1)
This function simulates a Poisson distribution with mean and standard deviation equal to 10 and 1, respectively.

Formula 2: =MM_RM(A2,"VAR",0.9) calculates the 90% value at risk of cell A2.
For 1000 simulations, it returns 14.

Example 2: Multiple loops 

In this example, we define two loops of dimension size 4 each: Product and Scenario. Cell D2 is the sum of these two loops. Thus, it has a total number of dimensions equal to 16.

The formula =MM_RM(D2,"Mean") returns the mean of these 16 values, which is 251.25.

Example 3: Multiple loops with one loop specification

Now, let us add one loop specification: in this case, the first dimension of the loop Product.
The formula =MM_RM(D2,"Mean",0,"Product",1) takes into account the values of cell D2 for the first dimension of the loop Product, which amounts to 4 values: 98, 99, 103 and 105. It returns 101.25.

Example 4: Variable loop specification 

Following the previous example, if you want the index of the loop Product to be a variable so that you can access it in Mind use the MM_DIMINDEX function.

As you can see on the top left corner of the table, you can navigate through the different indexes of the loop Product. For index 1, it returns 101.25; for index 2, it returns 201.25, and so on.

If you want to specify variable simulations similarly, replace the loop specification by "SIM",MM_DIM_INDEX("SIM").

Example 5: Remark

You can mix the different examples and use more than one loop specification with loops and/or simulations.