NEDL
NEDL
  • Видео 313
  • Просмотров 1 632 921
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 270

Видео

Covariance matrix shrinkage: Ledoit and Wolf (2004)
Просмотров 1,7 тыс.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,4 тыс.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,1 тыс.5 месяцев назад
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)
Просмотров 9198 месяцев назад
ARCD model explained: autoregressive conditional density (Excel)
PEG ratio explained: price to earnings growth (Excel)
Просмотров 1,7 тыс.8 месяцев назад
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)
Просмотров 5418 месяцев назад
Leave-two-out jackknife explained: advanced resampling (Excel)
Annuity factors explained (Excel)
Просмотров 6398 месяцев назад
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)
Просмотров 5758 месяцев назад
Payback period and discounted payback period (Excel)
KMV model application: Royal Bank of Scotland (2008)
Просмотров 1,6 тыс.9 месяцев назад
KMV model application: Royal Bank of Scotland (2008)
Joint tests for multiple assumptions: Jarque-Bera NHI test (Excel)
Просмотров 4509 месяцев назад
Joint tests for multiple assumptions: Jarque-Bera NHI test (Excel)
Functional forms in OLS regression (Excel)
Просмотров 9709 месяцев назад
Functional forms in OLS regression (Excel)
Chi-squared goodness-of-fit test explained (Excel)
Просмотров 1 тыс.9 месяцев назад
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,8 тыс.Год назад
Implied volatility approximation: Brenner and Subrahmanyan method
Implied volatility explained: Solver and Newton-Raphson (Excel)
Просмотров 4,6 тыс.Год назад
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,9 тыс.Год назад
Quantile regression in EViews
Binary choice models in EViews
Просмотров 1,8 тыс.Год назад
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

Комментарии

  • @dipanitamajumder5005
    @dipanitamajumder5005 Час назад

    How have you got the graph. Can you please show me the steps of the same

  • @user-nr5vw3vz1y
    @user-nr5vw3vz1y 21 час назад

    Could you please give me some crack link for installing eviews 12??

  • @Paparychter
    @Paparychter День назад

    Fantastic content! Question for you. Since the VaR model measures the potential loss in value over a defined period, which is in this calculations over the span of 1 day, what would be the best way to adjust the defined period? Because the VCV VaR is norm. distributed, could we assume (over a 5 trading day period), that VaR weekly = VaRdaily * SQRT (5) ?

  • @mehmetcaymaz7675
    @mehmetcaymaz7675 2 дня назад

    Pazarlama ve sunmada görsel olarak , çok zayıf çok .... Geliştirilmesi lazım acilen

  • @Apt393
    @Apt393 2 дня назад

    What if, in terms of interpretation, only alpha is statistically significant while theta is not ?

  • @yulinliu850
    @yulinliu850 3 дня назад

    Much appreciated❤

  • @yulinliu850
    @yulinliu850 3 дня назад

    💯❤

  • @DivyanshiDiwa
    @DivyanshiDiwa 5 дней назад

    Sir can you make video on decile size adjusted return, idiosyncratic risk and industry value weighted returns, it will be really helpful.

  • @fagrisolia
    @fagrisolia 6 дней назад

    Thank you ! Your lessons are always great.

  • @oliverwei5959
    @oliverwei5959 7 дней назад

    hey how are you doing this with more than one company - for example with 50 companies?

  • @noahheyn6026
    @noahheyn6026 7 дней назад

    Im trying to apply this to energy markets can anyone suggest additional Videos?

  • @belladelima486
    @belladelima486 8 дней назад

    PLEASE HELP ME, WHY WHEN I CALCULATE CSAD I GOT "VALUE"

  • @siddhantkohli5063
    @siddhantkohli5063 11 дней назад

    Was very confused until I found this gem thank you 💜

  • @prathamarora9181
    @prathamarora9181 13 дней назад

    please share all the excel files in the description

  • @mickeylu4901
    @mickeylu4901 14 дней назад

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

  • @henriqueguerino7108
    @henriqueguerino7108 15 дней назад

    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 15 дней назад

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

  • @mariospetrou13
    @mariospetrou13 16 дней назад

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

  • @patrickwmckenzie
    @patrickwmckenzie 16 дней назад

    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 17 дней назад

    Great!!!

  • @Dergicetea
    @Dergicetea 17 дней назад

    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 23 дня назад

    hi can you help me to do in my data?

  • @RismaWati-my7ip
    @RismaWati-my7ip 24 дня назад

    Plisttt cara meningkatkan r square dalam eviews gimana caranya??

  • @dekuhero4147
    @dekuhero4147 25 дней назад

    Mine is data panel, how I do itt

  • @diegodalessandro7873
    @diegodalessandro7873 25 дней назад

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

  • @alem_mood
    @alem_mood 26 дней назад

    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 26 дней назад

    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 29 дней назад

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

  • @HongNgocHo-if3zb
    @HongNgocHo-if3zb Месяц назад

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

  • @user-vn9sj8td6w
    @user-vn9sj8td6w Месяц назад

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

  • @rajuchoudhari2409
    @rajuchoudhari2409 Месяц назад

    very nice 😊

  • @xiaobowang-mj2vb
    @xiaobowang-mj2vb Месяц назад

    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 Месяц назад

    Criminally underrated channel.

  • @adibyaserahmed9684
    @adibyaserahmed9684 Месяц назад

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

  • @lindsayr04
    @lindsayr04 Месяц назад

    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 ❤