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
| Column | Type | Unit | Summary | Description |
|---|---|---|---|---|
dateDate | date | Trading date. | ||
income_fundIncome fund return | number | % | mean 0.01297, median 0.01, SD 0.2051, range −2.1–0.944 | Daily return of the low-risk income fund. |
balanced_fundBalanced fund return | number | % | mean 0.001363, median 0.0125, SD 0.5438, range −5.6–2.013 | Daily return of the balanced fund. |
growth_fundGrowth fund return | number | % | mean −0.01038, median 0.0255, SD 0.9858, range −9.2–4.287 | Daily 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
| Date | Income fund return (%) | Balanced fund return (%) | Growth fund return (%) |
|---|---|---|---|
| 2022-01-02 | 0.127 | -0.19 | 0.935 |
| 2022-01-03 | 0.145 | 0.287 | 2.042 |
| 2022-01-04 | -0.097 | -0.218 | -0.934 |
| 2022-01-05 | 0.004 | -0.305 | 0.727 |
| 2022-01-06 | 0.295 | 0.228 | -0.136 |
| 2022-01-09 | -0.199 | -0.216 | -0.017 |
| 2022-01-10 | 0.266 | 0.649 | 0.274 |
| 2022-01-11 | 0.1 | 1.333 | 2.094 |
| 2022-01-12 | 0.257 | -0.172 | -0.371 |
| 2022-01-13 | 0.137 | -0.063 | 0.058 |
| 2022-01-16 | 0.23 | -0.042 | 0.132 |
| 2022-01-17 | 0.193 | -0.603 | -1.124 |
Used in
- Weighted and geometric means · Describing Data
- Shape: skewness and kurtosis · Describing Data
- Robust summaries and relative spread · Describing Data
- ECDFs and Q-Q plots · Visualising and Exploring Data
- Autocorrelation · Time Series and Forecasting
- Stationarity and autoregressive models · Time Series and Forecasting
- Robust statistics · Resampling and Statistical Reasoning
- p-hacking and publication bias · Resampling and Statistical Reasoning
- Returns, risk and volatility · Applied Statistics for Professionals
- How bad can a bad day get? A tail-risk review · Capstone