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. Scenario Analysis

SCENARIOPR

Calculate relative scenario probabilities across a set of economic outcomes.

PreviousMAHALANOBISNextIMPLIEDSCENARIO

Last updated 3 years ago

Description

Calculate the relative probabilities of prospective economic scenarios. Employ this powerful statistical framework in your scenario analysis excercise. The function follows the research published in the Journal of Portfolio Management, March 2020.

Syntax

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

=SCENARIOPR(estimates, anchor, covariance, j, isReturnDistance)

Input(s)

Argument
Description

estimates

Required. Matrix of scenario estimates where each column corresponds to a scenario and each row corresponds to an economic variable.

anchor

Required. Column vector of anchor estimates across economic variables.

covariance

Required. Covariance matrix of economic variables. We recommend that the covariance specification be aligned with deviations from the anchor selection.

j

isReturnDistance

Optional. Logical (TRUE or FALSE). If TRUE, then the function will return Mahalanobis distance values across all scenarios, otherwise the function returns a vector of relative probabilities that sum to one. If not specified, the function defaults to FALSE.

Output(s)

The function returns a vector of scenario probabilities. When isReturnDistance is set to TRUE, the function returns the Mahalanobis distance of the scenario estimates relative to the specified anchor.

Example

Optional. Scalar value to model fatter tails. . If not specified, the function assumes that j is one and that multivariate normality across economic variables hold.

j≤1j \leq 1j≤1
Enhanced Scenario AnalysisThe Journal of Portfolio Management
Journal of Portfolio Management research paper: Enhanced Scenario Analysis
Logo
48KB
SCENARIOPR.xlsx
Example Workbook: SCENARIOPR