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
Hey man great!!!!! Let's all start a movement to get Sava to 10K in a few days and then 100K by the end of this year! Such a great channel for researchers, teachers and applied practioners!
Hello, thank you for this video. Very much enjoyed it and pretty much all of your videos. By far the best account on TH-cam to learn this stuff in excel. Was also wondering if you have ever heard of the HAR and HARQ volatility models and if you could possibly make a video about it? If not, no worries. Thank you for all that you do. I've learned a lot since finding your account.
Wtf omg you are so fuck god. I understand heston model for the long time but stochastic volatility problem is hard to estimation but you just use the excel and with technique iferror of excel. This is fucking impressive. I love your video. Thank you for the great knowledge.
In best case, this might be only a very rough approximation of Heston. Variance is not observable in Heston. In this Excel it is substituted with a single (!!!) squared return. Also, the likelihood function seems to have a mistake in the dW2 part (not accounting for the root-of-variance term in the variance process).
Hi @NEDL, thanks for sharing this video , I think there is an error in the cell-locking for the log-likelihood column, you want to lock cells $J11 , $J12 but only columns are locked, not rows, and indeed when you apply the formula for all the column , it returns some inconsistent results , like in G19 where the value is massively different from the others. Please check, I hope I got it right . Thanks again for sharing , great resource!
Great video! I wonder how this model could be done with Monte Carlo simulation in Excel though. Would be great if there's an explanation about how it works under MC simulation.
Hello! Thank you very much for the video, it's extremely useful. Would you please have a reference to an academic paper that uses this method to calibrate the Heston Model? Your answer would be very helpful for me, thanks in advance.
I have a question about realized and expected variance: Should they be close to one another or not? Because if yes, than it is weird that the average of (1-F3/E3) and so on is at -292k instead of 0.
I don't understand why variance is your residual squared, when your residual is not 0,0158 but instead 1,58... When you calculate the drift you get 0,0945 but when you then calculate the residual you subtract 0,0945 with -1,49%. This seems wrong..?
![[FULL EP.16] เซียนพาลุย "เผือก-ฟรอยด์" กรี๊ดลั่น จนปูหนี | เฮ็ดอย่างเซียนหรั่ง | One Playground](http://i.ytimg.com/vi/FsqUvwS3b-Y/mqdefault.jpg)
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
Hey man great!!!!! Let's all start a movement to get Sava to 10K in a few days and then 100K by the end of this year! Such a great channel for researchers, teachers and applied practioners!
Hi, and thanks so much for the kind words and for being around when the channel cracked 10k!
@@NEDLeducation best wishes and congratulations Sava!!
Highly technical topic explained in such a smooth and friendly way, always a pleasure learning from you!
You have no idea how long I've been waiting for this video :) Almost there 9.98K subs!
Very good video. Thank you. You are very good at talking and showing these complex topics
Thankyou Sir......Complex concept in easy way.....
Thanks for this video! Very well explained.
Hello, thank you for this video. Very much enjoyed it and pretty much all of your videos. By far the best account on TH-cam to learn this stuff in excel. Was also wondering if you have ever heard of the HAR and HARQ volatility models and if you could possibly make a video about it? If not, no worries. Thank you for all that you do. I've learned a lot since finding your account.
Hi Joe, and many thanks for such kind words, appreciate your feedback. Will absolutely do a video on these models at some point in the near future.
@@NEDLeducation Awesome, Thank you.
Wtf omg you are so fuck god. I understand heston model for the long time but stochastic volatility problem is hard to estimation but you just use the excel and with technique iferror of excel. This is fucking impressive. I love your video. Thank you for the great knowledge.
In best case, this might be only a very rough approximation of Heston. Variance is not observable in Heston. In this Excel it is substituted with a single (!!!) squared return. Also, the likelihood function seems to have a mistake in the dW2 part (not accounting for the root-of-variance term in the variance process).
Hi @NEDL, thanks for sharing this video , I think there is an error in the cell-locking for the log-likelihood column, you want to lock cells $J11 , $J12 but only columns are locked, not rows, and indeed when you apply the formula for all the column , it returns some inconsistent results , like in G19 where the value is massively different from the others.
Please check, I hope I got it right . Thanks again for sharing , great resource!
Great video! I wonder how this model could be done with Monte Carlo simulation in Excel though. Would be great if there's an explanation about how it works under MC simulation.
Why there was no use of Brownian parts (dW) of the Mean and variance processes? Doesn't it need to be simulated ?
Been wondering about this myself.
Hello! Thank you very much for the video, it's extremely useful. Would you please have a reference to an academic paper that uses this method to calibrate the Heston Model?
Your answer would be very helpful for me, thanks in advance.
Hi Can you also do the Heston nandi Garch model video, thanks in advance😊
I have a question about realized and expected variance: Should they be close to one another or not? Because if yes, than it is weird that the average of (1-F3/E3) and so on is at -292k instead of 0.
I don't understand why variance is your residual squared, when your residual is not 0,0158 but instead 1,58... When you calculate the drift you get 0,0945 but when you then calculate the residual you subtract 0,0945 with -1,49%. This seems wrong..?
I watched the video a couple of times but I can't find where you actually price call/put options or how to do it. Can you please explain.
Hi there. Is there an issue that the Feller condition is not satisfied?
How do you make predictions for the stock price with this model?
Hello and thanks for the video!!! it was very helpful. Please can i get the simulation paths of stock and volatility?
Why is the drift estimated as the average of log returns?
Because why not? An alternative to that is to use the risk-free rate of an investment as the drift.
Can you please calculate the Greeks for Heston model ?
Can you please estimate shock return and make a video?
is there a paper to support this method to find the parameters? Thanks!!
Heston (1993)
Stock market interdependence, contagion, and the U.S. thankful
You just hit 10K subs while I was sending you a message over Patreon. Congrats! I encourage you to go read that message, for incentive reasons :P
11:41 pencet apa yah?
Very Low volume