Statistics Quest

Daily returns of three funds

750 trading days (about three years) of daily percentage returns for three fictional investment funds managed by an invented firm, Meridian Dunes Capital: a low-risk income fund, a balanced fund and an equity growth fund. Returns have fat tails, volatility clustering and one market crash day. Built for describing return distributions, volatility, Value-at-Risk style quantiles, normality checks and correlation. Not investment data and not advice.

Rows
750
Columns
4
One row is
one trading day
Version
v1

Data dictionary

ColumnTypeUnitSummaryDescription
date
Date
dateTrading date.
income_fund
Income fund return
number%mean 0.01297, median 0.01, SD 0.2051, range −2.1–0.944Daily return of the low-risk income fund.
balanced_fund
Balanced fund return
number%mean 0.001363, median 0.0125, SD 0.5438, range −5.6–2.013Daily return of the balanced fund.
growth_fund
Growth fund return
number%mean −0.01038, median 0.0255, SD 0.9858, range −9.2–4.287Daily return of the equity growth fund.

What it is good for

  • Compare the volatility (standard deviation) of three return series.
  • Show that returns have fatter tails than a normal distribution (kurtosis, Q–Q plot).
  • Estimate a 95% or 99% one-day Value-at-Risk with empirical quantiles vs a normal approximation.
  • Measure correlation between funds and see how it changes in turbulent periods.

Methods: standard deviation, kurtosis, Q–Q plot, empirical quantiles, normality tests, correlation matrix, rolling volatility.

Data quality notes

  • Returns are in percent (1.0 = 1%), rounded to 3 decimals.
  • Excess kurtosis is clearly positive for all funds; normal-based VaR underestimates tail risk.
  • Row 513 (date in the third year) is a crash day: the growth fund's worst day.
  • Volatility clusters, so consecutive days are not independent in their variability.
  • No missing values.

Provenance and licence

A common market shock and fund-specific shocks are drawn from Student t distributions with 4–5 degrees of freedom scaled to unit variance (fat tails). Volatility follows a GARCH(1,1)-like recursion (α = 0.08, β = 0.90), so calm and turbulent periods cluster. Fund return = mean + daily volatility × (loading × market shock + idiosyncratic shock), with volatility scales 0.25% (income), 0.7% (balanced) and 1.4% (growth); the realised daily standard deviations in this sample are about 0.21%, 0.54% and 0.99% because volatility spends most days below its long-run average. On trading day 513 a crash of −2.1%, −5.6% and −9.2% is imposed. Trading days are Sunday–Thursday.

Synthetic data · CC0-1.0 (synthetic data generated by Statistics Quest) · generated deterministically (seed 20241009). It does not describe real people or organisations; any resemblance is coincidental.

Preview

Dataset

Daily returns of three funds

750 rows · one row = one trading day · synthetic data

DateIncome fund return (%)Balanced fund return (%)Growth fund return (%)
2022-01-020.127-0.190.935
2022-01-030.1450.2872.042
2022-01-04-0.097-0.218-0.934
2022-01-050.004-0.3050.727
2022-01-060.2950.228-0.136
2022-01-09-0.199-0.216-0.017
2022-01-100.2660.6490.274
2022-01-110.11.3332.094
2022-01-120.257-0.172-0.371
2022-01-130.137-0.0630.058
2022-01-160.23-0.0420.132
2022-01-170.193-0.603-1.124

Used in