Nelson-Siegel-Svensson model explained: modelling yield curves (Excel)

Поделиться
HTML-код
  • Опубликовано: 19 окт 2024

Комментарии • 20

  • @NEDLeducation
    @NEDLeducation  Год назад +1

    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

  • @hamayoonshah1990
    @hamayoonshah1990 Год назад

    You made me publish an article in A category journal.... Thanks bro

  • @theunnamedman
    @theunnamedman Год назад +2

    How do you estimate lambda and mu? You kinda pick ir arbitrarily in the video. Is there a way to estimate the parameter from the data?
    Great video!

    • @NEDLeducation
      @NEDLeducation  Год назад +1

      Hi, and thanks for the great question! Yes, you can allow them to vary alongside other parameters so minimise mispricing. It is just more conventional to pick them at the start to prevent overfitting and specify where you want the yield curve to "hump".

  • @felipelopesdecamargo6381
    @felipelopesdecamargo6381 Год назад +1

    Awesome video, thank you. Can you also specify solver to fit the observed market yields instead of implied prices?

    • @NEDLeducation
      @NEDLeducation  Год назад +1

      Hi Felipe, and thanks for the question! Yes, this can also be done, and then you will simply minimize squared deviations from observed yields (this would even be computationally simpler). It is just the application with prices has been more conventional over the years.

  • @umalikarustomo1693
    @umalikarustomo1693 Год назад +1

    Hi, really enjoyed ur videos, although just wanted to ask. is this model the most frequently used for modelling yield curves? and if not, what is? thanks!

    • @NEDLeducation
      @NEDLeducation  Год назад

      Hi Umalika, and thanks for the question! Yes, you could say this is the go-to yield curve model.

  • @batumeftun
    @batumeftun Год назад +1

    I constantly repeat that but; if you follow this channel only, you will learn more than top 50 finance master degree program... (if not 10)

    • @NEDLeducation
      @NEDLeducation  Год назад

      Hi Batu, and many thanks for such kind words! Stay tuned for more content!

  • @MikaelLarsson-p8g
    @MikaelLarsson-p8g 11 месяцев назад

    you are f*n amazing! I cant find the spreadsheet for this model. i only find the regular nelson-siegel.

  • @lklkos8928
    @lklkos8928 Год назад

    Master!! Thanks

  • @neeleshl869
    @neeleshl869 Год назад

    Hi i am using this model with the Uks current yield rates and prices, but when i compare the yield rates i get using the model, they are not the same as the real world ones. Is that ok? Also im confused on what values to use for lambda and mu.

  • @user-wr4yl7tx3w
    @user-wr4yl7tx3w Год назад +1

    How often in practice do you update the parameters to new data?

    • @wajihchtiba34
      @wajihchtiba34 Год назад

      frequently

    • @NEDLeducation
      @NEDLeducation  Год назад +1

      Hi, and thanks for the question! As frequently as needed - you can even do this real-time as bond prices evolve.

  • @user-wr4yl7tx3w
    @user-wr4yl7tx3w Год назад

    Can we say that the short rate is the same as the zero coupon rate?

  • @rizkykhaerunnisa3727
    @rizkykhaerunnisa3727 7 месяцев назад

    Hello Sir, why in the 10 year icoupon 4,250?

  • @user-wr4yl7tx3w
    @user-wr4yl7tx3w Год назад

    I guess those spot rates are basically zero rates since you are using them to discount the cash flow.

    • @wajihchtiba34
      @wajihchtiba34 Год назад

      by definition a spot rate is the rate of a zero coupon bond ZCB