Monte Carlo Simulation of Stock Price Movement

[@robertovalle655]

OMG this is amazingly simple and so clear!!! Why cant my professors explain it like you? THANK YOU!!!

[@pat.himanshu]

If you are getting Num Errors check the Randbetween function. In general, it should be (total number of rows - 2). So if you have 252 rows you randbetween should by between 1 and 250.

[@trivestfinancetv]

Thanks, I was getting NUMs; let me work on it

[@mauricewelter8751]

Thx, legend

[@jonathanponnudurai9421]

12:25-13:40 I've been looking for this explanation everywhere.. thanks !

[@alexthack]

I use a similar technique, but prefer Index/match with randbetween and use adjusted closing prices. I find the program runs faster that way. I run 30day simulations across 1000 columns and plot the discrete prices that emerge on a histogram. I use it to find likelihood of my options getting exercised across a 30 day perioid. The only problem I find with this technique is you limit your data points to the discrete prices in your sample vs. a continuous probability distribution (e.g. normal curve, lognormal, etc.). In other words, we do not allow for all potential %s into our analysis vs. the actual transactions. Its a good starting point.

[@xinyanwei4407]

Very helpful. Although I was searching for clips to explain Monte Carlo methodology used in Project Management and found this video. It relates the practical use case to the concept perfect. Very easy to understand! Thank you!

[@OptionTrader]

Thanks

[@icyboy771z]

@@OptionTrader Why do you use ln and not just divide the prices?

[@samtj3524]

@@icyboy771z The changes will be also be backwards-symmetrical. a/b and b/a are not the same in the slightest, but log(a/b) and log(b/a) are indifferent in all aspects but the negative sign.

[@phillphall]

This is the video I was looking for. Thanks for this!

[@muratnewman5345]

Would be more accurate if you choose a gaussian distribution around a pre-defined central tendency (of ema of 5 years for instance) instead of a random number choosen by the software. That's how we use it for defining manufacturing tolerances on blueprints. When the machinists make parts, there is alaways a tendency to hit the nominal values, therefore the probability goes down as the value nears upper and lower spec limits (worst case scenarios) . Stock prices follow similar pattern, there is always a tendency to go back to the mean, to the trendline of a certain period. I think it should be a part of the method here. Nice use of excel by the way!

[@OptionTrader]

I will not be more accurate. Both should provide the same results.

[@navjeetshaha6339]

Great explanation sir but just one doubt ...Where are we using probability in this...?? and why have we used the exp func...

[@soumenmukherjee2969]

same videos was published by Garg University "Predicting Stock Price Movement using Monte Carlo Simulations".

[@javierbonza6316]

Crystal clear! Really very well explained. Congrats and many thanks

[@wolfgangi]

Sir this is a great video. Thank you for putting this out.

[@Akshay-fz7ms]

Thanks it's an awesome video for a newbie like me

[@Tyokok]

Thanks for the video! one question,what is your horizontal axis in your example? is it days? So when we are asked about a particular day, you will give VaR from that particular day distribution?

[@Kig_Ama]

1:13 Why dont u calculate the change as (price today - price yesterday)/price yesterday = (14.67-14.73)/14.73 ? Why do u use the natural logarithm?

[@Financial_Maven]

I too had that question. However, I believe you meant (14.73-14.67)/14.67.

[@BDQUERY350]

@@Financial_Maven "continuous capitalization" greetings from Peru (South america) my friends.

[@yu6601]

You are really kind to share this, thanks!

[@marsulsiregar7583]

This video is wonderful, good explanation of the analysis

[@Financial_Maven]

Awesome video, very clear. Can you explain how to price an option using Monte Carlo simulation?

[@OptionTrader]

Two more steps will be needed. Building the CDF curve, and multiplying the probability of option to Pay with the its payoff. Will make a video on it soon.

[@deepsammanna]

Bro F4 will put $ symbol. CTR+shift+down arrow will select till last data.

[@OptionTrader]

Thanks Bro!

[@panosdoukas9742]

Why do you use the small formula? I was thinking of applying that to 2 stock prices and generate correlated time series.

[@davidgutierrez8795]

Thank you Professor Ramanujan!

[@davidgutierrez8795]

How will you do the same in Python?

[@mutlugundiler4458]

Dear Option Trader. Please check my understanding of you using the SMALL function. Have I understood you correctly? One way of selecting random values from the "change" set (distribution) is to assume it is Normally or LogNormally distributed, calculate the distribution parameters, and select random values from the distribution you define, as needed. However, you are not doing this, instead, you are selecting the Is this what you intended to do? If so why? What advantage do you think this method has. Thank you.

[@OptionTrader]

That method will generate new numbers for you as end results. This method will pick auctual numbers from History. Either can be used.

[@kaushalthakker1682]

Wont adjusted stock price be better for the analysis?

[@laurenbennett9497]

why are you using ln for daily changes?

[@OptionTrader]

That is the formula for continuous compounding.

[@waterfun2610]

Can you kindly provide us with the worksheet please?

[@wilsonp2207]

Any idea on finding the average of, for example, 1000 simulations? Or maybe even expected value of the average?

[@OptionTrader]

Need to make 1000 columns, or use VBA in excel. Maybe easier in C++ or Matlab.

[@rickieashonmede8907]

Is there anyway I can reach you?

[@faiyadferdoussium9112]

I have a question can you help me to solve it please ?

[@scottboutaugh8447]

I can't get my columns to be error free - whats the trick? Some are fine, others get the #NUM! error. Thanks!

[@OptionTrader]

Number error could be for several reasons including if you are dicing by zero or taking log of negtive number. So, look out for that.

[@mervebilgin7722]

hi everyone, ı need help :/ when ı see date ı saw dates appear in reverse order which one is right

[@Nereus00]

can you put the excell file here to download?

[@AbhishekYadav-bx7hr]

Please make the vedio on utilty calculation of the stock price

[@vts1905]

It is possible to provide the excel template please?

[@davidgutierrez8795]

lol what else do you want, a coffee?

[@ricomajestic]

@@davidgutierrez8795 Yes, please!

[@TimTheMusicMan]

can you make a template available ?

[@kedarnathzadbuke1198]

Add concepts of drift and noise and wiener process

[@sandeeppai2271]

It would b nice if you could upload the file for us to learn

[@nadonadia2521]

great example, but I do not agree with you, your simulation is based upon very old values, in order to make it more accurate you have to add latest days and exclude the old ones as the time passes

[@ricosuave666]

this technique gave me a great idea but having all those lines in the graph is unnecessary because this is not technical analysis.

[@xxMikePortnoyJrxx]

The purpose of this simulation is not for technical analysis. The purpose of doing this in relation to options, is to use all of these possible price paths to calculate a theoretical option value. For instance, when I test options trading strategies that I may want to use, I will use this to generate theoretical option prices. When doing this, it is not necessary to plot all curves.

[@Chribeify]

This video killed my ears

[@pankjain25]

I am getting number errors in excel shet

[@OptionTrader]

Number error could be for several reasons including if you are dicing by zero or taking log of negtive number. So, look out for that.

[@wheatland5032]

a few python scripts will do the same thing!!!!!

[@rboolean693]

operators crying in corner

[@Nereus00]

get a more powerful pc dude ahah