Quantitative finance collector
C++ Matlab VBA/Excel Java Mathematica R/Splus Net Code Site Other
Feb 25

VaR Backtesting

Posted by abiao at 08:49 | Code » Other | Comments(20) | Reads(31982)
A follow-up of my previous post Value at Risk xls, I was asked why not & how to add a VaR backtesting module in that excel file, well, it is straightforward in principle to do that but since we have to calculate daily VaR for multiple periods in order to do backtesting, I simply didn't add that in an excel for speed reason.

The Backtesting framework developed by the Basel committee is the main methodology to judge the performance of VaR model, it typically consists of a periodic comparison of the portfolio’s or asset’s daily VaR values with the subsequent daily profit and loss (P&L). Obviously, the ideal model should generate the times of VaR exceeding P&L equal to (1-alpha) multiplied by time periods for backtesting. For a single equity case it is obvious what we need to do is comparing daily VaR results with daily return; but for a portfolio we have to be careful with the trading positions.

Basel committee (1996) introduces a three-zone approach, where the green zone means the possibility of erroneously accepting an inaccurate model is low; yellow zone is risk manager should be careful to check the model before take action; red zone means the probability of erroneously rejecting an accurate model is remote. For example, the backtesting three zones boundaries for a sample of 250 observations, source from Basel committee, 1996 look like
var three zone table
Backtesting results can therefore be judged by counting the number of exceptions and seeing intuitively which colour zone it falls into.

Alternatively you can rely on some statistical testing, for instance, the exception testing by Kupiec (1995).

Your final VaR backtesting results will look similar to
var backtesting graph
var backtesting table
by which you are able to tell the performance of your VaR model.

certainly there isn't only one way for VaR backtesting, the above-mentioned one is an example.

Heyaaa ,,good point.. if feeling confused forthe same point.. i ended up with one number of VaR... and then stuck with the idea thati need to get the VaR for each day of my whole observation sample ... i understood that i need to predict the VaRs..... i

So,is it right to get the predicted VaR trough computing the standard deviation of each day and then multiply it with the confidence level and the portfolio value ?

if you assume the returns follow normal distribution, and you calculate VaR via variance-covariance method, Yes, that's the way to estimate VaR.
Hello abiao, i read your words that "so each day you should have a VaR value "...i would like to know how to compute these days VaR. ( really, i'd like to know how to calculate those and plot as the red and green lines in the graph.)
One sample to calculate Value at risk is at http://www.mathfinance.cn/value-at-risk/
Fairly great as well as correct, things are all in the perfect place.
the battle cats hack
Pages: 2/2 First page Previous page 1 2 Final page
Add a comment
Enable HTML
Enable UBB
Enable Emots
Nickname   Password   Optional
Site URI   Email   [Register]