Excel Lab
  • Excel Lab
  • Release Notes
  • Getting Started
    • Installing Excel Lab
      • Step 1: Download Files
      • Step 2: Register Libraries
      • Step 3: Activate Add-in
      • Step 4: Verify Installation
  • Functions
    • General
      • ISMATRIXPSD
      • MATRIX
      • XLABHELP
      • XLABINFO
      • XLABLICENSE
      • RESETPASSWORD
    • Return Models
      • CAPM
      • DESMOOTHRETURNS
      • IMPLIEDRETURNS
      • MLERETURNS
    • Risk Models
      • ANNUALIZERISK
      • EWMA
      • HISTORICALRISK
      • MLERISK
      • PORTFOLIORISK
      • TURBULENTRISK
      • QUIETRISK
    • Optimization
      • MVO
      • MTO
      • MVT
      • MVFRONTIER
      • MTFRONTIER
      • ISORETURN
    • Simulation
      • MCNORM
      • BOOTSTRAP
    • Exposure to Loss
      • LOSSPR
      • OMEGARATIO
      • SORTINORATIO
      • TAILRATIO
      • VALUEATRISK
      • MAXDD
    • Regression Analysis
      • FACTORANALYSIS
      • PSR
    • Scenario Analysis
      • MAHALANOBIS
      • SCENARIOPR
      • IMPLIEDSCENARIO
  • Frequently Asked Questions
    • Common Issues
    • FAQ
  • Further Reading
  • Windham's Research Insights
  • Watch Our Educational Videos
Powered by GitBook
On this page
  • Description
  • Syntax
  • Input(s)
  • Output(s)
  • Example
  1. Functions
  2. Exposure to Loss

VALUEATRISK

Estimate exposure to loss of your portfolio with the Value at Risk framework.

PreviousTAILRATIONextMAXDD

Last updated 3 years ago

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

See for an introduction to stress testing your portfolios and assessing a more realistic measurement of exposure to loss.

Syntax

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

=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://insights.windhamlabs.com/insights/rethinking-exposure-to-loss
61KB
VALUEATRISK.xlsx
Example Workbook: VALUEATRISK