Stock Portfolio Monte Carlo Simulation In Excel

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

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

  • @RyanOConnellCFA
    @RyanOConnellCFA  Год назад +3

    🔑 Join this channel to get access to perks & support my work: ruclips.net/channel/UCAkyj2N9kd0HtKhCrejsYWQjoin
    💾 Download Free Excel File:
    ► Grab the file from this video here: ryanoconnellfinance.com/product/stock-portfolio-monte-carlo-simulation-excel-spreadsheet/

  • @alainrouleau
    @alainrouleau 7 месяцев назад +3

    Very interesting, thanks. I love Monte Carlo simulations.
    Keep up the good work! 👍

    • @RyanOConnellCFA
      @RyanOConnellCFA  6 месяцев назад

      Glad you enjoy it and there are more to come!

  • @TreyJam2
    @TreyJam2 4 месяца назад +2

    I appreciate the video you explained it well and it was concise 👍

    • @RyanOConnellCFA
      @RyanOConnellCFA  4 месяца назад

      Glad it was helpful! Thank you for letting me know. I just looked up your channel and your videos are hilarious! Keep it up

  • @richardgordon
    @richardgordon 5 месяцев назад +2

    Just learning about Monte Carlo Simulations and this is a very good example!

  • @williama.rivera9414
    @williama.rivera9414 2 года назад +2

    Thank you for share Ryan. Another interesting topic.

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

      You are very welcome and I'm glad you enjoyed it William

  • @irenemii
    @irenemii Месяц назад

    How did you calculate the year end value? It doesn’t appear automatically for me so there is a mistake in table

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

    Thank you so much sir, it helped me a lot.

  • @octavearmand4679
    @octavearmand4679 4 месяца назад

    Hello,
    Can you explain why we use the norm.inv formula, and why is it more relevant than simply using the random variable ?
    Thanks

  • @ManjitSandhu
    @ManjitSandhu 6 месяцев назад +1

    Thank you for the share. Excellent video and chart. One question.. It seems to be set for 40 years. What if I need to do only 30 years. I do not see that option. If I delete the last 10 years the chart does not function.

    • @RyanOConnellCFA
      @RyanOConnellCFA  6 месяцев назад

      My pleasure! You would need to update any formulas that have the range of data in them so that you are not breaking any formulas

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

    Wow, amazing tool and description. Thank you.
    .
    Investigation into mean-variance of portfolio asset allocation led me here. Where could I find a definitive source of (historical) means and standard deviations of various allocation % across asset classes?
    .
    I'm thinking I could plug in those figures for each asset allocation choice into the spreadsheet to get a feel for which allocation breakdown(s) are best suited for me.

    • @RyanOConnellCFA
      @RyanOConnellCFA  Год назад

      Thank you!
      You can Google your inquiry and there are a number of different studies that come up. They will differ based on the time periods used. I don't feel comfortable calling any of them the definitive source.
      You can also just calculate these values yourself using ETFs or indexes as proxies

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

    Hey Ryan thnak you so much for rour interesting videos on VaR, can you please do a video on how to calculate a stressed VaR i've been looking for it in youtube for a good time and nobody explain how to implememt it. thank u so much

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

      Good suggestion, I'll look into that in the future!

  • @charlziedouglas-mo7uc
    @charlziedouglas-mo7uc 9 месяцев назад +1

    Hi Ryan can the Markov transition matrix apply to this?

    • @RyanOConnellCFA
      @RyanOConnellCFA  8 месяцев назад

      Hello, yes, a Markov transition matrix can be applied to a stock portfolio Monte Carlo simulation in Excel to model the probabilities of different market states and their impacts on portfolio returns

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

    What can you do about equity research (buy, hold, sell) on monte carlo

    • @RyanOConnellCFA
      @RyanOConnellCFA  Год назад

      Monte Carlo simulations can be super helpful for stock analysis! Just create a model using historical data, financial ratios, and other factors. Run the simulations, check the risk-reward balance, and see how it fits your investment goals. Then, decide whether to buy, hold, or sell. Just remember, these simulations have their limits, so don't forget to do some extra research and seek professional advice

  • @navagiopoint
    @navagiopoint Год назад +3

    beautifully explained.

  • @achalagarwal2004
    @achalagarwal2004 8 месяцев назад +1

    Hi Ryan what is the time horizon for this simulation?

    • @RyanOConnellCFA
      @RyanOConnellCFA  6 месяцев назад

      @2:16 it can be seen that the time period for this simulation is 40 years

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

    I have come across a research paper in which they have developed regression models using past data (uptil 2016). The pdfs of variables were already known from literature review. For 2017 onwards, they utilized the forecasted values as the mean of the distribution and took 10% of that mean as standard deviation for each year, and performed MCS to calculate annual uncertainty. Is there any relation or basis for taking 10% of mean as SD for future uncertainty analysis? I have analyzed the past data as well SD is nowhere near 10% of the mean value.

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

      That is really strange to me and I can't intuitively figure out why they would use 10% of the mean as standard deviation off the top of my head. That doesn't make sense to me but maybe there is something we are both overlooking

    • @hsf2047
      @hsf2047 Год назад

      @@RyanOConnellCFA could you kindly provide me with your email or any other medium where I could share the paper with you along with my working?

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

    can you combine this with solver?

    • @RyanOConnellCFA
      @RyanOConnellCFA  Год назад

      If you're looking to find an optimal portfolio using the solver then check out this video: ruclips.net/video/XQS17YrZvEs/видео.html

  • @handsomehugh
    @handsomehugh Год назад +5

    The chart's y axis should be whole number representing number of iterations rather than currency.

  • @יעקבע-ל8נ
    @יעקבע-ל8נ 6 месяцев назад

    remarkable!👏

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

    What is the main reason we would use a monte carlo simulation? If we can just do the math (Return * n) - zscore*(sqr(n)*standard deviation) for investment returns why would we use the simulation? It makes sense in this use case because it was by far quicker to use the simulation than to do the math by hand, but if there is a use case where doing the math by hand is relatively easy would we want to use Monte Carlo?

    • @RyanOConnellCFA
      @RyanOConnellCFA  Год назад +4

      Great question! While mathematical models can be very effective, they often assume a normal distribution and constant volatility, which may not accurately reflect the real-world complexity of financial markets. Monte Carlo simulations offer a way to model random variables with different types of uncertainty, and they allow us to account for events that might not be considered in traditional mathematical models, such as rare events with significant impacts (i.e., black swan events).
      Simulations can also take into account the potential dependencies and interactions among multiple variables, which could be hard to incorporate into a simple equation. Therefore, even if the math might be easier or faster to compute in some cases, a Monte Carlo simulation can provide a more realistic, detailed, and nuanced view of potential outcomes. However, as always, the choice between a simulation and a mathematical model depends on the specific circumstances and the level of complexity you're comfortable with.

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

    Thanks for the video! Question: how do you account for portfolios that might have a much higher standard deviation such that you might randomly simulate returns of less than -100% (losing more than principle)

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

      I think you could use an IF function in excel to wrap around the value and essentially say that if the loss goes below -100% it will just be -100%

  • @simonr-vp4if
    @simonr-vp4if Год назад +2

    At 6:59 you should not change the y-axis to dollars - it's a (dimensionless) count of how many trials ended up in each bin. Dollar value is on the x-axis.

    • @RyanOConnellCFA
      @RyanOConnellCFA  Год назад

      Good point, that should have just stayed numerical!

  • @danielconnell933
    @danielconnell933 3 месяца назад

    Why did you use arithmetic mean instead of geometric mean

  • @MannyBernabe
    @MannyBernabe 11 месяцев назад +1

    🔥