Lesson 36 of 38 17:35 Completed

How to calculate optimal portfolio using Excel- five stocks

Name: How to calculate optimal portfolio using Excel- five stocks
Uploaded: 2020-10-01
Duration: 17 min 35 s
Description: In this video, using five stocks, I will show how to find the optimal portfolio, which will maximize the return and minimize the risk. We will use Microsoft Excel, Excel Solver, and matrix multiplication to compute the variance and covariance matrix.

Watch on YouTube

About this lesson

In this video, using five stocks, I will show how to find the optimal portfolio, which will maximize the return and minimize the risk. We will use Microsoft Excel, Excel Solver, and matrix multiplication to compute the variance and covariance matrix.