Portfolio Optimization using five stocks in excel | FIN-ED

#fined
Portfolio Optimization using five stocks in excel | Calculating the Variance Covariance Matrix using stock Prices | FIN-ED

In this video, using five stocks, I will show how to find out the optimal portfolio, which will maximize the return and minimize the risk. We are going to use Microsoft Excel, excel solver, and matrix multiplication to compute variance and covariance matrix. If you are interested in only 2 stocks portfolio optimization, please check out my other video, the link of which is also given in the description below.

In this demonstration, we are going to use 5 years of monthly stock price data for 5 companies such as MCD, SBUX, PFE, AMGN, and AXP. If you understand the process, you can do the same exercise using whatever many companies you like and whatever date range you want to use in your computation.

Portfolio optimization using 2 stocks: https://youtu.be/0jsqj3hQmzo

Видео Portfolio Optimization using five stocks in excel | FIN-ED канала FIN-Ed