Three Assets: A Weight Grid, Nine Covariance Terms and Feasibility Flags
This lesson is part of the course
In this lesson
You calculate return, variance and σ for a given list of three-asset mixes, writing the nine covariance terms with one SUMPRODUCT per row of the covariance table, and flag the mixes that break the rules.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- From Monthly Returns to Annual Means and VolatilitiesFree
- Covariance and Correlation Tables, Written Out Cell by Cell Locked
- Two-Asset Mixes: Return, Risk and the Effect of Correlation Locked
- The Minimum-Variance Mix: Closed Form and Grid Check Locked
- Three Assets: A Weight Grid, Nine Covariance Terms and Feasibility Flags Locked
- The Efficient Frontier: Return Bands, Lowest Risk per Band and Dominated Mixes Locked
- Adding a Risk-Free Asset: Sharpe Ratios, the Tangency Mix and the Capital Allocation Line Locked
- Capstone: Weight Caps, Changed Estimates and How Fragile the Optimum Is Locked