Extreme returns and tail modelling of the FTSE 100 index for the UK equity market

Extreme returns and tail modelling of the FTSE 100 index for the UK equity market

Shengyu ZHENG

In this article, Shengyu ZHENG (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2024) describes the statistical behavior of extreme returns of the FTSE 100 index for the UK equity market and explains how extreme value theory can be used to model the tails of its distribution.

The FTSE 100 index for the UK equity market

The FTSE 100 index, an acronym for the Financial Times Stock Exchange 100 Index, stands as a cornerstone of the UK financial landscape. Comprising the largest and most robust companies listed on the London Stock Exchange (LSE), this index is a barometer for the overall health and trajectory of the British stock market. Spanning diverse sectors such as finance, energy, healthcare, and consumer goods, the FTSE 100 encapsulates the economic pulse of the nation. The 100 companies in the index are chosen based on their market capitalization, with larger entities carrying more weight in the index’s calculation, making it a valuable tool for investors seeking a comprehensive snapshot of the UK’s economic performance.

Investors and analysts globally turn to the FTSE 100 for insights into market trends and economic stability in the UK. The index’s movements provide a useful reference point for decision-making, enabling investors to gauge the relative strength and weaknesses of different industries and the economy at large. Moreover, the FTSE 100 serves as a powerful benchmark for numerous financial instruments, including mutual funds, exchange-traded funds (ETFs), and other investment products. As a result, the index plays a pivotal role in shaping investment strategies and fostering a deeper understanding of the intricate dynamics that drive the British financial markets.

In this article, we focus on the FTSE 100 index of the timeframe from April 1st, 2015, to April 1st, 2023. Here we have a line chart depicting the evolution of the index level of this period.

Figure 1 below gives the evolution of the FTSE 100 index from April 1, 2015 to April 1, 2023 on a daily basis.

Figure 1. Evolution of the FTSE 100 index.
Evolution of the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Figure 2 below gives the evolution of the daily logarithmic returns of FTSE 100 index from April 1, 2015 to April 1, 2023. We observe concentration of volatility reflecting large price fluctuations in both directions (up and down movements). This alternation of periods of low and high volatility is well modeled by ARCH models.

Figure 2. Evolution of the FTSE 100 index returns.
Evolution of the FTSE 100 index returns
Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the FTSE 100 index

Table 1 below presents the summary statistics estimated for the FTSE 100 index:

Table 1. Summary statistics for the FTSE 100 index returns.
Summary statistics of the FTSE 100 index returns
Source: computation by the author (data: Yahoo! Finance website).

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively. We can conclude that during this timeframe, the FTSE 100 index takes on a slight upward trend, with relatively important daily deviation, negative skewness and excess of kurtosis.

Tables 2 and 3 below present the top 10 negative daily returns and top 10 positive daily returns for the index over the period from April 1, 2015 to April 1, 2023.

Table 2. Top 10 negative daily returns for the FTSE 100 index.
Top 10 negative returns of the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Table 3. Top 10 positive daily returns for the FTSE 100 index.
Top 10 positive returns of the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Modelling of the tails

Here the tail modelling is conducted based on the Peak-over-Threshold (POT) approach which corresponds to a Generalized Pareto Distribution (GPD). Let’s recall the theoretical background of this approach.

The POT approach takes into account all data entries above a designated high threshold u. The threshold exceedances could be fitted into a generalized Pareto distribution:

 Illustration of the POT approach

An important issue for the POT-GPD approach is the threshold selection. An optimal threshold level can be derived by calibrating the tradeoff between bias and inefficiency. There exist several approaches to address this problematic, including a Monte Carlo simulation method inspired by the work of Jansen and de Vries (1991). In this article, to fit the GPD, we use the 2.5% quantile for the modelling of the negative tail and the 97.5% quantile for that of the positive tail.

Based on the POT-GPD approach with a fixed threshold selection, we arrive at the following modelling results for the GPD for negative extreme returns (Table 4) and positive extreme returns (Table 5) for the FTSE 100 index:

Table 4. Estimate of the parameters of the GPD for negative daily returns for the FTSE 100 index.
Estimate of the parameters of the GPD for negative daily returns for the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Table 5. Estimate of the parameters of the GPD for positive daily returns for the FTSE 100 index.
Estimate of the parameters of the GPD for positive daily returns for the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Figure 3. GPD for the left tail of the FTSE 100 index returns.
GPD for the left tail of the FTSE 100 index returns
Source: computation by the author (data: Yahoo! Finance website).

Figure 4. GPD for the right tail of the FTSE 100 index returns.
GPD for the right tail of the FTSE 100 index returns
Source: computation by the author (data: Yahoo! Finance website).

Applications in risk management

Extreme Value Theory (EVT) as a statistical approach is used to analyze the tails of a distribution, focusing on extreme events or rare occurrences. EVT can be applied to various risk management techniques, including Value at Risk (VaR), Expected Shortfall (ES), and stress testing, to provide a more comprehensive understanding of extreme risks in financial markets.

Why should I be interested in this post?

Extreme Value Theory is a useful tool to model the tails of the evolution of a financial instrument. In the ever-evolving landscape of financial markets, being able to grasp the concept of EVT presents a unique edge to students who aspire to become an investment or risk manager. It not only provides a deeper insight into the dynamics of equity markets but also equips them with a practical skill set essential for risk analysis. By exploring how EVT refines risk measures like Value at Risk (VaR) and Expected Shortfall (ES) and its role in stress testing, students gain a valuable perspective on how financial institutions navigate during extreme events. In a world where financial crises and market volatility are recurrent, this post opens the door to a powerful analytical framework that contributes to informed decisions and financial stability.

Download R file to model extreme behavior of the index

You can find below an R file (file with txt format) to study extreme returns and model the distribution tails for the FTSE 100 index.

Download R file to study extreme returns and model the distribution tails for the FTSE 100 index

Related posts on the SimTrade blog

About financial indexes

   ▶ Nithisha CHALLA Financial indexes

   ▶ Nithisha CHALLA Calculation of financial indexes

   ▶ Nithisha CHALLA The FTSE 100 index

About portfolio management

   ▶ Youssef LOURAOUI Portfolio

   ▶ Jayati WALIA Returns

About statistics

   ▶ Shengyu ZHENG Moments de la distribution

   ▶ Shengyu ZHENG Mesures de risques

   ▶ Shengyu ZHENG Extreme Value Theory: the Block-Maxima approach and the Peak-Over-Threshold approach

   ▶ Gabriel FILJA Application de la théorie des valeurs extrêmes en finance de marchés

Useful resources

Academic resources

Embrechts P., C. Klüppelberg and T. Mikosch (1997) Modelling Extremal Events for Insurance and Finance Springer-Verlag.

Embrechts P., R. Frey, McNeil A.J. (2022) Quantitative Risk Management Princeton University Press.

Gumbel, E. J. (1958) Statistics of extremes New York: Columbia University Press.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Other resources

Extreme Events in Finance

Chan S. Statistical tools for extreme value analysis

Rieder H. E. (2014) Extreme Value Theory: A primer (slides).

About the author

The article was written in November 2023 by Shengyu ZHENG (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2024).

The FTSE 100 index

The FTSE 100 index

Nithisha CHALLA

In this article, Nithisha CHALLA (ESSEC Business School, Grande Ecole Program – Master in Management, 2021-2023) presents the FTSE 100 index and details its characteristics.

The FTSE 100 index

The Financial Times and the London Stock Exchange established the FTSE 100 index in 1984. It is now run by FTSE Group, a partnership between the Financial Times and the London Stock Exchange. The index, which is regarded as the standard index for the UK equity market, includes the 100 largest companies by market capitalization that are listed on the London Stock Exchange.

Larger companies have a greater influence on the index’s movements than smaller ones because the index is market capitalization-weighted. HSBC, Royal Dutch Shell, BP, and Unilever are a few of the biggest companies that make up the FTSE 100 as of 2021. The FTSE 100 is a key metric for gauging the state of the UK economy because it serves as a benchmark for funds and investment portfolios with UK roots. Recent occurrences like Brexit, the COVID-19 pandemic, and adjustments to the global economy have all had an effect on the index.

The sectoral composition of the FTSE 100 is one of its distinctive features. The financial and resource sectors account for a significant portion of the index’s total market capitalization, which heavily favors these industries.

How is the FTSE 100 index represented in trading platforms and financial websites? The ticker symbol used in the financial industry for the FTSE 100 index is “UKX”.

Table 1 below gives the Top 10 stocks in the FTSE 100 index in terms of market capitalization as of January 31, 2023.

Table 1. Top 10 stocks in the FTSE 100 index.
Top 10 stocks in the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance financial website).

Table 2 below gives the sector representation of the FTSE 100 index in terms of number of stocks and market capitalization as of January 31, 2023.

Table 2. Sector representation in the FTSE 100 index.
Sector representation in the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance financial website).

Calculation of the FTSE 100 index value

The FTSE 100 is a market capitalization-weighted index, which means that each company’s weight in the index is determined by its market capitalization, i.e., the total value of all its outstanding shares. The index, which is regarded as the standard index for the UK equity market, includes the 100 largest companies by market capitalization that are listed on the London Stock Exchange.

The formula to compute the FTSE 100 index is given by

Market Capitalization Index value

Where I is the index value, k a given asset, K the number of assets in the index, Pk the market price of asset k, Nk the number of issued shares for asset k, and t the time of calculation of the index.

In a market capitalization-weighted index, the weight of asset k is given by formula can be rewritten as

Market Capitalization Weighted Index Weight

Which clearly shows that the weight of each asset in the index is its market capitalization of the asset divided by the sum of the market capitalizations of all assets.

Note that the divisor, whose calculation is based on the number of shares, is typically adjusted for events such as stock splits and dividends. The divisor is used to ensure that the value of the index remains consistent over time despite changes in the number of outstanding shares.

Use of the FTSE 100 index in asset management

The performance of large-cap companies listed on the London Stock Exchange is frequently measured against the FTSE 100. Investors can gain insight into the overall health of the UK economy and spot potential opportunities or risks in particular industries or regions by examining the sector weightings and geographic exposure of the index. It serves as a benchmark for asset managers to compare the performance of their equity portfolios to the overall market performance.

Benchmark for equity funds

One of the most popular metrics for assessing the performance of the UK stock market is the FTSE 100. It includes businesses from a wide range of sectors, including consumer goods, healthcare, energy, and finance. As a result, it is frequently used by investors and fund managers to monitor the UK economy’s performance and evaluate the country’s investment opportunities.

Financial products around the FTSE 100 index

There are several financial products that track the performance of the FTSE 100 index, allowing investors to gain exposure to the Japanese stock market.

  • ETFs are investment funds traded on stock exchanges, designed to track the performance of an index. There are several ETFs that track the FTSE 100 index, such as the iShares Core FTSE 100 ETF and the Vanguard FTSE 100 UCITS ETF.
  • index funds are also designed to track the performance of an index. index funds based on the FTSE 100 index include the HSBC FTSE 100 Index Fund and the Legal & General UK 100 Index Fund.
  • Futures and options contracts based on the FTSE 100 index provide investors with the ability to speculate on the future performance of the index. For example, the London International Financial Futures and Options Exchange (LIFFE) offers futures contracts based on the FTSE 100 index.
  • Certificates are investment products that allow investors to gain exposure to the FTSE 100 index. Société Générale offers a range of certificates linked to the FTSE 100 index, such as the FTSE 100 Tracker Certificate.

Historical data for the FTSE 100 index

How to get the data?

The FTSE 100 index is the most common index used in finance, and historical data for the FTSE 100 index can be easily downloaded from the internet.

For example, you can download data for the FTSE 100 index from January 3, 1984 on Yahoo! Finance (the Yahoo! code for FTSE 100 index is ^FTSE).

Yahoo! Finance
Source: Yahoo! Finance.

You can also download the same data from a Bloomberg terminal.

R program

The R program below written by Shengyu ZHENG allows you to download the data from Yahoo! Finance website and to compute summary statistics and risk measures about the FTSE 100 index.

Download R file

Data file

The R program that you can download above allows you to download the data for the FTSE 100 index from the Yahoo! Finance website. The database starts on January 3, 1984. It also computes the returns (logarithmic returns) from closing prices.

Table 3 below represents the top of the data file for the FTSE 100 index downloaded from the Yahoo! Finance website with the R program.

Table 3. Top of the data file for the FTSE 100 index.
Top of the file for the FTSE 100 index data
Source: computation by the author (data: Yahoo! Finance website).

Evolution of the FTSE 100 index

Figure 1 below gives the evolution of the FTSE 100 index from January 3, 1984 to December 30, 2022 on a daily basis.

Figure 1. Evolution of the FTSE 100 index.
Evolution of the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Figure 2 below gives the evolution of the FTSE 100 index returns from January 3, 1984 to December 30, 2022 on a daily basis.

Figure 2. Evolution of the FTSE 100 index returns.
Evolution of the FTSE 100 index return
Source: computation by the author (data: Yahoo! Finance website).

Summary statistics for the FTSE 100 index

The R program that you can download above also allows you to compute summary statistics about the returns of the FTSE 100 index.

Table 4 below presents the following summary statistics estimated for the FTSE 100 index:

  • The mean
  • The standard deviation (the squared root of the variance)
  • The skewness
  • The kurtosis.

The mean, the standard deviation / variance, the skewness, and the kurtosis refer to the first, second, third and fourth moments of statistical distribution of returns respectively.

Table 4. Summary statistics for the FTSE 100 index.
Summary statistics for the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

Statistical distribution of the FTSE 100 index returns

Historical distribution

Figure 3 represents the historical distribution of the FTSE 100 index daily returns for the period from January 3, 1984 to December 30, 2022.

Figure 3. Historical distribution of the FTSE 100 index returns.
Historical distribution of the daily FTSE 100 index returns
Source: computation by the author (data: Yahoo! Finance website).

Gaussian distribution

The Gaussian distribution (also called the normal distribution) is a parametric distribution with two parameters: the mean and the standard deviation of returns. We estimated these two parameters over the period from January 3, 1984 to December 30, 2022. The mean of daily returns is equal to 0.02% and the standard deviation of daily returns is equal to 1.37% (or equivalently 3.94% for the annual mean and 28.02% for the annual standard deviation as shown in Table 3 above).

Figure 4 below represents the Gaussian distribution of the FTSE 100 index daily returns with parameters estimated over the period from January 3, 1984 to December 30, 2022.

Figure 4. Gaussian distribution of the FTSE 100 index returns.
Gaussian distribution of the daily FTSE 100 index returns
Source: computation by the author (data: Yahoo! Finance website).

Risk measures of the FTSE 100 index returns

The R program that you can download above also allows you to compute risk measures about the returns of the FTSE 100 index.

Table 5 below presents the following risk measures estimated for the FTSE 100 index:

  • The long-term volatility (the unconditional standard deviation estimated over the entire period)
  • The short-term volatility (the standard deviation estimated over the last three months)
  • The Value at Risk (VaR) for the left tail (the 5% quantile of the historical distribution)
  • The Value at Risk (VaR) for the right tail (the 95% quantile of the historical distribution)
  • The Expected Shortfall (ES) for the left tail (the average loss over the 5% quantile of the historical distribution)
  • The Expected Shortfall (ES) for the right tail (the average loss over the 95% quantile of the historical distribution)
  • The Stress Value (SV) for the left tail (the 1% quantile of the tail distribution estimated with a Generalized Pareto distribution)
  • The Stress Value (SV) for the right tail (the 99% quantile of the tail distribution estimated with a Generalized Pareto distribution)

Table 5. Risk measures for the FTSE 100 index.
Risk measures for the FTSE 100 index
Source: computation by the author (data: Yahoo! Finance website).

The volatility is a global measure of risk as it considers all the returns. The Value at Risk (VaR), Expected Shortfall (ES) and Stress Value (SV) are local measures of risk as they focus on the tails of the distribution. The study of the left tail is relevant for an investor holding a long position in the FTSE 100 index while the study of the right tail is relevant for an investor holding a short position in the FTSE 100 index.

Why should I be interested in this post?

For a number of reasons, management students (as future managers and individual investors) should learn about the FTSE 100 index. The FTSE 100 index is a key benchmark for the Japanese equity market, which is one of the world’s largest market. Understanding how the index is constructed, how it performs, and the companies that make up the index is important for anyone studying finance or business in Japan or interested in investing in Japanese equities.

Individual investors can assess the performance of their own investments in the Japanese equity market with the FTSE 100 index. Last but not least, a lot of asset management firms base their mutual funds and exchange-traded funds (ETFs) on the FTSE 100 index which can considered as interesting assets to diversify a portfolio. Learning about these products and their portfolio and risk management applications can be valuable for management students.

Related posts on the SimTrade blog

About financial indexes

   ▶ Nithisha CHALLA Financial indexes

   ▶ Nithisha CHALLA Calculation of financial indexes

   ▶ Nithisha CHALLA The business of financial indexes

   ▶ Nithisha CHALLA Float

Other financial indexes

   ▶ Nithisha CHALLA The S&P 500 index

   ▶ Nithisha CHALLA The CSI 300 index

   ▶ Nithisha CHALLA The Nikkei 225 index

   ▶ Nithisha CHALLA The DAX 30 index

About portfolio management

   ▶ Youssef LOURAOUI Portfolio

   ▶ Jayati WALIA Returns

About statistics

   ▶ Shengyu ZHENG Moments de la distribution

   ▶ Shengyu ZHENG Mesures de risques

Useful resources

Academic research about risk

Longin F. (2000) From VaR to stress testing: the extreme value approach Journal of Banking and Finance, N°24, pp 1097-1130.

Longin F. (2016) Extreme events in finance: a handbook of extreme value theory and its applications Wiley Editions.

Business

Axi What is the FTSE 100 index and how to trade it?

CMC markets An introduction to the FTSE 100

Nerd Wallet What is the FTSE 100?

Data

Yahoo! Finance

Yahoo Finance FTSE 100 index

About the author

The article was written in April 2023 by Nithisha CHALLA (ESSEC Business School, Grande Ecole Program – Master in Management, 2021-2023).