Minimum Variance Portfolio in Excel: Multi-asset case

This video discusses the Global Minimum Variance Portfolio (GMVP) and how to construct it in excel. This example applies to a portfolio with any number of assets. I use an example of portfolio with five stocks in it. I go through how to use Excel matrix (i.e., array) functions to calculate the portfolio variance and then how to minimize that portfolio variance using Excel solver.

Time stamps
0:00 Introduction
1:23 Minimum Variance Portfolios
3:23 Constructing the global minimum variance portfolio in Excel

My valuation book: [US]: https://amzn.to/2LUwYQW [Australia] https://amzn.to/2WWX6Ra

Courses:
International Finance: https://financialanalysis.teachable.c...
Valuation: https://bit.ly/36nFfGp
Options, Futures, and Derivatives: https://financialanalysis.teachable.c...

****************************
*MY GEAR
****************************
Logitech c922: https://amzn.to/2xDUfTs
Softlight setup available here from Amazon: https://amzn.to/2xHVEbF
Wacom writing tablet: https://amzn.to/2YHmyeK