If you have not found a response to the inquiry; the quickest method to create the formulas in Excel is by using the INSERT->Equation menu option. The best way is to use LaTeX. I love LaTex; I began using it over two decades ago, at NASA, as a summer intern, when it was just TeX.
@11:00 why do we need to introduce volatility into return? If bsm assumes mean return as risk free rate u(mu), then shouldn't it be 'risk free'? Why should it be affected by volatility?
first, mu isn't necessarily the risk-free rate. its the expected arithmetic mean of the change in stock price over time. second, i think subtracting volatility is just a clever way to transform from arithmetic to geometric mean. i imagine it just comes out of the math of trying to equate the two approaches.
@@SpindicateAudio thanks for reply. I am talking about mu from bsm pov. In bsm model assumption, isn't mu geometric mean for risk free rate 'r'? My question is it sounds counterintuitive to call it risk free rate and adjust it with volatility.
can you please request in our forum, here is the thread for this videowww.bionicturtle.com/forum/threads/t4-10-lognormal-property-of-stock-prices-assumed-by-black-scholes.22469/
so far the best lognormal of price and relation of returns explained! Thanks a lot1
You're welcome! Thank you for watching :)
Thank you so much. This video clarified a lot of confusion around lognormal dist'n!
Great video, David, as always!
Although, your audio output was only in the left speaker.
Yeah, I find that out today as well, then I thought my mac is broken, but it works fine when playing other channel's video
9:00 this is empirically determined n the Fame French model
My right ear is lonely :/
my left ear did
How do you show that a random variable is log normally distributed if the log ratio of it is normal?
Thank you for the video. Question: shouldn’t be σ^2T the variance of ln(ST/S0) and of ln ST?
so the y axis says that the mean return is 16%? thanks
What do the symbols (Phi) in the equation represent?
Thanks for the lecture sir. How did you get those equations ? Is there any video on that. ?
If you have not found a response to the inquiry; the quickest method to create the formulas in Excel is by using the
INSERT->Equation menu option.
The best way is to use LaTeX. I love LaTex; I began using it over two decades ago, at NASA, as a summer intern, when it was just TeX.
@11:00 why do we need to introduce volatility into return? If bsm assumes mean return as risk free rate u(mu), then shouldn't it be 'risk free'? Why should it be affected by volatility?
first, mu isn't necessarily the risk-free rate. its the expected arithmetic mean of the change in stock price over time.
second, i think subtracting volatility is just a clever way to transform from arithmetic to geometric mean. i imagine it just comes out of the math of trying to equate the two approaches.
@@SpindicateAudio thanks for reply. I am talking about mu from bsm pov. In bsm model assumption, isn't mu geometric mean for risk free rate 'r'? My question is it sounds counterintuitive to call it risk free rate and adjust it with volatility.
great video
Thank you for watching!
hi great video again, but I couldn't the link to the excel though?
can you please request in our forum, here is the thread for this videowww.bionicturtle.com/forum/threads/t4-10-lognormal-property-of-stock-prices-assumed-by-black-scholes.22469/
Mistakes:
variance is sigma square x T not delta t.
The excel sheet formaula there is extra sigma.