Portfolio Standard Deviation and Portfolio VaR in Excel Spreadsheet

Поділитися
Вставка
  • Опубліковано 15 лис 2024

КОМЕНТАРІ • 19

  • @RightBackInRehab
    @RightBackInRehab 2 роки тому +5

    Always surprises me how well you explain what should be a complicated topic! Thanks Martyn.

  • @leonjbr
    @leonjbr 2 роки тому +2

    This video is very, very nice. It clearly illustrates the concept, the calculations and shows the real advantage of diversification and VaR. I think it is one of your best videos.

  • @alirezap88
    @alirezap88 2 роки тому +1

    A difficult subject explained clearly as always.
    Thanks Martyn

    • @Darwinexchange
      @Darwinexchange  2 роки тому

      Many thanks for your feedback Alireza, on this and all the other videos. Martyn

  • @leandrootturi7603
    @leandrootturi7603 2 роки тому +3

    All this series is just brilliant. Thank you a lot. One question: what do you think of calculating Standard Deviation and Correlation factor from 2 different strategies results (instead of calculating it from the assets daily variation) ?, let's say for the last 12 months . Thanks again mate. Cheers.

    • @TradeLikeAMachine
      @TradeLikeAMachine 2 роки тому

      Hi Leandro. This would be absolutely viable yes. And the bottom line here is that the better the values , the better the combined equity curve from the two strategies. Thank you for the great question

  • @ARIANBAHRAMI007
    @ARIANBAHRAMI007 2 роки тому +2

    Excellent content again. My question is if you are trading multiple assets on different time frames how one can manage such a portfolio management. Since the correlation calculation between assets should be done in the same time frame, as far as I know. Probably, diving the entire portfolio to different time frame portfolios, I guess. ?

    • @TradeLikeAMachine
      @TradeLikeAMachine 2 роки тому

      Hi Arian. You are right. The calculations only remain valid until either a) another position opens, or b) a position closes, regardless of which timeframe they belong to. So the bottom line is that re-calculations ar continually required in the scenario that you highlight. This is difficult but definitely achievable.

  • @ronanronan9500
    @ronanronan9500 2 роки тому +2

    Thank you! great job! If a short position is taken, should we opposite the value of monetary amt invested? for example, a sell position on AUDCAD -> w1= -10000 £?

    • @TradeLikeAMachine
      @TradeLikeAMachine 2 роки тому

      Hi Roman, I cover this in detail in Episode 18. Take a look once it is released. Thanks.

  • @JohnSilvavlogs
    @JohnSilvavlogs 2 роки тому +2

    thank you 🙏💫♥️

  • @geranio181
    @geranio181 2 роки тому +2

    cool clip! Thanks...

  • @subarkahsubarkah4775
    @subarkahsubarkah4775 2 роки тому +2

    Martyn, would you please discuss and give your opinion about the Pairs Trading Strategy based on the Cointegration model? This strategy opens two (or more) positions on currency pairs or other Asset classes at the same time using Cointegration concept, instead of correlation. I am wondering whether the calculation of the Portfolio VaR will be the same way with the way discussed in this video. Always, thanks a lot Martyn..

    • @TradeLikeAMachine
      @TradeLikeAMachine 2 роки тому +1

      Hi Subarkah. With pairs trading you will be short on one asset while long on a cointegrated asset. But of course if they are cointegrated they will also be highly correlated. So the concepts I am covering in this series are absolutely applicable. The bottom line here is that risk will be massively reduced when trading in the way you suggest.

    • @subarkahsubarkah4775
      @subarkahsubarkah4775 2 роки тому

      @@TradeLikeAMachine Thanks a lot, Martyn..