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 › Performance & drawdown
Turns a return series into the numbers an investment committee asks for - CAGR, annualised volatility, Sharpe, Sortino, the maximum drawdown and how long it lasted - with an optional benchmark for tracking error and capture ratios.
A return of 12% means nothing on its own. Twelve percent earned smoothly is a different product from twelve percent earned through a 40% drawdown. Every performance ratio is the same shape - reward divided by some definition of risk - and they differ only in what they are willing to call risk. Sharpe counts all variation; Sortino counts only downside; the information ratio counts only deviation from the benchmark.
Evaluating a strategy or fund, comparing managers on a like-for-like basis, or stress-testing whether a track record is actually holdable - the maximum drawdown is the number that answers that.
Sharpe is S=(\bar{R}-R_f)/\sigma using total standard deviation. Sortino replaces the denominator with downside deviation, \sqrt{\frac{1}{T}\sum_t \min(R_t-\tau,0)^2} against a target \tau, on the argument that upside variation is not a risk anyone wishes to be compensated for. The information ratio is (\bar{R}-\bar{R}_b)/\sigma(R-R_b), where the denominator is tracking error - the standard deviation of the ACTIVE return, not of the fund. Annualising multiplies the numerator by k and the denominator by \sqrt{k}, so the ratio itself scales by \sqrt{k}: a monthly Sharpe of 0.25 is 0.25\sqrt{12}=0.87 a year.
\text{Sharpe} = \frac{\bar{r}-r_f}{\sigma}\sqrt{P},\qquad \text{Sortino} = \frac{\bar{r}-r_f}{\sigma_{\text{down}}}\sqrt{P},\qquad \text{MDD} = \min_t\left(\frac{W_t}{\max_{s\le t}W_s}-1\right)
A 180-month record: total return 295.94%, a CAGR of 9.61% on annualised volatility of 19.30%, Sharpe 0.571 and Sortino 0.635. Sortino only 11% above Sharpe says the downside deviation is close to the total volatility - this record is roughly symmetric, not the positively skewed kind where Sortino runs far ahead. Against the benchmark, tracking error is 10.57% for an information ratio of 0.330, with up-capture 1.007 and down-capture 0.817: it keeps pace in rising months and loses less in falling ones, which is where the active return comes from. The number that deserves the most attention is the maximum drawdown of -34.17%, running 13 periods from peak to trough and taking a further 35 to recover. A Calmar ratio of 0.281 puts that in perspective - nearly four years of average growth to work off the worst decline. Ratios computed on 180 observations still carry a standard error on the Sharpe of roughly 0.077, so 0.571 is about 0.571 ± 0.15 at two standard errors: comfortably positive, and nowhere near precisely measured.
| If you see this | It means | Do this |
|---|---|---|
| Sharpe above 2 for a long-only fund | Too short a sample, or an illiquid mark-to-model | Check the return autocorrelation |
| Sortino far above Sharpe | Positive skew, or a target set too low | State the target explicitly |
| Sortino below Sharpe | Negative skew: losses are larger than gains | The Sharpe ratio is flattering this fund |
| Information ratio high, Sharpe low | Beats the benchmark but the benchmark did badly | Both statements are true; report both |
| Returns strongly autocorrelated | Stale pricing or smoothing | Annualised figures are inflated. Apply the Lo correction |
| Ratio changes sign on a small window shift | The mean is not distinguishable from zero | The sample is too short for any of this |
CAPM, which splits the same return into market exposure and alpha. Value at Risk, for the tail rather than the average.
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 · 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