Risk inn Logo
Home/Courses/Market Risk Modeling Certificate (Excel and Python)

Market Risk Modeling Certificate (Excel and Python)

Trainer: IIT & IIM Graduate, FRM Charterholder, CQF Distinction. Highly skilled Capital Markets and Risk professional with 12+ years of experience in Regulatory Capital, Valuation and Analytics.

MARKET RISKCOUNTERPARTY CREDIT RISKFRTBSA-CCRXVASIMMEXCELPYTHONDERIVATIVES VALUATION
Certificate on successful completion of assignments and exams

Program Overview

Market Risk and Counterparty Credit risk course is designed to empower you with tools and fundamentals to be able to value derivatives and model risk independently. The course covers FRTB market risk framework and Counterparty Credit Risk calculations in great detail with theory, analytical derivations, spreadsheet and python models for every single concept. Get hands-on modelling experience on some of the key areas such as FRTB-SA, FRTB-IMA, SA-CCR, IMM, xVA, SIMM etc. which are in huge demand today. Although the core focus of this course is to train you on the latest regulatory capital framework, there is a constant emphasis on problem solving and independent thinking to tackle modelling problems throughout the course. Join this course to take advantage of over 140 hours of lecture and get access to a rich repository of Excel and Python models.

Key Highlights

Comprehensive Coverage

Over 140 hours of lectures on market risk, counterparty credit risk, FRTB, SA-CCR, xVA, SIMM, and derivative valuation.

Hands-On Modelling

Practical experience with Excel and Python models for every concept.

Regulatory Focus

In-depth training on the latest regulatory capital frameworks like FRTB-SA, FRTB-IMA.

Flexible Learning

Self-paced sessions with core conceptual classes available as recordings, complemented by live workshops and regular weekend live classes.

Practical Case Studies

Includes 'Market Abhyaas' case study to understand the three lines of defence in risk management.

Placement Support

Placement assistance including customized CV preparation, interview guidance, and tie-ups with financial institutions.

Deliverables

Access to Primers, Concept Lectures, Excel Models, Python Codes, One Note Files, Reading Material, Assignments, Quizzes, and a D Forum.

Who Should Explore This Program?

  • Professionals aiming to specialize in market risk and counterparty credit risk.
  • Individuals seeking to understand and model regulatory capital frameworks like FRTB and SA-CCR.
  • Analysts and quants looking for hands-on experience in derivative valuation and risk modeling using Excel and Python.
  • Finance professionals targeting roles in investment banks, consulting firms, and rating agencies.

Detailed Curriculum

Python Basic Libraries

  • Data types, CRUD operations
  • If Else Statements & Loops
  • Numpy, Pandas, Matplotlib
  • Seaborn
  • Cufflinks

Python for Statistics

  • Probability and statistics
  • Multiple Regression
  • Time Series Analysis
  • Monte Carlo for Pricing
  • Monte Carlo for Risk Management

Market Risk Foundations

  • Overview of Regulatory Capital
  • Market Risk Terminology
  • Expectation & Variance Algebra - Theory & Worked Out Examples
  • Taylor Series & Sensitivities - Theory & Worked Out Examples

FRTB - standardized approach

  • Delta, Vega & Curvature Risk Charge for GIRR, CSR, EQ, FX, Commodity
  • Jump-to-Default Risk Charge (JTD)
  • Delta & Curvature Risk charge for an Equity Portfolio (Spot, Forwards, Options)
  • Vega Risk charge for an IR portfolio (Caps, Swaptions)
  • Vega Risk charge of Equity Option portfolio
  • Delta & Curvature Risk charge for an GIRR & CSR for an IR Portfolio (Bonds, Caps)
  • Delta Risk charge for FX Portfolio (Bonds & Equity Instruments)
  • JTD capital charge (Equity Forwards, Equity Options, Bonds, Callable Bonds, CDS)

FRTB - simplified standardized approach

  • Maturity Ladder Framework (Vertical & Horizontal dis-allowance)
  • Treatment of Options (delta, gamma approach)
  • Maturity Ladder Method for an IR portfolio (Bond, IRS, Future)
  • Delta, Vega, Gamma Capital charge for a call option on Bond

FRTB - Advanced Approach (IMA)

  • Properties of Risk Measure
  • Coherent vs Convex
  • VaR vs ES
  • ES aggregation framework for IMCC
  • Calibration to stress period
  • NMRF and stressed capital
  • Default Risk Capital
  • PLAT & Backtesting requirements with derivation
  • IMCC calculation of an Equity Portfolio
  • PLAT & Backtesting of Equity Option portfolio

Stochastic Process

  • Brownian Motion
  • Ito Lemma
  • Dynamics of spot and forward price
  • Monte Carlo & Terminal Density

Equity Derivatives

  • Forwards & Options & Black Scholes PDE
  • Option Greeks
  • Volatility Surface & Calibration
  • Local Volatility Models (Dupire)
  • Stochastic volatility models (SABR, Heston)

FX Derivatives

  • Forwards, Cross Currency Swaps
  • FX Option

Interest Rate Derivatives

  • Spot rate, Forward rate, swap rate
  • Zero Coupon bond pricing
  • FRA, IRS, Floaters pricing & duration
  • Caps, Floors, Swaptions (Black-76)
  • Equilibrium Term Structure Models (Vasicek, CIR)
  • No Arbitrage Term Structure Models

Advanced Sensitivity Computation

  • Pricing & Sensitivity by Finite Difference
  • Sensitivity by Monte Carlo (Full valuation vs pathwise sensitivity)
  • Adjoint automatic differentiation (AAD)
  • Custom Library for Sensitivity Computation for Equity, IR, and FX portfolios

Counterparty Credit Risk

  • Exposure, Netting, Margin & Collateral
  • Quantifying Exposure (EE, EPE, PFE, EEPE)
  • Exposure profiles under Netting, Margin, Collateral & Wrong Way Risk
  • SA-CCR Framework
  • Internal Models Method Framework
  • ISDA SIMM Framework
  • Uncleared Margin Rules
  • EAD modeling under SA-CCR for a sample portfolio
  • Initial Margin Calculations (ISDA, SIMM methodology)

XVA Toolbox

  • CVA, DVA, BCVA
  • FVA, MVA, colVA, KVA
  • xVA calculation for forwards, swaps & options

Program Schedule & Logistics

Self Paced Sessions

Core conceptual classes available as recordings

Live Workshops

Integrated Market Risk case study (2 days, 10 hours).

Weekend Live classes

Regular live classes on topics not covered in self-paced sessions.

Market Abhyaas

Case study on the three lines of defence.

Interested? Let's Talk!

Fill this form to receive the brochure.

Know Your Timeline

Your Journey in Market Risk & Counterparty Credit Risk

A Step-by-Step Path to Mastering Valuation, Risk Modelling, and Regulatory Frameworks.

Build Foundational Knowledge (Primer)

Master Python basics, essential libraries (Numpy, Pandas, Matplotlib), statistical concepts, and market risk fundamentals.

Understand Market Risk Regulatory Capital (FRTB)

Deep dive into FRTB standardized approaches (full and simplified), including Delta, Vega, Curvature, and JTD risk charges.

Explore FRTB Model Frameworks

Learn FRTB Advanced Approach (IMA), stochastic processes, valuation of Equity, FX, and Interest Rate Derivatives, and advanced sensitivity computations.

Master Counterparty Credit Risk (CCR) & XVA

Cover CCR concepts (Exposure, Netting, SA-CCR, IMM, SIMM), and the XVA Toolbox (CVA, DVA, FVA, MVA, etc.). Complete assignments and exams for certification.

Industry Recognized Certification

Risk Inn Logo

Certificate of Completion

This certificate is proudly presented to

Ayush Sharma

For successfully completing the courseMarket Risk Modeling Certificate (Excel and Python)by Risk Inn.

CA Yash Jain

Chief Faculty

June 29, 2025

Date Issued

SAMPLE

Meet Your Mentors

Satyapriya Ojha

Satyapriya Ojha

Mentor

Satyapriya Ojha is a highly skilled Capital Markets and Risk professional with 12+ years of experience in Regulatory Capital, Valuation and Analytics

He is an IIT & IIM graduate and holds FRM charter (top quartile in all subjects of part I & part II) and a distinction from CQF institute.

He is an expert in quantitative models used in valuation and risk management.

He has worked as a consultant in several regulatory projects for some of the top banks in the US in BASEL III and FRTB space.

Currently, he serves as a product owner for a top wealth management firm engaged in quantitative portfolio management for institutional clients.

The future of risk management lies in the intelligent application of data.
Ripul Dutt

Ripul Dutt

Founder & CEO, IIT, Tulane, USA

Ripul is the Founder of Risk Innand have an Academic Background from Indian Institute of Technology (IIT) Roorkee and Tulane University, USA, with over 150 research citations.

Extensive experience in Management, Business, Research, Consulting, with a career across India, the USA, and Europe.

Passionate about Teamwork and Empowering individuals to Maximize Talents, Driving Growth and Innovation at Risk Inn.

The future of risk management lies in the intelligent application of data.