Plotting Efficient Frontier for Four Securities in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 ธ.ค. 2024

ความคิดเห็น •

  • @xcbx7664
    @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
    @coachBobbyJoe ปีที่แล้ว +1

    Why add the "@" symbol?

  • @SomeRandomGuy2353
    @SomeRandomGuy2353 ปีที่แล้ว

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

    • @RonaldMoy
      @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
    @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
    @쉿-h3c ปีที่แล้ว

    3:35

  • @Akash_here385
    @Akash_here385 ปีที่แล้ว

    Great