Charting stock portfolios with a scatter plot in Excel | Financial Modeling Tutorials

Описание

A financial modeling tutorial on charting stock portfolios in Excel after changing weights and monitoring average portfolio returns and portfolio variance using covariance and variance for two stocks.

Find the full transcript and Excel cell formulas here:
https://factorpad.com/fin/quant-101/charting-portfolios.html

Zoom straight to the section you are interested in here:
00:50 - Tutorial Outline
01:25 - Step 1 - Review the Inputs
06:19 - Step 2 - Create Eleven Two-Stock Portfolios
12:08 - Step 3 - Create a Risk and Return Plot
13:45 - Step 4 - Looking Forward
15:20 - Step 5 - Next: Portfolio Theory

For the outline to all tutorials see:
https://factorpad.com/fin/quant-101/quant-portfolio-management.html

For our other Finance and Technology tutorials see:
https://factorpad.com

Happy Learning!