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. Risk Models

TURBULENTRISK

A robust statistical risk model using the Mahalanobis distance.

PreviousPORTFOLIORISKNextQUIETRISK

Last updated 3 years ago

Description

Using the Mahalanobis distance, this risk model characterizes the degree of unusualness in a cross section of asset returns and partitions the historical data into periods of financial turbulence and quiecense. These periods are usually marked by large asset movements (volatility) and/or unusual changes in correlations (e.g. when non-correlated assets become correlated) and considered statistical outliers.

The risk model is useful for stress testing and constructing resilient portfolios.

This risk model is also available in the Windham Portfolio Advisor. For a deeper dive into the model, please see

Syntax

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

=TURBULENTRISK(type, assetReturns, threshold, dataPeriodicity)

Input(s)

Argument
Description

type

Required. Enumeration string to specify calculation type: "risk", "sigma", or "stdev" "correlation", "corr", or "rho", "covariance", "covar", or "cov"

assetReturns

Required. Time series or matrix of asset returns.

threshold

dataPeriodicity

Optional. Periodicity of the data, used for annualization. If you do not enter the argument, it defaults to 1. e.g. Daily = 255, Monthly = 12, Yearly = 1, Quarterly = 4.

Output(s)

Depending on the specified output type, the function will return the respective vector of risk estimates (annualized standard deviations), correlation matrix, or a covariance matrix.

Example

The following video describes the conceptual application of this methodology.

Required. Probability threshold of turbulent periods (0.00 - 1.00). This threshold is the converted into the equivalent chi-squared,, score. Under a multivariate normal assumption, the cutoff can be interpreted as an approximation of the percentage of the sub-sample of outliers (turbulent). This approximation may vary depending on the underlying characteristics of the empirical data.

χN2\chi_{N}^2χN2​
https://wpahelp.windhamlabs.com/expected-risk/quiet-and-turbulent-risk
Windham's Risk Model
71KB
TURBULENTRISK.xlsx
Example Workbook: TURBULENTRISK