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 but more importantly be part of the transformative journey.

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.

Self-Paced 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 starts after completion of 30-40% of the curriculum and includes CV Prep, Interview Guidance, Referral to 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

What You'll Get

Comprehensive resources and materials included in your program

Primers

Foundational materials to get you started

Concept Lectures

Comprehensive video lectures covering all topics

Excel Models

Ready-to-use spreadsheet models for practical application

Python Codes

Complete Python implementations for all concepts

One Note Files

Organized notes and documentation

Reading Material

Curated reading resources for deeper understanding

Assignments

Practical exercises to reinforce learning

Quizzes

Regular assessments to test your knowledge

D Forum

Discussion forum for peer learning and support

Interested? Let's Talk!

Fill this form to receive the brochure.

Phone
How You'll Learn

Classes Details

Flexible learning format with self-paced sessions, live workshops, and practical case studies

Self Paced Sessions

Core conceptual classes available as recordings

Live Workshops

Integrated Market Risk case study in a workshop setting spanning across 2 days for 10 hours

Weekend Live Classes

Regular live classes on topics not covered in self paced sessions

Market Abhyaas

Case study to understand how three lines of defence aka model development, model validation, model audit communicate with each other

Certification Process

Assessment & Certification Process

Complete two comprehensive modules to earn your Market Risk Modeling Certificate

1

Application Module (AM)

Day 1 - Practical Excel-based Assessment

Excel sheets with unfilled templates and write-up containing directions

Open book exam - refer to existing excels or notes

Submission deadline: Day 1 midnight 11:59 PM IST to your trainer by email

Knowledge of Credit Risk concepts50%
Application of Credit Risk concepts30%
Presentation20%
2

Conceptual Module (CM)

Day 2 - MCQ Test

50 questions with 3 options each, 1 correct answer

No negative marking

Open book exam - 3 hours duration

Total 50 marks (1 mark per question)

Submission deadline: 1:30 PM to your trainer by email

Application Module (AM)

Day 1 - Practical Excel-based Assessment

Conceptual Module (CM)

Day 2 - MCQ Test

Certificate

Upon Completion

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

August 12, 2025

Date Issued

SAMPLE

Meet Your Mentors

Satyapriya Ojha

Satyapriya Ojha

FRM, CQF (Distinction), IIT Kharagpur, Market Risk Upskilling Expert

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 Inn and has an academic background from the Indian Institute of Technology (IIT) Roorkee and Tulane University, USA, with over 150 research citations. He has extensive experience in management, business, research, and consulting, with a career spanning India, the USA, and Europe.He has extensive experience in management, business, research, and consulting, with a career spanning India, the USA, and Europe.He is passionate about teamwork and empowering individuals to maximize their talents, drive growth, and foster innovation at Risk Inn.

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

What Our Students Say

Real success stories from professionals who transformed their careers through our program

ADITYA BHAT

ADITYA BHAT

100% Salary Hike

Hey everyone! I'm incredibly excited to share some fantastic news with all of you. I've just received an offer for a Model Monitoring role at Standard Chartered, and the salary package is almost a 100% hike from my current position at HSBC! The transformation I've undergone in the last 7 months since joining the CRM is truly remarkable. I'm now so much more confident in my knowledge and skills, all thanks to the Peaks2tails team and Karan Sir for simplifying the complexity in the field of modeling. Believe it or not, I feel like I cleared the interview based on the most basic concepts taught in the course. It's like I only needed to understand the first 1 or 2 classes of each module to land this incredible opportunity! • If any of you are curious about my interview experiences after being part of the P2T CRM community, please don't hesitate to reach out. I'd be more than happy to share my insights and help you all grow in your careers as well.

More from Risk Inn

⁠⁠Comprehensive Programs crafted by Top Rated Experts ensuring Industry relevant mindset and skill development in Finance and Risk.