NEDL
NEDL
  • 313
  • 1 623 084
Vector autoregression: forecasting and trading applications (Excel)
Today we are investigating vector autoregression (VAR) - a very prominent concept in time series econometrics - and how it can be used to forecast stock returns and construct simple trading strategies.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Investment Managemet!
Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation
Переглядів: 3 143

Відео

Covariance matrix shrinkage: Ledoit and Wolf (2004)
Переглядів 1,6 тис.4 місяці тому
Sample covariance matrix applications in portfolio optimisation are often criticised for the excessive noise that such matrices contain which results in "estimation error maximisation" and unrealistic optimal portfolios. Covariance matrix shrinkage as proposed by Ledoit and Wolf (2004) is one of the most commonly used and of the most elegant remedies for this issue. Today we are investigating h...
Gradient descent in Excel
Переглядів 1,3 тис.4 місяці тому
Gradient descent is a common and powerful algorithm that is commonly used by numerical optimisers. Today we are investigating the concepts behind gradient descent, looking into this "black box" and building an example of gradient descent with simple Excel functions. Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Excel! Please consider supporting NEDL on Pat...
Credit risk in Basel III: Risk-weighted assets explained (Excel)
Переглядів 3 тис.4 місяці тому
How to calculate risk-weighted assets for credit risk in Basel III? Today we are discussing the main concepts behind the risk weights, treatment of different assets and the logic behind it, and perform the calculation of Tier 1 capital ratio by using a real world example of Royal Bank of Scotland. Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Risk manageme...
Instrumental variable regression: TSLS explained (Excel)
Переглядів 1,6 тис.7 місяців тому
Instrumental variable regression: TSLS explained (Excel)
ARCD model explained: autoregressive conditional density (Excel)
Переглядів 9107 місяців тому
ARCD model explained: autoregressive conditional density (Excel)
PEG ratio explained: price to earnings growth (Excel)
Переглядів 1,6 тис.7 місяців тому
PEG ratio explained: price to earnings growth (Excel)
Sensitivity and scenario analysis in investment appraisal (Excel)
Переглядів 1,6 тис.8 місяців тому
Sensitivity and scenario analysis in investment appraisal (Excel)
Leave-two-out jackknife explained: advanced resampling (Excel)
Переглядів 5358 місяців тому
Leave-two-out jackknife explained: advanced resampling (Excel)
Annuity factors explained (Excel)
Переглядів 6278 місяців тому
Annuity factors explained (Excel)
Jackknife estimator explained: Leave-one-out technique (Excel)
Переглядів 1,8 тис.8 місяців тому
Jackknife estimator explained: Leave-one-out technique (Excel)
Payback period and discounted payback period (Excel)
Переглядів 5738 місяців тому
Payback period and discounted payback period (Excel)
KMV model application: Royal Bank of Scotland (2008)
Переглядів 1,5 тис.8 місяців тому
KMV model application: Royal Bank of Scotland (2008)
Joint tests for multiple assumptions: Jarque-Bera NHI test (Excel)
Переглядів 4429 місяців тому
Joint tests for multiple assumptions: Jarque-Bera NHI test (Excel)
Functional forms in OLS regression (Excel)
Переглядів 9619 місяців тому
Functional forms in OLS regression (Excel)
Chi-squared goodness-of-fit test explained (Excel)
Переглядів 9939 місяців тому
Chi-squared goodness-of-fit test explained (Excel)
GAS model with Johnson SU distribution (Excel)
Переглядів 1,3 тис.Рік тому
GAS model with Johnson SU distribution (Excel)
GAS model explained: Generalised autoregressive score (Excel)
Переглядів 1,6 тис.Рік тому
GAS model explained: Generalised autoregressive score (Excel)
Modelling stock returns: Mixture distributions (Excel)
Переглядів 2,4 тис.Рік тому
Modelling stock returns: Mixture distributions (Excel)
Implied volatility approximation: Brenner and Subrahmanyan method
Переглядів 1,7 тис.Рік тому
Implied volatility approximation: Brenner and Subrahmanyan method
Implied volatility explained: Solver and Newton-Raphson (Excel)
Переглядів 4,5 тис.Рік тому
Implied volatility explained: Solver and Newton-Raphson (Excel)
Stutzer performance index: probability of underperformance (Excel)
Переглядів 1,5 тис.Рік тому
Stutzer performance index: probability of underperformance (Excel)
Option pricing with transaction costs (Excel)
Переглядів 1,3 тис.Рік тому
Option pricing with transaction costs (Excel)
Lunar phases and stock returns (Excel)
Переглядів 1,8 тис.Рік тому
Lunar phases and stock returns (Excel)
Quantile regression in EViews
Переглядів 2,8 тис.Рік тому
Quantile regression in EViews
Binary choice models in EViews
Переглядів 1,7 тис.Рік тому
Binary choice models in EViews
Multiple regression in Python with statsmodels
Переглядів 2,6 тис.Рік тому
Multiple regression in Python with statsmodels
Barrier option valuation in Python: exotic options and Monte Carlo with Johnson SU
Переглядів 2,3 тис.Рік тому
Barrier option valuation in Python: exotic options and Monte Carlo with Johnson SU
Normality tests in EViews
Переглядів 5 тис.Рік тому
Normality tests in EViews
Robust standard errors in EViews
Переглядів 3,3 тис.Рік тому
Robust standard errors in EViews

КОМЕНТАРІ

  • @siddhantkohli5063
    @siddhantkohli5063 2 дні тому

    Was very confused until I found this gem thank you 💜

  • @prathamarora9181
    @prathamarora9181 3 дні тому

    please share all the excel files in the description

  • @mickeylu4901
    @mickeylu4901 5 днів тому

    hi, i am wondering, what i should do if i see the error about "name 'np' is not defined"

  • @henriqueguerino7108
    @henriqueguerino7108 5 днів тому

    That was helpful!! I'm in a data science course but it lacks statistic classes, so I can barely tell what that bunch of indicators on the summary mean. Do you recommend any book, course, paper or anything on statistics to help me understand the basis of it and what the indicators mean?

  • @user-su5mr7nv8q
    @user-su5mr7nv8q 6 днів тому

    Thank you so much, Sir. I watched a lot of your videos. You have saved my life.

  • @mariospetrou13
    @mariospetrou13 6 днів тому

    Really nice video, my question is, where can I find the data to perform this analysis?

  • @patrickwmckenzie
    @patrickwmckenzie 7 днів тому

    My alpha and beta converge to 0, maximising my LL to ~7600, using very similar data to yours. What could be going wrong?

  • @jacksmith-ih9rm
    @jacksmith-ih9rm 7 днів тому

    Great!!!

  • @Dergicetea
    @Dergicetea 8 днів тому

    Sir, I've got a question. Excellent video! 🎉 I will take my time to research more about this method. I was just wondering if you have a source of the complete formula for Standard Deviation. I believe there is no software that makes the whole algorithm directly.

  • @ivankalarasati
    @ivankalarasati 13 днів тому

    hi can you help me to do in my data?

  • @RismaWati-my7ip
    @RismaWati-my7ip 15 днів тому

    Plisttt cara meningkatkan r square dalam eviews gimana caranya??

  • @dekuhero4147
    @dekuhero4147 15 днів тому

    Mine is data panel, how I do itt

  • @diegodalessandro7873
    @diegodalessandro7873 16 днів тому

    would you follow the same procedure with daily prices/returns?

  • @alem_mood
    @alem_mood 17 днів тому

    Great video, what about a video on 6 (or 4) Factor Model? Fama-French 5 Factor (or 3) + Momentum (excluded by Fama & French due to difficulties in explainability but evaluated by Carhart in the 4 Factor Model)?

  • @filipborzecki7426
    @filipborzecki7426 17 днів тому

    Thank you for the video! Quick question: if I want to use German-Klass to estimate daily volatility (as an alternative of a sum of squared intraday returns), do I just omit the summation and 1/n division?

  • @cecex4545
    @cecex4545 20 днів тому

    I'm getting errors for the lower half of the data for some reason, why might this be?

  • @HongNgocHo-if3zb
    @HongNgocHo-if3zb 21 день тому

    How I calculate AR, CAR if I only have 1 firm but there are ten event days

  • @user-vn9sj8td6w
    @user-vn9sj8td6w 21 день тому

    On peut avoir cette vidéo en version française svp

  • @rajuchoudhari2409
    @rajuchoudhari2409 23 дні тому

    very nice 😊

  • @xiaobowang-mj2vb
    @xiaobowang-mj2vb 23 дні тому

    hey,thanks for your videos! And I want to ask some questions .I am now using R language to reproduce the prediction effect of the HAR-RV model. I first divided it into a test set and a training set, and then I used the training set to regress it to find its coefficient. Then I want to know, for RVt-1, RVt-5, RVt-22, what should I do if the training set does not meet the number of lagged items. For example, for RVt-22, should the regression data start from RV, RVt-1, RVt-5 corresponding to the first item of RVt-22?

  • @jul8803
    @jul8803 23 дні тому

    Criminally underrated channel.

  • @adibyaserahmed9684
    @adibyaserahmed9684 24 дні тому

    Hi great content but would appreciate if you can talk a bit slower :)

  • @lindsayr04
    @lindsayr04 25 днів тому

    Do you help with class projects?

  • @littlebigfis
    @littlebigfis Місяць тому

    Great Content! Video request: Factor decomposition of an example CTA hedge funds return, regressed against factor indexes like volatility, carry, mean reversion/value, time series momentum

  • @joeaoun6321
    @joeaoun6321 Місяць тому

    Another great video. Really appreciate your content and efforts to make the calculations understandable. Also appreciate the context and qualitative considerations that are discussed after doing all the math. Thanks for all you do.

  • @tmac3775
    @tmac3775 Місяць тому

    Thank you!

  • @NowhereMan5691
    @NowhereMan5691 Місяць тому

    beautiful content

  • @debzeb6899
    @debzeb6899 Місяць тому

    Thanks, really useful.

  • @abangfarhan1
    @abangfarhan1 Місяць тому

    Hi, thank you for the clear explanation. Does anyone know how to run a monte carlo simulation by assuming that the stock return follows the t-distribution? By searching on the internet I found that in Excel the formula to generate the random numbers is: =mean + stdev * T.INV(RAND(),df) where the mean, stdev, and df are determined from historical data. However, from your example, you mentioned that the standard deviation need to be scaled by sqrt((df-2)/df). Do I also need to scale it here to generate the random numbers? It'd be nice if you can point me to relevant books/articles on this topic. Thank you.

  • @alpserbetli6219
    @alpserbetli6219 Місяць тому

    why did u multiply insensitive assetes and liabilities with duration generated via whole asset and liabilities ? isnt that true that only sensitive assets may change if IR changes.

  • @jcalfa9365
    @jcalfa9365 Місяць тому

    Придётся смотреть все Ваши видео ) спасибо

  • @vd4079
    @vd4079 Місяць тому

    When do I use log returns and when do I use simple returns for the calculation?

  • @ilijagjorgjevic9354
    @ilijagjorgjevic9354 Місяць тому

    How about using VOM 24:57 (variable order Markov chain). Do you find them more suitable for boosting of prediction accuracy?

  • @savusilviu
    @savusilviu Місяць тому

    Hi Sava, Any chance that you could implement Hierarchical Risk Parity in excel? I know, stupid question 🤕

  • @brianjennings6208
    @brianjennings6208 Місяць тому

    You have a real knack for teaching. This video is superb. Thank you.

  • @ajaykumar-gz4gt
    @ajaykumar-gz4gt Місяць тому

    Thank you for your kind words regarding the research paper. I would be happy to clarify the software utilized for data analysis. The analyses and graphical representations were conducted using Excel?

  • @mohamadyaserarafat589
    @mohamadyaserarafat589 Місяць тому

    Wondering if it applicable for supervisory test for central counterparties

  • @sziaNikkk
    @sziaNikkk Місяць тому

    Thanks, you saved me from failing my exam ❤

  • @panagiotadeli2811
    @panagiotadeli2811 Місяць тому

    Thank you for the great video, i have a question as well. When they say that the estimation window and the event window needs to not overlap, did we just achieve this by not taking the same date as the date that the anticipation window starts? or we need to leave more days in bettween?

  • @majedalzaylaee1013
    @majedalzaylaee1013 Місяць тому

    This great explanation about CSAD and herding behavior…. I would to contact you for my study …. Thanks

  • @mufaroruzive2487
    @mufaroruzive2487 Місяць тому

    Hi. Is there any way to forecast the taleb ratio?

  • @WowChrismonkey99
    @WowChrismonkey99 Місяць тому

    Awesome video. How would you model correlated electricity and fuel prices in this way? Which distribution would you assume? Also how do you accurately estimate the correlation of time series data? Thanks! I’ve already learnt a ton, you’re a star

  • @ZhaoLance
    @ZhaoLance Місяць тому

    Srsly the best video out there that explains the linest function.

  • @didiercrozet
    @didiercrozet Місяць тому

    French Guy. Beautiful job. Thanks a lot for your contributions and the help you provide for others. Sorry for my English I'm not so fluent !!!!

  • @BaccaratDegen
    @BaccaratDegen Місяць тому

    Looking back hind sight, many of the companies that were undervalued stayed undervalued because they were poorly managed companies. There is no perfect formula for valuation, every valuation is subjective. Stock prices are just a fundamental mechanism of human behaviors and corp governance. I would never rely on excel spread sheets to make my investment decisions.

  • @datacool
    @datacool Місяць тому

    Excuse me, i want to ask sir. Why there is a different formula in objective function to minimize SSE, between sklearn library and this video. What is the different ?? Thx

  • @SamehSenosi
    @SamehSenosi Місяць тому

    Thank you so much for sharing valuable information

  • @nityodaytekchandani701
    @nityodaytekchandani701 Місяць тому

    Thank you!

  • @hlingnau8057
    @hlingnau8057 Місяць тому

    Thanks for this very helpful video. I am still struggling a bit with the results of my time series though... . DurbinWatson is 2,108 . BreuschGodfrey show 0,000% as p-value for both F-stat and Chi-sq . BoxPierce and LjungBox show 67,5% and 67,0% as p-values. So yes, I guess that means there is some strong signs for autocorrelation which does not surprise me but I am puzzled about the results of BoxPierce and LjungBox being rather elevated? Heinrich

  • @maltheskaklund3668
    @maltheskaklund3668 Місяць тому

    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..?