# VALUEATRISK

## Description

Value at risk is a currency-denominated measurement of the loss a portfolio (or financial instrument) would experience over a specified investment horizon. This is a common method for assessing risk. The Excel Lab function allows you to estimate value at risk both at the end of an investment horizon as well as throughout the investment horizon (risk measured continuously, within-horizon).

{% hint style="info" %}
See <https://insights.windhamlabs.com/insights/rethinking-exposure-to-loss> for an introduction to stress testing your portfolios and assessing a more realistic measurement of exposure to loss.
{% endhint %}

## Syntax

The following describes the function signature for use in Microsoft Excel's formula bar.

```excel-formula
=VALUEATRISK(value, mu, sigma, horizon, threshold, estWithinHorizon)
```

### Input(s)

| Argument             | Description                                                                                                                                                                          |
| -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **value**            | Required. Vector / scalar value of portfolio wealth.                                                                                                                                 |
| **mu**               | Required. Vector / scalar value of portfolio return estimate(s).                                                                                                                     |
| **sigma**            | Required. Vector / scalar value of portfolio risk estimate(s).                                                                                                                       |
| **horizon**          | Required. Investment time horizon in the same time units of return and risk.                                                                                                         |
| **threshold**        | Required. Threshold for tail risk, this determines the area of the probability distribution to evaluate. You can interprete this as one minus your confidence probability.           |
| **estWithinHorizon** | Optional. Logical flag (TRUE or FALSE) to indicate whether you would like to calculate the within-horizon risk measurement. If this argument is not specified, it defaults to false. |

### Output(s)

Value at Risk estimate(s).

## Example

![](https://258561627-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MK66-MGuoULhqCDXLwy%2F-ML9xJBq4fvGOwU8AX_1%2F-MLABSH5_UwvqNK0hMgE%2Fimage.png?alt=media\&token=5cc6ec6f-6160-4e25-9117-3f804c1d573d)

{% file src="<https://258561627-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MK66-MGuoULhqCDXLwy%2F-MQVCAvzlf5zXAV1VImZ%2F-MLAF87MfxBuzSO-Yjwz%2FVALUEATRISK.xlsx?alt=media&token=6f30c700-9f49-4332-9510-4b83d6e25b8e>" %}
Example Workbook: VALUEATRISK
{% endfile %}