Why are the formulas in the 'D' column inconsistent? In the 'D9' cell, you divide current day by the previous day, but in all subsequent cells, you divide previous by current
Thx for the great explanation. There seems to be a typo in the xls. It seems only the first relative (cell D9) is correct - the others are calculated as S(i-i)/Si.
Yes, you are totally correct ... such that the prior returns are negatives of those shown (e.g., -1.63% rather than 1.63%). Although because the first is correct, and the squared-returns are identical, it turns out to have no impact on the rest of the results! But you are still totally correct, great observation ...
A link to the spreadsheet is found in the description, at the beginning; ie, the XLS is at trtl.bz/2JQufJy . I calculated 0.880348% by applying the "tedious" GARCH(1,1) on the previous day, σ^2(n-1). Thanks!
After seeing the second video on this topic, I started to get a light grasp! THank you so much for clearly explaining this!
Super clear! Thanks a lot admin
Thank you for watching!
Perfectly explained Sir!
Thanks David ! good explanation as always.
Why are the formulas in the 'D' column inconsistent? In the 'D9' cell, you divide current day by the previous day, but in all subsequent cells, you divide previous by current
Thx for the great explanation. There seems to be a typo in the xls. It seems only the first relative (cell D9) is correct - the others are calculated as S(i-i)/Si.
Yes, you are totally correct ... such that the prior returns are negatives of those shown (e.g., -1.63% rather than 1.63%). Although because the first is correct, and the squared-returns are identical, it turns out to have no impact on the rest of the results! But you are still totally correct, great observation ...
Superb, as usual
Its possible to share this spreadsheet? I dont understand what isthe 0.880348% means... its the cel S73 and isnt possible to see... Thank you!
A link to the spreadsheet is found in the description, at the beginning; ie, the XLS is at trtl.bz/2JQufJy . I calculated 0.880348% by applying the "tedious" GARCH(1,1) on the previous day, σ^2(n-1). Thanks!
Please throw more light on the Long Run Variance. Will it be given directly to us on the FRM exam?
That's my question too.
Can I use GARCH (1,1) for portfolio returns, or GARCH (1,1) just applicable for a single security returns?
Awesome video. Thank you!
Amazing again. Thanks!
How can I calculate the long run variance?
Please someone answer
@@akibnizamify Using eviews i think
Question might be kind of dumb, how did you obtain the volatility for the day prior at 12:35
nvm i watched the the how to calculate historical vol video.
I have the same question
great!
Thank you for watching!
O'Keefe Squares
6:34
Gusikowski Lock