Appendix 1
Value at Risk Models in the Indian Stock Market   J. R. Varma

The Exponentially Weighted Moving Average Method

    The successful use of value at risk models is critically dependent upon estimates of the volatility of underlying prices. The principal difficulty is that the volatility is not constant over time - if it were, it could be estimated with very high accuracy by using a sufficiently long sample of data. Thus models of time varying volatility become very important. Practitioners have often dealt with time varying parameters by confining attention to the recent past and ignoring observations from the distant past. Econometricians have on the other hand developed sophisticated models of time varying volatility like the GARCH (Generalised Auto-Regressive Conditional Heteroscedasticity) model.

    Straddling the two are the exponentially weighted moving average (EWMA) methods popularised by J. P. Morgan’s RiskMetricsÒ system. EWMA methods can be regarded as a variant of the practitioner’s idea of using only the recent past because the practitioners’ idea is essentially that of a simple moving average where the recent past gets a weight of one and data before that gets a weight of zero. The variation in EWMA is that the observations are given different weights with the most recent data getting the highest weight and the weights declining rapidly as one goes back. Effectively, therefore, EWMA is also based on the recent past, in fact, it is even more responsive than the simple moving average to sudden changes in volatility. EWMA can also be regarded as a special case of GARCH in which the "persistence parameter" is set to unity. This means that unlike GARCH, EWMA does not have a notion of long run volatility at all and is therefore more robust under regime shifts

    EWMA is computationally very simple to implement (even simpler than a simple moving average). The volatility at the end of day t, st is estimated using the previous volatility estimate st-1 (as at the end of day t-1),and the return rt observed in the index during day t:
    (st)2 = l (st-1)2 + (1 - l ) (rt)2

    where l is a parameter which determines how rapidly volatility estimates change.
     

       Empirical Tests on the Indian Stock Market
     
    Whatever intuitive or theoretical merits a value at risk model may have, the ultimate test of its usability is how well it holds up against actual data. For example, tentative results indicate that foreign exchange markets in India are best modelled by processes that allow jumps and that EWMA methods do not perform well in that market at all. Empirical tests of the EWMA model in the Indian stock market are therefore of great importance. The EWMA model was therefore tested using historical data on the Indian stock market indices - the NSE-50 Index (Nifty) and the BSE-30 Index (Sensex).

     Sample Period

    The data period used is from July 1, 1990 to June 30, 1998. The long sample period reflects the view that risk management studies must attempt (wherever possible) to cover at least two full business cycles (which would typically cover more than two interest rate cycles and two stock market cycles). It has been strongly argued on the other hand that studies must exclude the securities scam of 1992 and must preferably confine itself to the period after the introduction of screen based trading (post 1995).
       
    The view taken in this study is that the post 1995 period is essentially half a business cycle though it includes complete interest rate and stock market cycles. The post 1995 period is also an aberration in many ways as during this period there was a high positive autocorrelation in the index which violates weak form efficiency of the market. (High positive autocorrelation is suggestive of an administered market; for example, we see it in a managed exchange rate market). The autocorrelation in the stock market was actually low till about mid 1992 and peaked in 1995-96 when volatility reached very low levels. In mid-1998, the autocorrelation dropped as volatility rose sharply. In short there is distinct cause for worry that markets were artificially smoothed during the 1995-97 periods.
       
    Similarly, this study takes the view that the scam is a period of episodic volatility (event risk) which could quite easily recur. If we disregard issues of morality and legality, the scam was essentially a problem of monetary policy or credit policy. Since both the bull and bear sides of the market financed themselves through the scam in roughly equal measure, the scam was roughly neutral in terms of direct buy or sell pressure on the market. What caused a strong impact on stock prices was the vastly enhanced liquidity in the stock market. The scam was (in its impact on the stock market) essentially equivalent to monetary easing or credit expansion on a large scale. The exposure of the scam was similarly equivalent to dramatic monetary (or credit) tightening. Any sudden and sharp change in the stance of monetary policy can be expected to have an impact on the stock market very similar to the scam and its exposure. A prudent risk management system must be prepared to deal with events of this kind.
       
         Logarithmic Return
    The usual definition of return as the percentage change in price has a very serious problem in that it is not symmetric. For example, if the index rises from 1000 to 2000, the percentage return would be 100%, but if it falls back from 2000 to 1000, the percentage return is not -100% but only -50%. As a result, the percentage return on the negative side cannot be below -100%, while on the positive side, there is no limit on the return. The statistical implication of this is that returns are skewed in the positive direction and the use of the normal distribution becomes inappropriate.
       
    For statistical purposes, therefore, it is convenient to define the return in logarithmic terms as rt = ln(It/It-1) where It is the index at time t. The logarithmic return can also be rewritten as rt = ln(1+Rt) where Rt is the percentage return showing that it is essentially a logarithmic transformation of the usual return. In the reverse direction, the percentage return can be recovered from the logarithmic return by the formula, Rt = exp(rt)-1. Thus after the entire analysis is done in terms of logarithmic return, the results can be restated in terms of percentage returns.
       
    It is worth pointing out that the percentage return and the logarithmic return are very close to each other when the return is small in magnitude. However, when there is a large return (positive or negative) the logarithmic return can be substantially different from the percentage return. For example, in the earlier illustration of the index rising from 1000 to 2000 and then dropping back to 1000, the logarithmic returns would be +69.3% and -69.3% respectively as compared to the percentage returns of +100% and -50% respectively.
          Maximum Likelihood Estimation
    The EWMA method requires the specification of the value of l . One can estimate l itself statistically by the method of maximum likelihood. This process yielded an estimate for l of 0.923 for the Nifty and 0.929 for the Sensex. These values are not statistically significantly different from the value of 0.94 for l used in J. P. Morgan’s RiskMetricsÒ system for daily horizons. (The likelihood ratio test gives chi-squares with 1 df of 1.89 for the Sensex and 4.46 for the Nifty which are not significant at the 1% level even though we have a sample size of over 1750). The analysis was therefore carried out using a l of 0.94 to permit easier comparability and facilitate further extensions to the model.
          Conditional Normality
    It is well known that stock market returns are not normally distributed even if one uses logarithmic returns to induce symmetry. However, the time varying volatility itself is one major cause for non-normality. It is to be expected therefore that the "conditional distribution" of the return given the volatility estimate is approximately normal. In other words, the return on each day divided by the estimated standard deviation for that day should be roughly normally distributed. The results do indicate significant reduction in non normality. The unconditional distribution has an excess kurtosis of 5.42 for Nifty and 4.77 for Sensex while the "conditional distribution" has an excess kurtosis of only 1.75 for Nifty and 1.13 for Sensex. Thus over two-thirds of the excess kurtosis is eliminated by the time varying volatility estimation process.
       
    Nevertheless, the kurtosis (which is a measures the fat tails) is still too large for use of the normal distribution values without modification. For example, the normal distribution would imply applying a value of 2.58 s for a two sided "value at risk" limit of 1%. However, the presence of fat tails even in the conditional stock market returns implies that it is necessary to use a higher value to get the same degree of protection. A common rule of thumb for distributions with a moderate degree of kurtosis is to use a value of 3 s for a 1% tail and this value is used in the rest of this study.
          Margins
    Since the volatility estimates are for the logarithmic return, the ± 3 s limits for a 99% VAR would specify the maximum/minimum limits on the logarithmic returns not the percentage returns. To convert these into percentage margins, the logarithmic returns would have to be converted into percentage price changes by reversing the logarithmic transformation. Therefore the percentage margin on short positions would be equal to 100(exp(3st)-1) and the percentage margin on long positions would be equal to 100(1-exp(-3st)). This implies slightly larger margins on short positions than on long positions, but the difference is not significant except during periods of high volatility where the difference merely reflects the fact that the downside is limited (prices can at most fall to zero) while the upside is unlimited.
          Back Testing Results
    Backtesting this model for the period over a 8 year period showed that the 1% VAR limit was crossed 22 times in the case of Nifty and 23 times in the case of Sensex as against the expected number of 18 violations. The hypothesis that the true probability of a violation is 1% cannot be rejected at even the 5% level of statistical significance though we have a sample size of over 1750. The actual number of violations is therefore well within the allowable limits of sampling error. In the terminology of the Bank for International Settlements ("Supervisory framework for the use of ‘backtesting’ in conjunction with the internal models approach to marker risk capital requirements", Basle Committee on Banking Supervision, January 1996), these numbers are well within the "Green Zone" where the "test results are consistent with an accurate model, and the probability of accepting an inaccurate model is low".

    The market movements, margins and margin shortfalls are shown graphically in Figures 1 and 2. The summary statistics about the actual margins on the sell side are tabulated below while year by year details of the sell side and buy side margins are given in Tables 1 and 2.

       
      Sell Side Margins Nifty Sensex
      Average 5.49% 5.74%
      Maximum 21.73% 21.31%
      Minimum 2.04% 2.21%
      Frequency Distribution
      Below 5% 52.51% 50.45%
      5 to 10% 41.75% 41.99%
      10 to 15% 4.17% 6.08%
      15 to 20% 1.35% 1.31%
      Above 20% 0.23% 0.17%
          A Closer Look at VAR Violations
    Taking a closer look at the actual violations (See Figures 3 and 4), it is seen that most of the violations take place when the market move is large and the violation is typically a small fraction of the market move. This implies that in most cases, the model is able to correctly forecast that the markets are in a volatile period and step up the margins accordingly to protect market integrity.

    There are only two exceptions to this pattern. The first exception is March 31, 1997 when the sudden withdrawal of support to the then government by the major supporting party led to a sharp fall in the market. This is the kind of event risk which a statistical model cannot predict and against which the only protection can be a second line of defence (broker net worth). The second exception is October 28, 1997 when the global equity meltdown triggered by sharp falls in the Asian markets and in the US market drove the Indian market also down.

    It is conceivable, though by no means certain, that more sophisticated statistical models which can estimate volatility contagion across several financial markets could have provided better protection against the market drop of October 28, 1997. The development of multivariate models of volatility estimation that can account for such contagion is a topic for further research. Practical utility of such a model would however be contingent on the ability of the derivatives exchange / clearing corporation to make a margin call shortly before the market opens in Mumbai based on the market movement in New York (previous day close), Tokyo (same day close) and Hong Kong (same day morning session).
     
    Table 1: Summary Statistics of Margins on Nifty
    1990
    1991
    1992
    1993
    1994
    1995
    1996
    1997
    1998
    1990-98
    Nifty: Margin on Long Side
    Average
    7.97%
    5.33%
    8.63%
    5.13%
    3.97%
    3.55%
    4.24%
    5.03%
    4.89%
    5.15%
    Maximum
    11.48%
    8.86%
    17.85%
    7.02%
    7.34%
    5.49%
    7.05%
    8.22%
    8.43%
    17.85%
    Minimum
    4.99%
    3.48%
    3.48%
    3.34%
    2.12%
    2.00%
    2.74%
    2.97%
    3.68%
    2.00%
    Frequency Distribution
    Below 5%
    2.30%
    50.49%
    13.68%
    44.60%
    73.48%
    96.19%
    85.08%
    50.00%
    74.38%
    58.93%
    5 to 10%
    79.31%
    49.51%
    52.11%
    55.40%
    26.52%
    3.81%
    14.92%
    50.00%
    25.62%
    36.51%
    10 to 15%
    18.39%
    0.00%
    27.89%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    3.89%
    15 to 20%
    0.00%
    0.00%
    6.32%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.68%
    Above 20%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    Nifty: Margin on Short Side
    Average
    8.71%
    5.65%
    9.62%
    5.42%
    4.16%
    3.69%
    4.44%
    5.31%
    5.15%
    5.49%
    Maximum
    12.97%
    9.72%
    21.73%
    7.55%
    7.93%
    5.81%
    7.59%
    8.96%
    9.20%
    21.73%
    Minimum
    5.26%
    3.61%
    3.60%
    3.46%
    2.16%
    2.04%
    2.81%
    3.06%
    3.82%
    2.04%
    Frequency Distribution
    Below 5%
    0.00%
    41.75%
    12.11%
    31.92%
    72.61%
    91.95%
    75.40%
    44.26%
    62.81%
    52.51%
    5 to 10%
    67.82%
    58.25%
    48.95%
    68.08%
    27.39%
    8.05%
    24.60%
    55.74%
    37.19%
    41.75%
    10 to 15%
    32.18%
    0.00%
    24.21%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    4.17%
    15 to 20%
    0.00%
    0.00%
    12.63%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    1.35%
    Above 20%
    0.00%
    0.00%
    2.11%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.23%

     
    Table 2: Summary Statistics of Margins on Sensex 
    1990
    1991
    1992
    1993
    1994
    1995
    1996
    1997
    1998
    1990-98
    Sensex: Margin on Long Side
    Average
    9.08%
    6.11%
    8.74%
    5.47%
    4.12%
    3.61%
    4.33%
    4.70%
    5.12%
    5.37%
    Maximum
    13.08%
    10.23%
    17.57%
    7.45%
    7.39%
    5.11%
    6.50%
    7.93%
    8.66%
    17.57%
    Minimum
    5.35%
    3.72%
    3.67%
    3.48%
    2.35%
    2.16%
    2.95%
    2.73%
    3.85%
    2.16%
    Frequency Distribution
    Below 5%
    0.00%
    26.21%
    11.05%
    29.44%
    73.48%
    98.71%
    86.08%
    64.49%
    63.03%
    55.28%
    5 to 10%
    63.22%
    71.84%
    55.26%
    70.56%
    26.52%
    1.29%
    13.92%
    35.51%
    36.97%
    39.03%
    10 to 15%
    36.78%
    1.94%
    26.32%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    4.89%
    15 to 20%
    0.00%
    0.00%
    7.37%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.80%
    Above 20%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    Sensex: Margin on Short Side
    Average
    10.05%
    6.54%
    9.74%
    5.80%
    4.33%
    3.75%
    4.53%
    4.95%
    5.41%
    5.74%
    Maximum
    15.05%
    11.39%
    21.31%
    8.05%
    7.98%
    5.39%
    6.95%
    8.61%
    9.48%
    21.31%
    Minimum
    5.65%
    3.86%
    3.81%
    3.61%
    2.40%
    2.21%
    3.04%
    2.81%
    4.00%
    2.21%
    Frequency Distribution
    Below 5%
    0.00%
    19.42%
    8.42%
    24.77%
    72.61%
    95.26%
    81.86%
    58.37%
    45.38%
    50.45%
    5 to 10%
    51.72%
    71.36%
    53.68%
    75.23%
    27.39%
    4.74%
    18.14%
    41.63%
    54.62%
    41.99%
    10 to 15%
    47.13%
    9.22%
    24.74%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    6.08%
    15 to 20%
    1.15%
    0.00%
    11.58%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    1.31%
    Above 20%
    0.00%
    0.00%
    1.58%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.00%
    0.17%

    Figure 1

    Figure 2
     
     

    Figure 3
     
     
     

    Figure 4
[BACK]