Calculating Value at Risk (VaR) – Topic Guide

One of the most pertinent questions in risk management has been: “How much do you stand to lose, over a certain period and with a certain probability? What is that number and what does it stand for? Buy Now

The number being referred to here is Value at Risk or VaR for short: A worst case loss with limits on time period and probability. VaR uses historical market trends and volatilities to estimate the likelihood that a given portfolio’s losses will exceed a certain amount.


Topics covered

    1. A review of Value at Risk (VaR) calculation methods including;
      • Variance-covariance (VCV) approach
      • Historical simulation approach
      • Monte Carlo simulation approach
    2. Creation of a simple portfolio and step-by-step calculation of its VaR under the first two approaches mentioned above.
    3. VaR case-study demonstrating the application of VaR in a non-traditional, market risk oriented application, in particular the use of the value at risk (VaR) measure as a tool to forecast and predict the margin shortfall problem within the oil, gas and petrochemical industry.  
    4. VaR issues and related caveats and qualifications pertaining to the use of this measure.
    5. Adjusting market risk VaR estimates for market liquidity risk


EXCEL files

The pre-packaged deal also includes the following 3 EXCEL files:

    1. Calculating VaR – EXCEL Example. This is the supporting excel file to the PDF note with the same name, i.e. Calculating VaR.
    2. Portfolio VaR – EXCEL Example. This is the detailed VaR worksheet for a portfolio comprising of commodities and currencies. This course complements our video course on Calculating VaR (not included in this package). It includes:
      • Calculation of value at risk under the VCV and historical simulation approaches.
      • Calculation of 10- day Trailing volatility
      • Calculation of daily, holding period and annualized volatility
      • Demonstration of how the in-built Histogram (Data Analysis) function of EXCEL id used to determine the worst case loss for the historical simulation approach.
      • Comparison of results from various approaches
      • Calculations of Portfolio VaR using the Variance Covariance Matrix multiplication approach as well as the weighted average portfolio return approach
      • Differentiation between Price and Rate Value; Delta Neutral approximation and full valuation approach
    3. VaR with liquidity premium – EXCEL Example. This is the supporting worksheet to the PDF “Adjusting market risk VaR estimates for market liquidity risk” included in the package. The file illustrates the calculation of the market risk measure for Rate VaR, Delta-normal approximation to Price VaR and Price VaR for a portfolio of US Treasury instruments. Then assuming a decline in market liquidity an adjusted VaR estimate is determined including an estimate of the loss amount attributed to market liquidity risk.

back to top


Random Testimonial

  • ~ Corporate Training Testimonials

    "A most amazing training - hands down the best, most useful, and most relevant I had during my tenure. Simply put, I loved it and will continue to build on the models. 

    Financial Modeling Course Participant
    FGB Training Academy, 
    First Gulf Bank, Abu Dhabi, UAE


    I have attended a number of training courses conducted by Alchemy technologies. Broadly, the areas covered have been Financial Risk Management aspects, Basel II implementation in Pakistan, as well as product knowledge for relatively new products in the our market for instance Financial Derivatives. As trainers, Mr. Jawwad Farid and his team bring in a wealth of conceptual knowledge entwined with their own professional experiences, adapting and honing it to our local market needs. The training courses are very informative and are delivered in a witty and energetic manner. The learning needs of the participants are kept in focus, and they are kept involved by interactive discussions and queries. Personally, I have always left these sessions with a much better understanding and grasp over the subjects delivered, which has helped me professionally.”

    Senior Manager & Team Leader
    Treasury Middle Office
    Habib Bank Limited


    “Jawwad Farid has admirably led the training piece on the Treasury side covering Treasury risk, Treausury products, Derivatives (basic & Advanced), Fixed income securities (Basic & Advanced) and ALM training modules. Jawwad in our opinion is an “Outstanding Senior Trainer” who has deep subject matter knowledge and an uncanny ability to keep the participants engaged in the training process. So far our clients have expressed maximum level of satisfaction in Jawwad’s capability to deliver high value training programs, that have tangibly enhanced their staff’s skill sets.

    Based on our direct more than satisfactory experience, Jawwad’s otherwise exceptional track record on the training side with over 90 technical skill building courses in South Asia, Middle Eastern and Far Easterm markets, we have no hesitation in strongly recommending Jawwad Farid for the training that for participants based out of Malaysia or the adjoining Far Eastern Markets.”

    Mohammad Nasr Ullah
    Principal Consultant
    Consultnomics, FZE


    I have loved each and every workshop from Alchemy. The workshops are extremely helpful in removing queries about Derivatives Pricing, Basel & Regulatory issues. I feel attending the workshops have added value to my knowledge and expertise. Moreover, the instructor is extremely knowledgeable on the subject area and ensures that each candidate returns with similar knowledge and expertise.

    Senior Vice President
    Allied Bank"

  • Read more testimonials »