Skip to content
Free courseIntermediate

Value at Risk (VaR)

Measure portfolio risk with historical, parametric and Monte Carlo VaR in Excel and Python, then examine tail assumptions, backtesting and funding resilience.

  • 33lessons
  • 8modules
  • 15videos
  • 8quizzes

Freeself-paced · certificate included

A free account saves your progress and quiz scores.

What you'll learn

  • Understand what Value at Risk measures and how to interpret VaR results for portfolio risk management
  • Calculate VaR using the historical, parametric, and Monte Carlo simulation methods in Excel
  • Evaluate portfolio tail risk using Expected Shortfall (Conditional Value at Risk)
  • Implement all three VaR methods in Python using real market data
  • Challenge distribution assumptions, interpret fat-tail evidence, and assess VaR backtesting and funding-liquidity risk.

What's inside

  • 15 video lessons

    Short explainers and step-by-step builds you can pause and replay.

  • 8 quizzes
  • 10 written guides
  • Tools you'll use
    • Excel
    • Python
  • Earn a certificate

    Finish every lesson to unlock a shareable certificate with its own verification link.

Curriculum

33 lessons · 8 modules · About 5 hours 45 minutes

Course map

  1. 01Introduction to Value at Risk3 lessons · 27 min
  2. 02The Historical Method4 lessons · 32 min
  3. 03The Parametric Method4 lessons · 41 min
  4. 04The Monte Carlo Method4 lessons · 43 min
  5. 05Expected Shortfall & CVaR3 lessons · 32 min
  6. 06VaR in Python7 lessons · 1.5 h
  7. 07Distribution Assumptions and Fat Tails5 lessons · 42 min
  8. 08Model Limits in Practice3 lessons · 40 min

  1. Module 1: Introduction to Value at Risk

    3 lessons27 min
    1. Video: Value at Risk Explained in 5 Minutes 5 min
    2. Article: Value at Risk: Complete Guide 12 min
    3. Quiz: Module 1 Quiz: Introduction to Value at Risk 10 min
  2. Module 2: The Historical Method

    4 lessons32 min
    1. Video: VaR: Historical Method Explained 2 min
    2. Video: Historical Method: Value at Risk (VaR) In Excel 5 min
    3. Article: VaR Historical Method: Complete Guide 15 min
    4. Quiz: Module 2 Quiz: The Historical Method 10 min
  3. Module 3: The Parametric Method

    4 lessons41 min
    1. Video: VaR: Parametric Method Explained 4 min
    2. Video: Parametric Method: Value at Risk (VaR) In Excel 7 min
    3. Article: VaR Parametric Method: Complete Guide 20 min
    4. Quiz: Module 3 Quiz: The Parametric Method 10 min
  4. Module 4: The Monte Carlo Method

    4 lessons43 min
    1. Video: VaR: Monte Carlo Method Explained 3 min
    2. Video: Monte Carlo Method: Value at Risk (VaR) In Excel 10 min
    3. Article: VaR Monte Carlo Method: Complete Guide 20 min
    4. Quiz: Module 4 Quiz: The Monte Carlo Method 10 min
  5. Module 5: Expected Shortfall & CVaR

    3 lessons32 min
    1. Video: Expected Shortfall & Conditional Value at Risk (CVaR) Explained 12 min
    2. Article: Expected Shortfall: Complete Guide 10 min
    3. Quiz: Module 5 Quiz: Expected Shortfall & CVaR 10 min
  6. Module 6: VaR in Python

    7 lessons1.5 h
    1. Video: Historical VaR in Python (Video) 13 min
    2. Article: Historical VaR in Python: Code Walkthrough 10 min
    3. Video: Parametric VaR in Python (Video) 15 min
    4. Article: Parametric VaR in Python: Code Walkthrough 10 min
    5. Video: Monte Carlo VaR in Python (Video) 19 min
    6. Article: Monte Carlo VaR in Python: Code Walkthrough 10 min
    7. Quiz: Module 6 Quiz: VaR in Python 10 min
  7. Module 7: Distribution Assumptions and Fat Tails

    5 lessons42 min
    1. Video: Standard Deviation in Finance: Volatility Explained 5 min
    2. Video: Normal Distribution in Finance Explained 6 min
    3. Video: Skewness and Kurtosis: A Stock-Market Example 6 min
    4. Article: Practice: Testing the Assumptions Behind Normal VaR 15 min
    5. Quiz: Module 7 Quiz: Distribution Assumptions and Fat Tails 10 min
  8. Module 8: Model Limits in Practice

    3 lessons40 min
    1. Video: LTCM: A Model-Risk Case Study 10 min
    2. Article: Practice: VaR Validation and Funding Resilience 20 min
    3. Quiz: Module 8 Quiz: Model Limits in Practice 10 min

Who this course is for

  • Investors and analysts learning portfolio risk measurement
  • Finance students comparing VaR methods and model assumptions
  • Learners with introductory Python who want to reproduce risk calculations

Before you start

  • Basic statistics: mean, standard deviation and normal probabilities
  • Comfort with Excel formulas
  • Introductory Python, NumPy and pandas for the Python implementation module
Ryan O'Connell

Your instructor

Ryan O'Connell, CFA, FRM

I went from Fortune 500 quantitative risk analyst to teaching finance to hundreds of thousands of people on YouTube. These courses are the structured version of that teaching: the theory, the formulas, and the Excel and platform work that make them useful.

  • 81.8KYouTube subscribers
  • 6.8MYouTube views
  • 9+years in finance
  • CFA charterholder
  • FRM certified
  • MS Finance, Texas A&M
  • MCIT, University of Pennsylvania
  • CFA Institute
  • University of Pennsylvania
  • Texas A&M University
More about Ryan

Questions

Is this course really free?

Yes. Every lesson, calculator and quiz in this course is free.

Do I need an account?

You can browse the curriculum without one. A free account lets you take the lessons, save your progress and earn the certificate.

What software do I need?

Microsoft Excel (or a compatible spreadsheet) and Python, plus a web browser.

Do I get a certificate?

Yes. Finish every lesson to earn a certificate of completion with its own verification link.

Is this investment advice?

No. The course is educational. It is not a recommendation to buy or sell any security.

What does the estimated course time include?

The estimate combines videos, assigned reading, example review and quizzes. The three method-guide estimates allow roughly 200 words per minute plus three minutes to review an example, rounded up to five minutes. Videos embedded in these readings are optional review; coding and further practice can take longer.

More courses

Keep learning

  • PremiumBeginner to Advanced

    Options Mastery: From Theory to Practice

    Learn how options are priced, how the Greeks move them and how to trade every core strategy, then practice it all in Excel, web calculators and an Interactive Brokers paper-trading account.

    • 118lessons
    • 52video lessons
    • 22calculators
    • 15quizzes

    $149.99one-time payment · lifetime access

  • Free courseBeginner

    Economics for Investors

    Understand growth, inflation, central banks and economic crises. Apply macroeconomic ideas to investment questions with clear examples and free web tools.

    • 64 lessons
    • 9 hours 15 minutes
    • 7 quizzes
    Free Start free course

See all courses

Start Value at Risk (VaR) today

33 lessons · free · certificate included

Freeself-paced · certificate included

FreeSelf-paced

Search
Contact Ryan

Get in touch

Contact Me

Have a question or want to work together? Fill out the form below and we'll get back to you as soon as possible.

Contact Form Demo

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Results appear as you type. Use the arrow keys to move through them.