Multivariate Monte Carlo simulation: correlated variables (Excel)

How one can perform a Monte Carlo simulation for several correlated variables at once? This is often required for many quantitative finance applications such as basket option valuation, credit default swaps pricing, or value-at-risk estimation. Today we are investigating this technique using a Cholesky decomposition in Excel.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Risk management!
Please consider supporting NEDL on Patreon: / nedleducation

Пікірлер: 36

  • @NEDLeducation
    @NEDLeducation Жыл бұрын

    You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7 Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation

  • @cheesemaster113
    @cheesemaster113 Жыл бұрын

    I was trying to figure this out on my own, was wasting too much time. Glad you have this posted.

  • @luismartins2791
    @luismartins2791 Жыл бұрын

    This was super usefull for my job. Big thanks mate! Great explanation!

  • @art0van0derlay
    @art0van0derlay11 ай бұрын

    Great video, thank you. Straight to the point and very clear

  • @KingstonMiz
    @KingstonMiz Жыл бұрын

    Bro your video literally saved my day. Thank you so much!

  • @maximemartin6076
    @maximemartin6076Ай бұрын

    Very Intuitive video. Multivariate data is always fun to work on !

  • @luismartins2791
    @luismartins2791 Жыл бұрын

    great explanation. Thanks mate

  • @mrroboto50
    @mrroboto50 Жыл бұрын

    Fantastic video! I have been looking for a good way to deal with correlated variables for a long time. I had heard of Cholesky decomposition but didn't know it could be used for this.

  • @NEDLeducation

    @NEDLeducation

    Жыл бұрын

    Hi, and thanks so much for the kind words! I have got a separate video on Cholesky here that covers the concept in a lot more detail: kzread.info/dash/bejne/dGSrzJuxidTdZbw.html

  • @Trivitu
    @Trivitu8 ай бұрын

    Excelent video as always! Out of curiosity, is it ok to use the empirical distribution of each stock when generating the uncorrelated Z-Stats?

  • @kelvinc592
    @kelvinc5929 ай бұрын

    Super video! Thanks

  • @nitinkapoor4752
    @nitinkapoor4752 Жыл бұрын

    Thanks… just submitted one of my assignments :) … with JetFuel Prices correlated with Exchange rate against US$… both moving and yet have some correlation..

  • @WowChrismonkey99
    @WowChrismonkey99Ай бұрын

    Awesome video. How would you model correlated electricity and fuel prices in this way? Which distribution would you assume? Also how do you accurately estimate the correlation of time series data? Thanks! I’ve already learnt a ton, you’re a star

  • @mixaj4516
    @mixaj45169 ай бұрын

    Thank you for your great content. Could you make a video of how we can minimize the CVaR of a portfolio?🙏

  • @davidghope1
    @davidghope16 ай бұрын

    Further to my last comment - is that what forces the correlations to be maintained and therefore the portfolio means and standard deviations to be similar

  • @anon1603
    @anon1603 Жыл бұрын

    Hello sir nice video but am wondering whether Cholensky Decomposition can be used if Distribution assumed is log-normal instead of normal? If not could you make a video where you show alternative method on how to do this if we assume Returns Distribution is log-normal?

  • @LabrosTsiros
    @LabrosTsiros Жыл бұрын

    Loved the video! Was wondering about the literature behind the method applied here for generating the correlated simulated returns. I would like to reference it in my paper! Thanks!!

  • @NEDLeducation

    @NEDLeducation

    Жыл бұрын

    Hi Labros, and glad you liked the video! This is one of the statistical methods that everybody knows but few know the original source it came from :) I believe you can use it without referencing (found many papers that do so), but my best bet at who proposed it originally is Solow (1985): link.springer.com/article/10.1007/BF01031616

  • @thulaniningi7768
    @thulaniningi7768 Жыл бұрын

    Hey Sabha, i wanted to ask if can you use monte carlo to simulate the correlation coefficient. Correlation matrix table?

  • @thedutran7062
    @thedutran7062 Жыл бұрын

    can you explain more about what can we conclude from the simulation in the video. This video is fantastic

  • @davidghope1
    @davidghope16 ай бұрын

    Are the first columns of the Correlation Matrix and Choelsky decomposition expected to be the same as in this example ?

  • @stevealmond7460
    @stevealmond74605 ай бұрын

    very helpful. can you explain how to do this with a portfolio of commodity futures including longs and shorts? for example, i may be spreading gold, so im long june and short dec. Thanks

  • @wiltonhotz
    @wiltonhotz Жыл бұрын

    Great video, as always. Out of curiosity (I can't find it amongst your videos) do you have a video on the calculations of the five factor model, and your thoughts about it? Otherwise that is a topic I would love to suggest! Best W

  • @NEDLeducation

    @NEDLeducation

    Жыл бұрын

    Hi Wilton, and thanks for the suggestion! I have got a video on a very similar topic in the pipeline :)

  • @wiltonhotz

    @wiltonhotz

    Жыл бұрын

    @@NEDLeducation fantastic! 😁🙏

  • @wiltonhotz

    @wiltonhotz

    Жыл бұрын

    @@NEDLeducation it's perhaps out of scope for you videos, but it would be interesting to hear your thoughts on some of the models being presented. The good, the bad, the ugly. Perhaps that's for another playlist, but I would listen to it :)

  • @ferencfuleki9984
    @ferencfuleki9984 Жыл бұрын

    Savva!Is there a Way to incorporate heteroscedasticity and correlation to Monte Carlo generated Time series?

  • @amitkumarsingh4489
    @amitkumarsingh4489 Жыл бұрын

    great video - as usual - just wondering why standard deviation (variance) is often multiplied by square of time period (specially 252 ) ? i noticed that you haven't done that in the volatility calculation in this simulation . - thanks for the lessons once again

  • @NEDLeducation

    @NEDLeducation

    Жыл бұрын

    Hi Amit, and glad you liked the video! This is to annualise daily data - as there are 252 trading days in a year and volatility scales as a square root (variance scales linearly) with time. Similarly, you can use SQRT(12) to annualise monthly data or SQRT(52) for weekly data.

  • @amitkumarsingh4489

    @amitkumarsingh4489

    Жыл бұрын

    @@NEDLeducation thanks you so much .this means the simulation is running at daily .go it thanks

  • @terrythorley5046
    @terrythorley5046 Жыл бұрын

    @NEDL Awesome video! Made this very difficult concept very easy to digest and understand, well done! I don't know if it's possible, but was wondering if I could reach out to you and ask a few questions about something related to this topic, but using it in what might be an unusual fashion? Let me know and if not, no hard feelings! Either way, thanks for the great video!

  • @NEDLeducation

    @NEDLeducation

    Жыл бұрын

    Hi Terry, and thanks for the comment! Yes, it is possible to reach out to me with questions and even schedule a one-to-one chat - I provide this as my Patreon benefits :)

  • @davidghope1
    @davidghope16 ай бұрын

    Is there a similar exercise that could use the covariance matrix instead of the correlation matrix ?

  • @EGYPTa11
    @EGYPTa1111 ай бұрын

    Thank you so much for the video. I implemented it in a totally different field and it works perfectly. My only question is how to implement the same method for different types of distributions (Beta, Gamma, Lognormal)? I would highly appreciate if you can just give me a hint. @NEDleducation

  • @anasmusah2580

    @anasmusah2580

    6 ай бұрын

    please did you get solution to your question?

  • @thangde1
    @thangde1 Жыл бұрын

    If I use a Triangular random number instead of Normal random, what should I do?