Monte Carlo Simulation of Stock Price Movement

  Рет қаралды 95,572

Option Trader

Option Trader

Күн бұрын

Пікірлер: 65
@robertovalle655
@robertovalle655 4 жыл бұрын
OMG this is amazingly simple and so clear!!! Why cant my professors explain it like you? THANK YOU!!!
@pat.himanshu
@pat.himanshu 5 жыл бұрын
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
@trivestfinancetv 4 жыл бұрын
Thanks, I was getting NUMs; let me work on it
@mauricewelter8751
@mauricewelter8751 3 жыл бұрын
Thx, legend
@jonathanponnudurai9421
@jonathanponnudurai9421 3 жыл бұрын
12:25-13:40 I've been looking for this explanation everywhere.. thanks !
@alexthack
@alexthack 3 жыл бұрын
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
@xinyanwei4407 7 жыл бұрын
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
@OptionTrader 6 жыл бұрын
Thanks
@icyboy771z
@icyboy771z 3 жыл бұрын
@@OptionTrader Why do you use ln and not just divide the prices?
@samtj3524
@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
@phillphall 5 жыл бұрын
This is the video I was looking for. Thanks for this!
@muratnewman5345
@muratnewman5345 2 жыл бұрын
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
@OptionTrader 2 жыл бұрын
I will not be more accurate. Both should provide the same results.
@navjeetshaha6339
@navjeetshaha6339 5 жыл бұрын
Great explanation sir but just one doubt ...Where are we using probability in this...?? and why have we used the exp func...
@soumenmukherjee2969
@soumenmukherjee2969 9 ай бұрын
same videos was published by Garg University "Predicting Stock Price Movement using Monte Carlo Simulations".
@javierbonza6316
@javierbonza6316 4 жыл бұрын
Crystal clear! Really very well explained. Congrats and many thanks
@wolfgangi
@wolfgangi 3 жыл бұрын
Sir this is a great video. Thank you for putting this out.
@Akshay-fz7ms
@Akshay-fz7ms Жыл бұрын
Thanks it's an awesome video for a newbie like me
@Tyokok
@Tyokok 6 жыл бұрын
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
@Kig_Ama 4 жыл бұрын
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
@Financial_Maven 4 жыл бұрын
I too had that question. However, I believe you meant (14.73-14.67)/14.67.
@BDQUERY350
@BDQUERY350 4 жыл бұрын
@@Financial_Maven "continuous capitalization" greetings from Peru (South america) my friends.
@yu6601
@yu6601 5 жыл бұрын
You are really kind to share this, thanks!
@marsulsiregar7583
@marsulsiregar7583 4 жыл бұрын
This video is wonderful, good explanation of the analysis
@Financial_Maven
@Financial_Maven 4 жыл бұрын
Awesome video, very clear. Can you explain how to price an option using Monte Carlo simulation?
@OptionTrader
@OptionTrader 4 жыл бұрын
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
@deepsammanna 7 жыл бұрын
Bro F4 will put $ symbol. CTR+shift+down arrow will select till last data.
@OptionTrader
@OptionTrader 6 жыл бұрын
Thanks Bro!
@panosdoukas9742
@panosdoukas9742 4 жыл бұрын
Why do you use the small formula? I was thinking of applying that to 2 stock prices and generate correlated time series.
@davidgutierrez8795
@davidgutierrez8795 5 жыл бұрын
Thank you Professor Ramanujan!
@davidgutierrez8795
@davidgutierrez8795 5 жыл бұрын
How will you do the same in Python?
@mutlugundiler4458
@mutlugundiler4458 3 жыл бұрын
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
@OptionTrader 3 жыл бұрын
That method will generate new numbers for you as end results. This method will pick auctual numbers from History. Either can be used.
@kaushalthakker1682
@kaushalthakker1682 4 жыл бұрын
Wont adjusted stock price be better for the analysis?
@laurenbennett9497
@laurenbennett9497 3 жыл бұрын
why are you using ln for daily changes?
@OptionTrader
@OptionTrader 3 жыл бұрын
That is the formula for continuous compounding.
@waterfun2610
@waterfun2610 2 жыл бұрын
Can you kindly provide us with the worksheet please?
@wilsonp2207
@wilsonp2207 5 жыл бұрын
Any idea on finding the average of, for example, 1000 simulations? Or maybe even expected value of the average?
@OptionTrader
@OptionTrader 5 жыл бұрын
Need to make 1000 columns, or use VBA in excel. Maybe easier in C++ or Matlab.
@rickieashonmede8907
@rickieashonmede8907 2 жыл бұрын
Is there anyway I can reach you?
@faiyadferdoussium9112
@faiyadferdoussium9112 2 жыл бұрын
I have a question can you help me to solve it please ?
@scottboutaugh8447
@scottboutaugh8447 6 жыл бұрын
I can't get my columns to be error free - whats the trick? Some are fine, others get the #NUM! error. Thanks!
@OptionTrader
@OptionTrader 6 жыл бұрын
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
@mervebilgin7722 4 жыл бұрын
hi everyone, ı need help :/ when ı see date ı saw dates appear in reverse order which one is right
@Nereus00
@Nereus00 3 жыл бұрын
can you put the excell file here to download?
@AbhishekYadav-bx7hr
@AbhishekYadav-bx7hr 5 жыл бұрын
Please make the vedio on utilty calculation of the stock price
@vts1905
@vts1905 7 жыл бұрын
It is possible to provide the excel template please?
@davidgutierrez8795
@davidgutierrez8795 5 жыл бұрын
lol what else do you want, a coffee?
@ricomajestic
@ricomajestic 5 жыл бұрын
@@davidgutierrez8795 Yes, please!
@TimTheMusicMan
@TimTheMusicMan 6 жыл бұрын
can you make a template available ?
@kedarnathzadbuke1198
@kedarnathzadbuke1198 3 жыл бұрын
Add concepts of drift and noise and wiener process
@sandeeppai2271
@sandeeppai2271 4 жыл бұрын
It would b nice if you could upload the file for us to learn
@nadonadia2521
@nadonadia2521 3 жыл бұрын
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
@ricosuave666 6 жыл бұрын
this technique gave me a great idea but having all those lines in the graph is unnecessary because this is not technical analysis.
@xxMikePortnoyJrxx
@xxMikePortnoyJrxx 5 жыл бұрын
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
@Chribeify 4 жыл бұрын
This video killed my ears
@pankjain25
@pankjain25 7 жыл бұрын
I am getting number errors in excel shet
@OptionTrader
@OptionTrader 6 жыл бұрын
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
@wheatland5032 Жыл бұрын
a few python scripts will do the same thing!!!!!
@rboolean693
@rboolean693 Жыл бұрын
operators crying in corner
@Nereus00
@Nereus00 3 жыл бұрын
get a more powerful pc dude ahah
Monte Carlo Simulation of a Stock Portfolio with Python
18:23
6. Monte Carlo Simulation
50:05
MIT OpenCourseWare
Рет қаралды 2 МЛН
Random Emoji Beatbox Challenge #beatbox #tiktok
00:47
BeatboxJCOP
Рет қаралды 17 МЛН
ЛУЧШИЙ ФОКУС + секрет! #shorts
00:12
Роман Magic
Рет қаралды 10 МЛН
Using Monte Carlo simulations for valuation
9:53
Financial Analysis with Dr Jeff
Рет қаралды 18 М.
How to Simulate Stock Price Changes with Excel (Monte Carlo)
9:59
Matt Macarty
Рет қаралды 227 М.
Stock Portfolio Monte Carlo Simulation In Excel
8:09
Ryan O'Connell, CFA, FRM
Рет қаралды 32 М.
Monte Carlo Simulation in Excel - Retirement Savings
16:39
Ronald Moy, Ph.D., CFA, CFP
Рет қаралды 42 М.
Session 6B: Monte Carlo Simulations in Finance & Investing
21:17
Aswath Damodaran
Рет қаралды 52 М.
Predicting Stock Price Movement using Monte Carlo Simulations
14:37
Garg University
Рет қаралды 41 М.
Monte Carlo Method: Value at Risk (VaR) In Excel
10:13
Ryan O'Connell, CFA, FRM
Рет қаралды 52 М.
What is a Monte Carlo Simulation?
7:31
Online PM Courses - Mike Clayton
Рет қаралды 121 М.
Monte Carlo Simulation
10:06
MarbleScience
Рет қаралды 1,4 МЛН