Bulk Stock Price download, Variance-Covariance Matrix, and Portfolio Optimization with Excel
Employ the power of Excel to bulk download stock data from the internet, form a portfolio, construct a variance-covariance and correlation matrix, and use Solver to optimize your portfolio using different strategies. Here's the link to the file from this video: https://bit.ly/3ad52l7