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]: [ Ссылка ] [Australia] [ Ссылка ]
Courses:
* International Finance: [ Ссылка ]
* Valuation: [ Ссылка ]
* Options, Futures, and Derivatives: [ Ссылка ]
****************************
*MY GEAR
****************************
Logitech c922: [ Ссылка ]
Softlight setup available here from Amazon: [ Ссылка ]
Wacom writing tablet: [ Ссылка ]
![](https://s2.save4k.ru/pic/m6AG5h1jM6w/mqdefault.jpg)