Efficient Portfolios (Part 1): Excel in Finance
Interactive

Efficient Portfolios (Part 1): Excel in Finance

Intuition Publishing
Updated Sep 25, 2020

We illustrate how to form efficient portfolios with two stocks using EXCEL. We then examine how portfolio risk and the creation of efficient portfolios are impacted by a two-stock correlation of 0. Finally, we examine how portfolio risk and the creation of efficient portfolios are impacted by a two-stock correlation of -1.