Intro to Quantitative Financial Modeling in Excel

Excel is an excellent tool for understanding the intricacies involved in financial modeling. The aim in each section of the course is to explain the implementation of the models using Excel.

Some models discussed in this course:

• Black-Scholes-Merton (BSM) Option Pricing Model

• Binomial Option Pricing Model

• Portfolio Optimization

• Option Implied Volatility

• Value-at-Risk (VaR) and Conditional Value-at-Risk (CVar): Historical, Gaussian and Cornish-Fisher (NEW! Added on 4th June 2020)

• Optimization of VaR and Trading Liquidity Risk: Unwinding a Position Optimally (NEW! Added on 4th June 2020)

To benefit from this course, it is advised that you try building the models as you go through the videos.

As I am nearing to the 2 hour limit for a free course, I will no longer be adding new videos to this course. If I want to add more videos, then I will have to convert it to a paid-course, which I am not planning to do anytime soon.