Plotting Efficient Frontier for Four Securities in Excel

[@xcbx7664]

Thank you so much for taking your time to create this video. I tried making a E-Frontier but I had an issue with the random weight system because it wouldnt stay at a sum of 100. Luckily ur technic at 8:01 worked better than any other video on this subject. Thanks again. Love from Germany

[@coachBobbyJoe]

Why add the "@" symbol?

[@SomeRandomGuy2353]

Once the chart is mapped, how do you know which portfolio is on the optimal edge?

[@RonaldMoy]

If there is a risk-free rate, then the optimal portfolio will be where a line from the risk-free rate is tangent to the efficient frontier.

[@pallapasr3882]

This vdo is very helpful. Thanks a lot!. However, I tried data table function, but it doesn't work. It turns out to be copy of the same value SD and Expected return for bunches of stocks weights. I think I follow all steps in the vdo carefully...Don't know why....

[@쉿-h3c]

3:35

[@Akash_here385]

Great