3.2 Correlation, Beta and Risk-Adjusted Performance
Two return series at once: covariance and correlation, the regression line of a stock on the index (beta, alpha, $R^2$), market vs specific risk, and the Sharpe, Sortino, Treynor and information ratios — used correctly, with their noise, and with correlations that rise in a crisis.
📍 The situation
Meera, 31, a software tester in Hyderabad, has been investing for three years. Her brother tells her that "Beta Pharma Ltd" (a hypothetical share) "has a beta of only 0.6, so it is a low-risk stock". She owns five bank shares and thought she was diversified, yet on one bad day in our simulated market all five fell between 3% and 5% together. And she is choosing between two flexi-cap funds: a ranking website shows Fund P with a five-year return of 18% and a Sharpe ratio of 0.52, and Fund Q with 15% and 0.61. Which number should she believe, and what do they mean?
All three questions involve two return series at once — a stock and the index, two stocks, a fund and its benchmark. This section gives the tools for that. Covariance and correlation measure whether two returns move together. The regression line of a stock's returns on the index's returns has a slope called beta and an intercept called alpha, and it splits the stock's risk into a market part and a specific part ($R^2$ says how much is which). Finally, risk-adjusted ratios — Sharpe, Sortino, Treynor and the information ratio — put return and risk on one scale so funds can be compared fairly, and the same statistics tell us how much of a difference between two funds is simply noise. The mathematics is the least-squares line from school statistics, found by setting two partial derivatives to zero, and the Cauchy–Schwarz inequality.
All returns, betas and ratios on this page come from small hypothetical data sets or are simulated in your browser with a seeded random-number generator; the funds and companies are hypothetical. They are not the statistics of any real share, fund or index, and nothing here is a recommendation. The risk-free rate is an illustrative figure (6–6.5% a year) standing in for a short-term government-security yield; for real comparisons use the current T-bill or overnight rate, and the convention the fund factsheet states.
Covariance and Correlation
Look at a scatter plot with the index's monthly return on the horizontal axis and a bank share's on the vertical. If the points rise from left to right, the two tend to move together. Covariance turns this into a number by asking whether the deviations from the means have the same sign: when both are above average (or both below), the product of the deviations is positive.
For paired returns $(x_1,y_1),\dots,(x_n,y_n)$ with means $\bar x,\bar y$ and volatilities $s_x,s_y$ (Definition 3.1):
- the covariance is $s_{xy}=\dfrac1{n-1}\displaystyle\sum_{t=1}^n(x_t-\bar x)(y_t-\bar y)$;
- the correlation is $\rho_{xy}=\dfrac{s_{xy}}{s_x\,s_y}$.
Covariance has units ($\%^2$) and depends on the scale of the data; correlation is a pure number. Spreadsheets: COVARIANCE.S and CORREL. Always compute them from returns, never from price levels.
- $-1\le\rho_{xy}\le1$, and $\rho_{xy}=\pm1$ exactly when the points lie on a straight line $y=a+bx$ (with $b$ of the same sign as $\rho$).
- Correlation is unchanged by changing units or adding constants: replacing $x$ by $a+bx$ with $b\gt0$ (percent to decimal, adding a risk-free rate) leaves $\rho$ the same, while the covariance is multiplied by $b$.
- For a portfolio with weights $w_1,w_2$: $$\operatorname{Var}(w_1x+w_2y)=w_1^2s_x^2+w_2^2s_y^2+2w_1w_2\,\rho_{xy}\,s_xs_y .$$ The lower the correlation, the lower the portfolio's risk — the start of diversification (§4.1).
Why (part 1). Write $u_t=x_t-\bar x$, $v_t=y_t-\bar y$. For every real $\lambda$, $\sum(v_t-\lambda u_t)^2\ge0$, i.e. $\lambda^2\sum u_t^2-2\lambda\sum u_tv_t+\sum v_t^2\ge0$. A quadratic in $\lambda$ that is never negative has discriminant $\le0$: $\left(\sum u_tv_t\right)^2\le\sum u_t^2\sum v_t^2$ (the Cauchy–Schwarz inequality). Dividing by $(n-1)^2s_x^2s_y^2$ gives $\rho^2\le1$. Equality means some $\lambda$ makes every $v_t-\lambda u_t=0$: the points lie on a line. Part 2 follows because the deviations of $a+bx$ are $b$ times those of $x$, and part 3 by expanding $\sum\big(w_1u_t+w_2v_t\big)^2$. ∎
Beta, Alpha and the Market-Model Regression
Correlation says whether a share moves with the index; it does not say by how much. For that we fit a straight line through the scatter plot — the line that best predicts the share's return from the index's return.
The market model (single-index model) writes the return of asset $i$ in period $t$ as $$r_{i,t}-r_f=\alpha_i+\beta_i\,(r_{m,t}-r_f)+\varepsilon_{i,t},$$ where $r_m$ is the market index return, $r_f$ the risk-free rate for the period, and the residual $\varepsilon_{i,t}$ has mean 0 and is uncorrelated with $r_m$. Here
- beta $\beta_i$ is the sensitivity to the market: if the index's excess return is 1 percentage point higher, the asset's is expected to be $\beta_i$ points higher;
- alpha $\alpha_i$ is the average excess return not explained by market exposure (Jensen's alpha when the data are annualised);
- $\varepsilon_{i,t}$ is the specific (idiosyncratic, unsystematic) part of the return; its standard deviation $\sigma_{\varepsilon}$ is the specific risk.
For monthly data $r_f$ is small, and the model is often fitted to raw returns, $r_i=a+\beta r_m+\varepsilon$; the slope is then almost the same.
For data $(x_t,y_t)$ (index and asset returns, or excess returns), the line $y=\hat a+\hat\beta x$ that minimises the sum of squared residuals $\sum(y_t-a-\beta x_t)^2$ is $$\hat\beta=\frac{s_{xy}}{s_x^2}=\rho_{xy}\frac{s_y}{s_x},\qquad \hat a=\bar y-\hat\beta\,\bar x .$$ Its coefficient of determination is $R^2=\rho_{xy}^2$, and the asset's variance splits exactly into a market part and a specific part: $$s_y^2=\underbrace{\hat\beta^2s_x^2}_{\text{systematic}}+\underbrace{s_e^2}_{\text{specific}},\qquad R^2=\frac{\hat\beta^2s_x^2}{s_y^2},$$ where $s_e^2=\frac1{n-1}\sum e_t^2$ is the variance of the residuals $e_t=y_t-\hat a-\hat\beta x_t$.
Derivation (the calculus link). Let $S(a,\beta)=\sum(y_t-a-\beta x_t)^2$. At the minimum both partial derivatives vanish: $\partial S/\partial a=-2\sum(y_t-a-\beta x_t)=0$ gives $\bar y=a+\beta\bar x$, so the line passes through the point of means. Substituting $a=\bar y-\beta\bar x$, $S=\sum(v_t-\beta u_t)^2$ with $u,v$ the deviations, and $dS/d\beta=-2\sum u_t(v_t-\beta u_t)=0$ gives $\beta=\sum u_tv_t/\sum u_t^2=s_{xy}/s_x^2$. (S is a parabola opening upwards in $\beta$, so this is a minimum.) Then $\sum e_t^2=\sum(v_t-\hat\beta u_t)^2$ $=\sum v_t^2-\hat\beta\sum u_tv_t$ $=\sum v_t^2-\hat\beta^2\sum u_t^2$, which is the variance split after dividing by $n-1$; and $\hat\beta^2s_x^2/s_y^2=s_{xy}^2/(s_x^2s_y^2)=\rho^2$. ∎
Risk-Adjusted Performance: Sharpe, Sortino, Treynor and Information Ratios
Fund P returned 18% and Fund Q 15%. But P might simply have taken more risk — in a rising market, a riskier fund usually returns more, and in a falling one it loses more. A fair comparison asks how much extra return each fund delivered per unit of the risk it took. Different ratios use different notions of "risk", and each answers a different question.
Let $\bar R$ be a fund's average return over a period, $r_f$ the risk-free rate for the same period, and $\sigma$ the volatility of its returns.
- The Sharpe ratio is $\ S=\dfrac{\bar R-r_f}{\sigma}$: excess return per unit of total volatility.
- With a target return $\tau$ (often $r_f$ or $0$), the downside deviation is $\ \text{DD}_\tau=\sqrt{\frac1n\sum_t\min(R_t-\tau,0)^2}$, and the Sortino ratio is $\ \dfrac{\bar R-\tau}{\text{DD}_\tau}$: excess return per unit of downside volatility only.
Ratios are usually quoted annualised. Conventions (divisor, target, data frequency) differ between providers, so compare ratios only when they are computed the same way.
- Treynor ratio $\ T=\dfrac{\bar R-r_f}{\beta}$: excess return per unit of market risk (beta from Theorem 3.7).
- Jensen's alpha $\ \alpha=\bar R-\big[r_f+\beta(\bar R_m-r_f)\big]$: the return above what the fund's beta alone would have earned (the intercept of the market model, annualised).
- For a fund with benchmark $B$, the active return in period $t$ is $R_t-B_t$; the tracking error TE is the volatility of the active returns, and the information ratio is $\ \text{IR}=\dfrac{\overline{R-B}}{\text{TE}}$: average active return per unit of active risk.
- If period returns are independent and there are $m$ periods a year, $$S_{\text{ann}}\approx S_{\text{period}}\sqrt m ,$$ because the excess return scales with $m$ and the volatility with $\sqrt m$ (Theorem 3.1). The same applies to the Sortino and information ratios.
- Putting a fraction $w\gt0$ of money in the fund and $1-w$ in the risk-free asset (borrowing if $w\gt1$) gives a portfolio with excess return $w(\bar R-r_f)$ and volatility $w\sigma$ — the same Sharpe ratio. Sharpe measures the quality of the risk–return trade-off, not its size; the Treynor ratio is likewise unchanged, since beta becomes $w\beta$.
Why (part 2). The portfolio return is $wR+(1-w)r_f$, so its excess return is $w(R-r_f)$; the risk-free part has no variance, so the volatility is $|w|\sigma=w\sigma$. The ratio is $\frac{w(\bar R-r_f)}{w\sigma}=S$. ∎ This is why a high return alone proves nothing: any fund's return can be scaled up with leverage. It also gives the geometry of Interactive 2 — in the risk–return plane, a line from the risk-free point through a fund has slope equal to its Sharpe ratio (the capital allocation line of §4.2).
- "This fund will be most of my money." Total risk matters → Sharpe (or Sortino if you care mainly about losses and the return distribution is asymmetric).
- "This fund will be one small part of a well-diversified portfolio." Its specific risk will mostly cancel; only its market risk remains → Treynor and Jensen's alpha.
- "Is the manager adding value over the benchmark I could buy cheaply in an index fund?" → information ratio (and tracking error), against the right benchmark, after costs.
- Always: same period, same data frequency, same risk-free rate, same benchmark, and a long enough history — then ask whether the difference is bigger than the noise (Theorem 3.9).
Comparing Funds Correctly: Noise, Causation and Crises
Ratios computed from a few years of data are estimates, and they carry the same sampling error as the mean return (Theorem 3.2) — because the mean return sits in their numerator.
If a fund's returns are independent and roughly normal, an annualised Sharpe ratio $\hat S$ estimated from $T$ years of data has approximate standard error $$\operatorname{SE}(\hat S)\approx\sqrt{\frac{1+\hat S^2/2}{T}} .$$ For typical values ($\hat S$ between 0 and 1) this is close to $1/\sqrt T$: about $0.45$ for 5 years and $0.32$ for 10 years. Differences between two funds' Sharpe ratios much smaller than this cannot be distinguished from luck.
Where it comes from. The leading term is Theorem 3.2: the numerator is a mean return with standard error $\sigma/\sqrt T$ (annualised), and dividing by $\sigma$ gives $1/\sqrt T$. The extra $\hat S^2/2$ comes from the uncertainty in the estimated volatility in the denominator (a large-sample result for normal data, quoted without proof). Fat tails and serial correlation make the true error larger. ∎
Suppose two assets follow the market model with betas $\beta_i,\beta_j$ and specific risks $\sigma_{\varepsilon_i},\sigma_{\varepsilon_j}$, with residuals uncorrelated with each other and with the market. Then $\sigma_i^2=\beta_i^2\sigma_m^2+\sigma_{\varepsilon_i}^2$ and $$\rho_{ij}=\frac{\beta_i\beta_j\sigma_m^2}{\sigma_i\sigma_j},\qquad \rho_{im}=\frac{\beta_i\sigma_m}{\sqrt{\beta_i^2\sigma_m^2+\sigma_{\varepsilon_i}^2}} .$$ If the market's volatility $\sigma_m$ rises while specific risks stay the same, every correlation $\rho_{im}$ and (for betas of the same sign) every $\rho_{ij}$ increases towards 1.
Why. $\operatorname{Cov}(r_i,r_j)=\operatorname{Cov}(\beta_ir_m+\varepsilon_i,\beta_jr_m+\varepsilon_j)=\beta_i\beta_j\sigma_m^2$, since all the other covariances are zero; divide by $\sigma_i\sigma_j$. Writing $\rho_{im}=1/\sqrt{1+\sigma_{\varepsilon_i}^2/(\beta_i^2\sigma_m^2)}$ shows it increases with $\sigma_m$, and $\rho_{ij}=\rho_{im}\rho_{jm}$. ∎ This is one simple mechanism behind the observation that correlations rise in market crises: when one big common shock dominates the news, every share moves with it, and diversification across shares helps least exactly when it is wanted most. (Real crises add other effects — forced selling, liquidity — that a fixed-beta model ignores.)
Correlation is not causation. A high correlation between two series says they move together in the data, not that one drives the other. Two shares may both follow interest rates; a "leading indicator" may be correlated with the index in one sample by chance; and with hundreds of candidate indicators, some will show impressive correlations purely by luck (data snooping, §7.3). Worse, the correlation of two price levels that both trend upward is high even if their returns are unrelated — always correlate returns.
- "Low beta means low risk." Beta measures market risk only. A low-beta share can be very volatile because of company-specific risk (Example 4).
- "Five shares, so I am diversified." Five shares in one sector are highly correlated; they share most of their risk (Example 8).
- Correlating prices instead of returns. Any two upward-trending price series look highly correlated. Use returns.
- "Correlation proves the indicator drives the market." Correlation is not causation, and a correlation found by searching many indicators is often luck.
- "Correlations are fixed numbers." They change with market conditions and tend to rise in crises (Theorem 3.10), just when diversification is needed most. Stress-test with higher correlations.
- Comparing raw returns across funds with different risk. In a rising market a higher-beta fund usually returns more; that is not skill. Use risk-adjusted measures.
- Comparing ratios computed differently. Different periods, data frequencies, risk-free rates or benchmarks make Sharpe ratios incomparable.
- Treating a small Sharpe difference as meaningful. With 5 years of data the standard error of a Sharpe ratio is about 0.45 (Theorem 3.9); 0.52 vs 0.61 is noise.
- "Alpha is the fund's return minus the index's." That is the active return. Jensen's alpha adjusts for beta: a fund with beta 1.3 that beat a rising index by 2% may have negative alpha.
- Using Sharpe for an option-selling or other strongly skewed strategy. Volatility misses rare large losses (§3.1); look at Sortino, skewness and maximum drawdown too.
Meera downloads five years of monthly returns for both hypothetical flexi-cap funds and their common benchmark index, and computes (all annualised; illustrative risk-free rate 6.5%):
| return | volatility | beta | downside dev. | tracking error | |
|---|---|---|---|---|---|
| Fund P | 18% | 22% | 1.20 | 14% | 8.0% |
| Fund Q | 15% | 14% | 0.85 | 9% | 4.5% |
| benchmark | 14% | 16% | 1 | — | — |
- Sharpe. P: $11.5/22\approx0.52$; Q: $8.5/14\approx0.61$; benchmark $7.5/16\approx0.47$.
- Sortino (target $r_f$). P: $11.5/14\approx0.82$; Q: $8.5/9\approx0.94$.
- Treynor. P: $11.5/1.2\approx9.58\%$; Q: $8.5/0.85=10.0\%$; benchmark $7.5\%$.
- Jensen's alpha. P: $18-(6.5+1.2\times7.5)=2.5\%$; Q: $15-(6.5+0.85\times7.5)=2.125\%$.
- Information ratio. P: $(18-14)/8=0.50$; Q: $(15-14)/4.5\approx0.22$.
- Is any of it significant? Theorem 3.9: $\operatorname{SE}\approx\sqrt{(1+0.52^2/2)/5}\approx0.48$ for P and $\approx0.49$ for Q. The Sharpe gap of 0.09 is a fifth of one standard error. The funds also share most of their risk (same market), but even so five years cannot separate them.
What she learns. P's higher return came largely from higher beta in a rising market; per unit of total or market risk Q did slightly better, while P earned slightly more alpha and a higher IR. No measure separates them convincingly. The mathematics tells her what she cannot conclude: that either manager is better. So she turns to what she can know: expense ratios (a certain, compounding cost, §2.2), whether each fund's beta and drawdowns suit how much of her money it will hold, how consistently it has followed its stated style, and — if she cannot find a convincing reason to pay for active management — a low-cost index fund. Interactive 2 shows how often the truly better fund fails to top a five-year league table.
Exercises
All data are hypothetical or simulated; risk-free rates are illustrative. Volatility, covariance and tracking error use the divisor $n-1$, downside deviation the divisor $n$; give ratios to two decimals.
- 1 Monthly returns (%) of an index and a share are $x=1,-2,3,0,3$ and $y=2,-1,1,-1,4$. Compute their covariance and correlation.
- 2 Two assets have annual volatilities 15% and 20% and covariance $0.018$ (in decimal units). Find their correlation.
- 3 A 60:40 portfolio holds equity (volatility 18%) and debt (volatility 6%) with correlation 0.1. Find its volatility.
- 4 Two shares' prices both rise steadily over ten years, but their monthly returns are unrelated. What correlation would you expect from (a) the prices, (b) the returns? Which is meaningful?
- 5 Show that if $\rho=1$, a 50:50 portfolio's volatility is exactly the average of the two volatilities.
- 6 Returns are converted from percent to decimals and a constant 0.5% is subtracted from each. What happens to the covariance and to the correlation?
- 1 The covariance of a share with the index is 0.0270 and the index's variance is 0.0225 (annual, decimals). Find the share's beta.
- 2 A share has correlation 0.7 with the index, volatility 28%, and the index volatility is 16%. Find its beta, $R^2$ and specific volatility.
- 3 A regression on monthly returns gives $\hat a=0.1\%$ and $\hat\beta=0.85$. What return does the line predict in a month when the index falls 4%?
- 4 Roughly what annual alpha does a monthly alpha of 0.1% correspond to?
- 5 For the data of I.1, find the regression line of $y$ on $x$.
- 6 A share has beta 0. Is it risk-free? Explain.
- 7 A portfolio holds 50%, 30% and 20% in shares with betas 1.3, 0.9 and 0.6. Find the portfolio beta (beta is linear in the weights).
- 1 A fund returned 14% with volatility 16%. Find its Sharpe ratio.
- 2 A strategy's monthly Sharpe ratio is 0.2. Annualise it.
- 3 Monthly returns (%) are $3,-2,4,-1,0,2$. With target $\tau=0$, find the downside deviation and the monthly Sortino ratio.
- 4 A fund returned 13% with beta 0.8. Find its Treynor ratio.
- 5 A fund returned 16% with beta 1.2 while the market returned 13%. Find Jensen's alpha.
- 6 A fund's average active return is 1.5% a year and its tracking error 4%. Find its information ratio.
- 7 A fund has Sharpe ratio 0.5 and volatility 12%. An investor puts half her money in it and half in a deposit earning the risk-free rate. Find her portfolio's expected excess return, volatility and Sharpe ratio.
- 1 A fund's 3-year Sharpe ratio is 0.8. Find the approximate standard error and a 95% interval. Can we be confident its true Sharpe ratio is positive?
- 2 How many years of data are needed for the standard error of a Sharpe ratio near 0.5 to be 0.25?
- 3 A share has beta 1 and specific volatility 25%. Find its correlation with the index when the index volatility is 12% and when it is 36%.
- 4 A newspaper notes that a share index rose in years when a cricket team won a series. Explain why this is no basis for investing.
- 5 A large-cap fund has $R^2=0.98$ against its benchmark, a tracking error of 1.5%, and charges a much higher expense ratio than an index fund. What does this suggest, and which ratio would you check?
E1. NISM-style The Sharpe ratio of a mutual fund scheme measures excess return over the risk-free rate per unit of (A) beta (B) standard deviation (C) downside deviation (D) tracking error.
E2. NISM-style A stock has a beta of 1.2 with respect to the market index. If the index rises by 5%, the expected change in the stock, ignoring alpha, is (A) +5% (B) +6% (C) +4.17% (D) +1.2%.
E3. NISM-style Which measure is most suitable for judging how consistently an active fund manager has outperformed the scheme's benchmark? (A) Standard deviation (B) Beta (C) Information ratio (D) $R^2$.
E4. Case study Six monthly returns (%) of a benchmark index and of Fund F are: benchmark $2,-3,4,1,-2,4$; Fund F $3,-4,4,2,-3,4$. (a) Find Fund F's beta, monthly alpha (raw-return regression) and $R^2$. (b) What does the line predict for a month in which the benchmark falls 5%? (c) Find the monthly active returns, the annualised tracking error and the information ratio. (d) Summarise the fund in one sentence.
E5. Case study Three hypothetical portfolios over the same period (annualised; illustrative risk-free rate 6%; market return 14%, market volatility 16%): K returned 16% with volatility 24% and beta 1.3; L returned 12% with volatility 12% and beta 0.6; M (an index fund) returned 14% with volatility 16% and beta 1.0. (a) Compute each one's Sharpe ratio, Treynor ratio and Jensen's alpha. (b) Which would you prefer as your only investment, and which as a small addition to an already diversified portfolio? (c) What is wrong with choosing K because it "returned the most"?
E6. Interview Shares A and B each have correlation 0.5 with the market index. What is the lowest possible correlation between A and B? (Hint: a correlation matrix must be positive semidefinite.)
Suggested plan — 2 lectures × 60 min.
- Moving together. Open with the 📍 situation: ask whether "beta 0.6 = low risk" is true and why five bank shares fell together. Covariance and correlation (Definition 3.6) with Example 1 on the board; Cauchy–Schwarz for $|\rho|\le1$ and the two-asset variance (Theorem 3.6), Example 2. The regression line by calculus (Definition 3.7, Theorem 3.7), Examples 3–4. Project Interactive 1: press Play at 24 months and let the class watch beta estimates jump; then 120 months; then switch to crisis and ask why the correlation rose although the share did not change (Theorem 3.10, Example 8).
- Risk-adjusted performance. Sharpe and Sortino (Definition 3.8), Treynor, alpha and IR (Definition 3.9), leverage invariance (Theorem 3.8); Examples 5–7 and the 🧭 box on which ratio answers which question. Then the noise in rankings (Theorem 3.9): project Interactive 2 with 5 years and Play for a minute — how often does the truly best fund top the table? — then 30 years. Close with the 📈 Market case and Practice corner E5.
Class activity. "Fund league": each student picks fund A, B or C in Interactive 2 before a new 5-year history is drawn; whoever's fund ranks first by Sharpe scores a point. After ten rounds compare the scores with the true ranking — and discuss what this means for fund advertisements that quote last year's rank.
Misconceptions to watch for. Low beta = low risk; correlating prices; active return confused with alpha; ignoring the noise in Sharpe ratios; believing correlations are stable; reading causation into correlation.
Suggested homework. I(1, 3, 4, 6), II(2, 5, 6, 7), III(3, 5, 7), IV(1, 3, 5); Practice corner E2, E4, E6.
Project. Estimate the beta, alpha and $R^2$ of two mutual-fund schemes against their benchmark from published NAV and index data, compute their Sharpe, Sortino, Treynor and information ratios, and check whether the difference between them exceeds the noise.
Why it matters. Factsheets and rating sites report these ratios with different conventions and periods. Computing them yourself shows exactly what each one measures and how fragile a ranking can be.
What to do.
- Download five years of month-end NAVs for two schemes in the same category (AMC or AMFI website) and the month-end values of their benchmark's total-return index (index provider's website). Put dates in A, fund 1 in B, fund 2 in C, the benchmark in D.
- Monthly returns in F, G, H:
=B3/B2-1and so on. Risk-free rate per month in a cellrf, e.g.=(1+annual_rate)^(1/12)-1with an annual T-bill yield you look up. - For each fund:
=SLOPE(G:G,H:H)(beta),=INTERCEPT(G:G,H:H)(monthly alpha, raw returns),=RSQ(G:G,H:H),=CORREL(G:G,H:H). Draw the scatter plot with a linear trendline and "display equation". - Sharpe (annualised):
=(AVERAGE(F:F)-rf)/STDEV.S(F:F)*SQRT(12). Downside deviation:=SQRT(SUMPRODUCT((F3:F62<rf)*(F3:F62-rf)^2)/COUNT(F3:F62)); Sortino likewise. Treynor:=12*(AVERAGE(F:F)-rf)/beta. - Active returns
=F3-H3in a new column; tracking error=STDEV.S(...)*SQRT(12); information ratio=12*AVERAGE(...)/TE. - Standard error of each Sharpe ratio:
=SQRT((1+S^2/2)/5). Is the difference between the two funds larger than one standard error?
Python version: import numpy as np; b, a = np.polyfit(rm, rf1, 1); r2 = np.corrcoef(rm, rf1)[0,1]**2; sharpe = (rf1.mean()-rfm)/rf1.std(ddof=1)*12**0.5.
Hand in: the two scatter plots with fitted lines, a table of all ratios side by side with the factsheet's figures, and a paragraph: which fund would you call "better", on what evidence, and how confident can you be?
Going further. Compute a rolling 36-month beta and correlation (SLOPE/CORREL over a moving window) and chart them: do they change over time, and do correlations jump in months when the benchmark fell sharply?
🧪 Self-check quiz
Q1. A share has correlation 0.6 with the index, volatility 30%, and the index volatility is 15%. Its beta is
Q2. You put 40% of your money in a fund with Sharpe ratio 0.6 and 60% in a deposit earning the risk-free rate. Your portfolio's Sharpe ratio is
Q3. In the market model, if the index becomes much more volatile while each share's specific risk stays the same, correlations between shares
Q4. The Sortino ratio differs from the Sharpe ratio because its denominator
Q5. A share's regression on the index has $R^2=0.25$. This means