EconStatsCraft rigorous, plain-spoken econometrics
Econometrics that explains itself.
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
EconStatsCraft › Value at Risk & Expected Shortfall
The loss you should not exceed at a chosen confidence, three ways - historical, Normal, and skew/kurtosis-adjusted - plus the Expected Shortfall beyond it and a Kupiec test of whether the historical figure held up.
Value at Risk answers one narrow question: on a bad day, how bad? The 99% one-day VaR is the loss that only the worst 1% of days exceed. It is a quantile of the return distribution and nothing more. Expected shortfall answers the question VaR dodges - GIVEN that you are in that worst 1%, how much do you actually lose on average - and that difference is the whole reason regulators moved to it.
Risk reporting and limits, regulatory capital, comparing the tail risk of strategies, or demonstrating why a Normal assumption understates risk for real financial returns.
For loss L=-R, VaR at level \alpha is the quantile \mathrm{VaR}_\alpha=\inf\{l: P(L\le l)\ge\alpha\}. Expected shortfall is the mean beyond it, \mathrm{ES}_\alpha=E[L\mid L\ge \mathrm{VaR}_\alpha]. Three estimators are in common use. HISTORICAL simply takes the empirical quantile of past returns and assumes no distribution. PARAMETRIC-NORMAL sets \mathrm{VaR}_\alpha=-(\mu+z_\alpha\sigma) with z_{0.99}=-2.326, which is fast and wrong in the tails. The STUDENT-t version replaces z with a t quantile scaled by \sqrt{(\nu-2)/\nu} so the variance still matches \sigma^2; with \nu around 4 to 6, which is typical for daily equity returns, this widens the 99% figure by roughly 15 to 25% against the Normal.
\text{VaR}_{\alpha} = -\,Q_{1-\alpha}(r),\qquad \text{ES}_{\alpha} = -\,\mathbb{E}[\,r \mid r \le Q_{1-\alpha}(r)\,]
99% VaR on 180 monthly returns of a 1,000,000 portfolio: 13.151% historical (131,515), 14.317% Gaussian (143,167) and 14.438% Cornish-Fisher. Expected shortfall is 15.056% historical and 16.510% Gaussian - between 14% and 15% above the corresponding VaR, which is the point of reporting it: on the months the limit is breached, the average loss is well beyond the limit, and VaR alone never says by how much. Now notice what this sample does NOT show. The textbook warning is that the Normal understates the tail, and here it does the opposite - the Gaussian figure is ABOVE the historical one. The reason is in the summary line: excess kurtosis is only 0.239 and skewness 0.049, so these returns are close to Normal and the historical estimate, resting on the handful of worst months actually observed, happens to be the milder of the two. The lesson is the general one rather than the slogan: which method is conservative depends on the data in front of you, so quote all three and look at the kurtosis before deciding which to believe.
| If you see this | It means | Do this |
|---|---|---|
| Normal and historical VaR differ sharply | Fat tails | Trust the historical or t figure; report the gap |
| Zero breaches in a long backtest | Over-conservative, not safe | Kupiec test. Capital is being wasted |
| Breaches arrive in clusters | Volatility clustering unmodelled | Use a GARCH-based conditional VaR |
| ES barely exceeds VaR | Thin tail, or too few tail observations | Check the sample size beyond the quantile |
| VaR jumps when one old date drops out | Historical estimator dominated by one event | The window is too short for this confidence level |
| Portfolio VaR above the sum of the parts | Non-sub-additivity, a known defect | Report expected shortfall as well |
GARCH, for conditional volatility that makes VaR responsive. Performance ratios, for the return side of the same trade-off.
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · CAPM / beta estimation · Multi-factor model · Portfolio optimization · Performance & drawdown · Time value of money & NPV/IRR · Equity valuation (DDM, FCF, residual income) · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Forwards, futures & swaps · Credit risk & Basel capital · Extreme value theory (tail risk)
Line chart · Area chart · Bar chart · Stacked bar · Scatter plot · Bubble chart · Histogram · Box plot · Pie chart · Heat map · Rebased to 100 · Lorenz curve and Gini
World map · Bivariate map · Flow map · India - state map · India - district map
Descriptive statistics · Summary by group · Two-way table · Classical statistical tests
Multiple regression (OLS) · Logit / Probit · Tobit (censored) · Truncated regression · Multinomial logit · Ordered logit / probit · Quantile regression · Poisson / Negative binomial
Time-varying coefficients (Kalman) · Unit root tests · Correlogram (ACF / PACF) · ARIMA / SARIMA · Rolling-origin cross-validation · Theta method · Unobserved components · STL forecasting · Forecast combination · Markov regime switching · Change frequency (resample) · ARCH / GARCH volatility · Decompose & filter · Spectral analysis · Exponential smoothing · Forecast accuracy
Yield curve (Nelson–Siegel / Svensson) · Dynamic factor model · Dynamic regression (ARIMAX) · Structural VAR · VAR · Granger causality · Cointegration · VECM · ARDL & bounds test
Panel regression · Panel cointegration tests · Heterogeneous panel: Mean Group & PMG · Gravity model of trade · Dynamic panel GMM · Panel diagnostics · Panel unit-root tests
Principal components (PCA) · Factor analysis · Cluster analysis
Conjoint analysis · MaxDiff (best–worst scaling) · TURF - reach of a product line · Price sensitivity (Van Westendorp) · Market basket analysis · Perceptual map · Scale reliability (Cronbach’s alpha) · Key driver analysis
Spatial autocorrelation · Spatial regression · Heckman selection · Instrumental variables (2SLS) · Difference-in-differences · Staggered difference-in-differences · Regression discontinuity · Matching & weighting · Oaxaca–Blinder decomposition
Black–Scholes option pricing · Bond price, duration & convexity · Merton distance to default · EMI / home loan planner · CAPM / beta estimation · Multi-factor model · Portfolio optimization · Value at Risk & Expected Shortfall · Performance & drawdown · Time value of money & NPV/IRR · Equity valuation (DDM, FCF, residual income) · Cost of capital (WACC) · Binomial option pricing · Option strategies (payoff & profit) · Forwards, futures & swaps · Credit risk & Basel capital · Extreme value theory (tail risk)
Life table · Life annuity · Life insurance pricing · Chain ladder reserving · Buhlmann credibility · Survival analysis · Mortality graduation · Aggregate loss model · Ruin probability · Multi-state Markov model · Loss severity fitting
Monte Carlo experiment · F-test, Wald & Chow · Structural breaks & stability
Regression vs machine learning · Ridge / Lasso / Elastic Net · Random forest · Gradient boosting
EconStatsCraft rigorous, plain-spoken econometrics
Regression, panel data, time series and the whole battery of tests. Every result is followed by a verdict you can defend.
Load a dataset to see it here.
Pick the example closest to your question. You get a spreadsheet with the right columns and a few rows showing the expected format - replace the numbers with your own, then paste or upload it back.
Copy the header row from the table above (or from the downloaded template), put your own rows underneath, and paste the whole thing here. It is checked against the layout before anything is imported.
Or click a row in the preview below.
For a units or notes row.
Search every source at once. World Bank indicators need countries and years; everything else loads in one click.
Loading the catalogue…
The engine stays loaded, so this is quick - and it leaves your open tab and panel layout alone.
⌘/Ctrl+Enter runs the current analysis. ⌘/Ctrl+P exports the session as a PDF. Esc closes this.
In the Notebook: Enter starts a new block and
Shift+Enter a new line inside one; Backspace at the start
joins back into the paragraph above; / on an empty line inserts anything.
⌘/Ctrl+B, I, E, H and
M apply bold, italic, code, highlight and maths.
#, ##, -, 1., > and
``` at the start of a line convert it.
Sign in to run unlimited analyses.
Scroll to pan · Esc to close