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
Hi, I want to bond valuation using a matrix pricing methodology with real life example. Have you made such videos. It would be a big help for me to get such things.
hi I am trying to calculate the Value cell the same way you do but the part of the SUM(F13/(1+B7)^$A$7:A8) makes an error that shows #VALUE!, can you explain what is the calculation and I will try to make it in a different way, Thank you for the video
is NS supposed to give YTM or Spot rates ? I thought the later. If it is supposed to give spot rates, shouldn't Cell H13 be modified from "B7" to "$B$7:B7" ?
Great video! I have an excel question for you: I have some values in columns A, B and C. I need to sum values in column A if those values are between certain values in columns B and C. Say for example if B1
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
This helps me a lots in understanding and applying the theory! Tons of thanks!!❤
Excellent content. Thank you
Excellent content!
thank you for the explanation, it is much clearer for me now
so so helpful.
Wow, this can be done in excel
Hi, I am wondering if you could do a video on this about the YieldCurve Package on R?
amazing.
Just a suggestion. A cubic spline Excel video
Hi Rafael, and thanks for the suggestion! Definitely not a topic I am a specialist on, will have a further read in my free time :)
Amazing content! Can you also do a video of its extension, the Nelson-Siegel-Svensson model?
Hi, I want to bond valuation using a matrix pricing methodology with real life example. Have you made such videos.
It would be a big help for me to get such things.
Could you please make a Video on how to valuate interest rate options (e.g swaptions) by using e.g Ho-Lee-Model?
hi I am trying to calculate the Value cell the same way you do but the part of the SUM(F13/(1+B7)^$A$7:A8) makes an error that shows #VALUE!, can you explain what is the calculation and I will try to make it in a different way, Thank you for the video
use count() function after the power sign
Amazing. Thanks a lot.
is NS supposed to give YTM or Spot rates ? I thought the later. If it is supposed to give spot rates, shouldn't Cell H13 be modified from "B7" to "$B$7:B7" ?
Please, could explain model BDT in EXCEL implementation ?
Great video! I have an excel question for you: I have some values in columns A, B and C. I need to sum values in column A if those values are between certain values in columns B and C. Say for example if B1
Great! Thank you.
In some of the NSS models we see two lamdas. Why are you using only one