Calculating the Efficient Frontier for more than 2 Assets in Excel

Поделиться
HTML-код
  • Опубликовано: 1 дек 2024

Комментарии • 6

  • @mujahidrasul3696
    @mujahidrasul3696 Год назад +1

    Hi. Thanks for very helpful videos. I am also wondering how you set the weights combinations in the blue table. It would have been helpful if you could spend a minute to explain that step as it is very confusing? Any help please

  • @jorgerdriguez3260
    @jorgerdriguez3260 11 месяцев назад +2

    Good day, i have 30 stocks, for this procedure we have a lot of time to enter the Portfolio Std Dev, there is another way or formula to enter in this row or calculate this parameter? Greetings and thak you, have a nice one!!!

  • @theevilhuman1
    @theevilhuman1 2 года назад +8

    How do you generate that blue table? Is there a formula for it

    • @TradeLikeAMachine
      @TradeLikeAMachine 2 года назад

      Hi Umi. The last two columns are calculated using formulae as shown in the video. The first 3 columns we done manually by myself using standard copy/paste/drag to complete... It's nothing more than every combination for 3 assets in increments of 5%. Hope that helps

    • @gianmarcomonacelli6986
      @gianmarcomonacelli6986 2 года назад +1

      @@TradeLikeAMachine hi, I'm also trying to replicate the blue table and I was wondering if there is a rationale to complete the columns of the weights. I attempted to do it manually but I think I'm replicating lines with same weight. For example if using increments of 2.5 instead than 5 how many totals rows should I have?

  • @massimosanticchia3404
    @massimosanticchia3404 5 месяцев назад

    Do you make the excel spreadsheets available?