Problem solved in full
-
The best-Sharpe mix of US stocks and 10-year Treasuries 7 steps
Two assets, one window: US stocks and 10-year Treasuries fitted on 1928–1976. Derive the best-Sharpe mix by hand, check it against the panel — then work out how many of its printed digits the data can actually support.
-
Click Stocks and bonds only to fit the frontier on this window. Six numbers go in and nothing else: each sleeve’s mean annual return, each sleeve’s volatility, their correlation, and the bill rate that defines risk-free.
-
Sharpe ratios are measured above cash, so subtract the bill from both means. Stocks earned about eleven times the bond sleeve’s excess. The covariance is slightly negative — a small number that does real work two steps below.
-
A mix holding w in stocks earns the weighted average of the two excesses. Its volatility is not a weighted average: the cross term is the whole of diversification, and with a negative covariance it subtracts.
-
Before trusting the formula, test it where the answer is already on the page. Put w = ½ and the tool’s own Equal weights (1/N) row reads 4.52% above cash at 11.30% volatility. Both match, so the six inputs are the right six.
-
Now maximise. Because the Sharpe ratio is a ratio, its maximum need not sit at either end — and with a negative covariance it does not. Setting the derivative to zero clears the square root and leaves a formula in the same six inputs.
-
Substitute. Open The weights each method chose and the tangency row reads 27.2% stocks, 72.8% bonds; the table above it reads 6.72% predicted volatility and a predicted Sharpe of 0.418. A portfolio a quarter in stocks is 4.6 points quieter than the 50/50 mix.
-
Now price the inputs, which the tool never does. μs is not a fact about the world; it is the average of 49 annual returns whose spread is 22.351%, so it carries a standard error of its own. Put μs one standard error either side and re-solve the same formula.
Answer
27.2% stocks, 72.8% bonds — printed to a tenth of a point on a quantity the data pins down to about ±7 points. One standard error on the equity mean alone swings the optimal weight from 19.3% to 33.4%, and that is with the two volatilities, the correlation and the bill rate all still treated as known exactly. The objective is no help in narrowing it: evaluate S(w) at 24.1% and at 30.9% and both round to 0.417, so the panel’s own three decimals cannot separate weights seven points apart. That is the frontier’s quiet joke — its most confident-looking output is its least determined one. Which is why equal weights, estimating nothing at all, delivered 0.551 here against the optimiser’s 0.440.
-
Learning path
Risk, measured
References (6)
- The frontier itself, in the paper that defined it: H. Markowitz, "Portfolio Selection." The Journal of Finance 7(1), 77β91, 1952.
- The result this page reproduces β across fourteen datasets, no optimised rule reliably beat equal weights out of sample: V. DeMiguel, L. Garlappi and R. Uppal, "Optimal Versus Naive Diversification: How Inefficient is the 1/N Portfolio Strategy?" Review of Financial Studies 22(5), 1915β1953, 2009.
- Why the optimiser behaves this way β it maximises over estimation error as readily as over return: R. O. Michaud, "The Markowitz Optimization Enigma: Is 'Optimized' Optimal?" Financial Analysts Journal 45(1), 31β42, 1989.
- And how far the weights move for a small change in the estimated means, which is the mechanism behind everything above: M. J. Best and R. R. Grauer, "On the Sensitivity of Mean-Variance-Efficient Portfolios to Changes in Asset Means: Some Analytical and Computational Results." Review of Financial Studies 4(2), 315β342, 1991.
- One of the standard repairs β shrink the covariance estimate rather than trust the sample one. This tool does not apply it, so the frontier shown is the raw sample frontier: O. Ledoit and M. Wolf, "Honey, I Shrunk the Sample Covariance Matrix." The Journal of Portfolio Management 30(4), 110β119, 2004.
- The older warning that a mean-variance optimum is only as meaningful as the set of assets you fed it: R. Roll, "A critique of the asset pricing theory's tests Part I: On past and potential testability of the theory." Journal of Financial Economics 4(2), 129β176, 1977.