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
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
I was trying to figure this out on my own, was wasting too much time. Glad you have this posted.
This was super usefull for my job. Big thanks mate! Great explanation!
Great video, thank you. Straight to the point and very clear
Bro your video literally saved my day. Thank you so much!
Very Intuitive video. Multivariate data is always fun to work on !
great explanation. Thanks mate
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
Жыл бұрын
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
Excelent video as always! Out of curiosity, is it ok to use the empirical distribution of each stock when generating the uncorrelated Z-Stats?
Super video! Thanks
Thanks… just submitted one of my assignments :) … with JetFuel Prices correlated with Exchange rate against US$… both moving and yet have some correlation..
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
Thank you for your great content. Could you make a video of how we can minimize the CVaR of a portfolio?🙏
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
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?
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
Жыл бұрын
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
Hey Sabha, i wanted to ask if can you use monte carlo to simulate the correlation coefficient. Correlation matrix table?
can you explain more about what can we conclude from the simulation in the video. This video is fantastic
Are the first columns of the Correlation Matrix and Choelsky decomposition expected to be the same as in this example ?
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
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
Жыл бұрын
Hi Wilton, and thanks for the suggestion! I have got a video on a very similar topic in the pipeline :)
@wiltonhotz
Жыл бұрын
@@NEDLeducation fantastic! 😁🙏
@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 :)
Savva!Is there a Way to incorporate heteroscedasticity and correlation to Monte Carlo generated Time series?
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
Жыл бұрын
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
Жыл бұрын
@@NEDLeducation thanks you so much .this means the simulation is running at daily .go it thanks
@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
Жыл бұрын
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 :)
Is there a similar exercise that could use the covariance matrix instead of the correlation matrix ?
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
6 ай бұрын
please did you get solution to your question?
If I use a Triangular random number instead of Normal random, what should I do?