Value at Risk Methodology for Market Risk Measurement Training Course

Course overview

Market-risk teams need a defensible way to translate changing prices, positions, volatilities and correlations into a clear estimate of potential loss. Value at Risk (VaR) remains a core risk measure for trading portfolios, treasury activities and management reporting, but a VaR number is only useful when its assumptions, data treatment, confidence level, holding period and limitations are understood. Professionals who rely on vendor outputs or inherited spreadsheets must be able to challenge the result, explain breaches and distinguish a useful risk signal from a misleading model output.

This course teaches participants to calculate, interpret and validate historical simulation, variance-covariance and Monte Carlo VaR. Participants work through return series, portfolio mapping, volatility and correlation estimation, confidence intervals, time-horizon scaling, percentile loss calculation and aggregation across asset classes. The programme also addresses Expected Shortfall, VaR backtesting, traffic-light tests, stress testing, model risk, FRTB requirements and the governance controls needed for market-risk reporting. Participants learn when each methodology is appropriate, where normality and linearity assumptions fail, and how to communicate limitations to senior decision-makers.

Delivery combines instructor-led explanation with guided Excel and Python exercises using realistic multi-asset trading portfolios. Teams investigate a VaR exception, compare model outputs under different assumptions, and perform a backtesting and stress-testing review. Each participant leaves with a documented VaR analysis pack: a calculation workbook, model-selection rationale, backtesting dashboard, stress-test results and a short market-risk methodology memorandum suitable for adaptation in their own organisation.

The course is designed for professionals moving into market risk, risk reporting, treasury risk or portfolio oversight, as well as experienced analysts who need a stronger technical basis for reviewing VaR models and challenging reported market-risk measures.

Course objectives

By the end of this course, participants will be able to:

• Calculate historical simulation VaR from cleaned portfolio return data at specified confidence levels and holding periods
• Construct variance-covariance VaR using portfolio sensitivities, volatility estimates and correlation matrices
• Run a Monte Carlo VaR simulation and interpret the effect of distributional and pricing assumptions
• Compare VaR outputs from historical, parametric and simulation-based methodologies for the same portfolio
• Perform VaR backtesting using exception counts, Kupiec coverage testing and Basel traffic-light interpretation
• Design stress scenarios and reverse stress tests that address VaR blind spots and tail-risk exposures
• Evaluate Expected Shortfall against VaR for non-normal return distributions and concentrated portfolios
• Produce a documented VaR methodology memorandum with assumptions, limitations, validation evidence and governance actions

Benefits of attending

Target competencies

Who should attend

• Market Risk Analysts — who calculate, report or investigate daily trading-book risk measures
• Risk Managers — who need to select, challenge and govern VaR methodologies across portfolios
• Treasury Risk Professionals — who monitor interest-rate, FX and liquidity-sensitive market exposures
• Portfolio Risk Analysts — who assess risk contributions, concentration and tail loss across investment portfolios
• Financial Controllers — who review risk reports and need to understand the source and reliability of reported measures
• Internal Auditors and Model Risk Specialists — who test market-risk model assumptions, controls and validation evidence

Requirements and prerequisites

Participants should be comfortable with basic financial-market concepts, including bonds, equities, foreign exchange, interest rates, derivatives terminology and long or short positions. They should be able to read a spreadsheet, use formulas such as averages, standard deviations and percentiles, and interpret a simple return series. Familiarity with probability, normal distributions and correlation is helpful but will be refreshed during the course. No prior VaR modelling experience, programming experience or advanced quantitative degree is required. A complete beginner in market risk should expect to spend time reviewing the pre-course glossary and Excel refresher supplied before delivery.

Training methodology

The instructor introduces each VaR method through worked market-risk examples before participants build and test the method themselves. Guided Excel exercises cover return preparation, covariance matrices, percentile calculations and exception reporting; selected Python notebooks demonstrate repeatable simulation and sensitivity testing. Teams analyse a multi-asset portfolio case, compare conflicting VaR estimates and present their model choice to a mock risk committee. Daily review clinics address calculation errors and interpretation questions. On the final day, participants assemble an application plan and a documented VaR analysis pack for a portfolio relevant to their role.

Course outline

Day 1: VaR foundations and market-risk data

• Market risk factors, positions and portfolio loss-and-profit mapping
• VaR purpose, confidence levels, holding periods and reporting conventions
• Simple returns, log returns and profit-and-loss series construction
• Market-data sourcing, missing observations and outlier treatment
• Volatility, covariance and correlation estimation
• Portfolio weights, exposures and delta-based position mapping
• VaR assumptions, limitations and model-risk sources

Workshop: Participants prepare a cleaned multi-asset return dataset and build a portfolio profit-and-loss series in Excel.

Day 2: Historical and parametric VaR

• Historical simulation VaR workflow and empirical loss distributions
• Percentile ranking, interpolation and tail-observation selection
• Variance-covariance VaR under normal-distribution assumptions
• Portfolio volatility calculation using covariance matrices
• Square-root-of-time scaling and its practical limitations
• Component VaR, marginal VaR and risk-contribution analysis
• Comparing historical and parametric VaR outputs

Workshop: Participants calculate one-day and ten-day historical and parametric VaR for the same portfolio and reconcile the difference.

Day 3: Monte Carlo VaR and non-linear portfolios

• Random-number generation and simulated market-factor paths
• Cholesky decomposition for correlated risk-factor simulation
• Monte Carlo VaR estimation and convergence testing
• Distribution choices including normal, t-distribution and empirical sampling
• Full revaluation versus delta-normal approximation
• Options, convexity and non-linear payoff effects on VaR
• Expected Shortfall calculation and tail-loss interpretation

Workshop: Participants run a correlated Monte Carlo simulation for a portfolio containing FX, bonds and options and produce a VaR and Expected Shortfall comparison.

Day 4: Backtesting, stress testing and model validation

• Actual versus hypothetical profit-and-loss for VaR backtesting
• VaR exceptions, hit sequences and exception-rate analysis
• Kupiec proportion-of-failures test and conditional coverage concepts
• Basel traffic-light zones and capital-multiplier implications
• Stress testing versus VaR and scenario severity design
• Historical, hypothetical and reverse stress-testing methods
• Validation documentation, independent review and model-change controls

Workshop: Participants investigate a year of VaR exceptions, apply a traffic-light assessment and write a validation finding with corrective actions.

Day 5: VaR governance, FRTB and workplace application

• FRTB market-risk framework and the move toward Expected Shortfall
• Risk-factor modellability and non-modellable risk-factor treatment
• P&L attribution concepts and model-performance monitoring
• VaR reporting packs for risk committees and senior management
• Limit frameworks, breach escalation and risk appetite linkage
• Methodology documentation, assumptions registers and approval governance
• Selecting a proportionate VaR approach for different portfolio types

Workshop: Participants complete and present a VaR analysis pack containing model choice, results, backtesting evidence, stress tests and an implementation action plan.

Tools & standards covered

Microsoft Excel, Python, J.P. Morgan RiskMetrics, Basel Committee FRTB standard

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions