What you are downloading
Free market data is never clean. Everything we repaired or removed is listed here — but Module 1 asks you to find the problems yourself first, so you may prefer to come back to this page afterwards.
100Names included
0Names dropped
1995-01History starts
Choose your window
Benchmarks, and why two of them disagree
There is no single thing called “the index”. The file gives you several, and comparing them is the point.
| Series | What it actually is |
|---|---|
^FTSE | FTSE 100 price index. No dividends. The longest history. |
CUKX.L | iShares Core FTSE 100 accumulating ETF. Dividends reinvested inside the fund, so this genuinely is total return. Regress against this one. |
FTAL.L | SPDR FTSE UK All-Share accumulating ETF. Total return, wider universe. |
ISF.L | iShares Core FTSE 100 distributing ETF. Looks like total return. Is not. See Module 1. |
EQUAL_WEIGHT_TR | Equal-weighted basket of the names in your file. |
CAPFIXED_TR | The same names at today’s cap weights, held fixed. |
The cleaning log
| Ticker | Date | Move | Ratio | Verdict |
|---|---|---|---|---|
BA.L | 1995-12-25 | -94% | ×16.0 | repaired |
BA.L | 1995-12-27 | +1516% | ×16.2 | repaired |
BA.L | 1996-01-01 | -94% | ×16.0 | repaired |
BA.L | …and 17 more, nearly all on UK bank holidays | |||
BGEO.L | 2012-02-28 | +5377% | ×54.8 | excluded |
PCT.L | 2011-04-29 | -90% | ×10.0 | repaired |
PCT.L | 2009-01-02 | +942% | ×10.4 | excluded |
PCT.L | 2013-01-02 | -90% | ×9.7 | excluded |
ULVR.L | 1995-04-14 | +5129% | ×52.3 | repaired |
ULVR.L | 1995-05-08 | +5124% | ×52.2 | repaired |
ULVR.L | 1995-05-29 | +5131% | ×52.3 | repaired |
ULVR.L | …and 27 more, nearly all on UK bank holidays | |||
ULVR.L | 1995-01-03 | -98% | ×52.4 | excluded |
ULVR.L | 1997-10-13 | +1533% | ×16.3 | excluded |
Dropped for bad data:
Dropped for too little history:
The universe
| Ticker | Name | ICB industry | Mkt cap (£m) | Weight | From |
|---|---|---|---|---|---|
III.L |
3i | Financials | 26,524 | 0.97% | 1995-01-02 |
ABDN.L |
Aberdeen Group | Financials | 4,338 | 0.16% | 2006-07-10 |
ADM.L |
Admiral Group | Financials | 11,663 | 0.43% | 2004-09-23 |
AAF.L |
Airtel Africa | Telecommunications | 12,754 | 0.47% | 2019-06-28 |
ALW.L |
Alliance Witan | Financials | 4,924 | 0.18% | 1995-01-02 |
AAL.L |
Anglo American plc | Basic Materials | 42,088 | 1.54% | 1999-05-24 |
ANTO.L |
Antofagasta plc | Basic Materials | 35,234 | 1.29% | 1995-01-02 |
ABF.L |
Associated British Foods | Consumer Staples | 12,894 | 0.47% | 1995-01-02 |
AZN.L |
AstraZeneca | Health Care | 185,734 | 6.80% | 1995-01-02 |
AUTO.L |
Autotrader Group | Consumer Discretionary | 3,840 | 0.14% | 2015-03-19 |
AV.L |
Aviva | Financials | 21,290 | 0.78% | 1995-01-02 |
BAB.L |
Babcock International | Industrials | 4,795 | 0.18% | 1995-01-02 |
BA.L |
BAE Systems | Industrials | 57,731 | 2.11% | 1995-01-02 |
BARC.L |
Barclays | Financials | 63,743 | 2.33% | 1995-01-02 |
BTRW.L |
Barratt Redrow | Consumer Discretionary | 3,826 | 0.14% | 1995-01-02 |
BEZ.L |
Beazley | Financials | 7,766 | 0.28% | 2002-11-12 |
BP.L |
BP | Energy | 88,975 | 3.26% | 1995-01-02 |
BATS.L |
British American Tobacco | Consumer Staples | 90,161 | 3.30% | 1995-01-03 |
BLND.L |
British Land | Real Estate | 4,041 | 0.15% | 1995-01-02 |
BT-A.L |
BT Group | Telecommunications | 20,131 | 0.74% | 1995-01-02 |
BNZL.L |
Bunzl | Industrials | 8,233 | 0.30% | 1995-01-02 |
BRBY.L |
Burberry Group | Consumer Discretionary | 3,568 | 0.13% | 2002-07-12 |
CNA.L |
Centrica | Utilities | 6,708 | 0.25% | 1997-02-17 |
CCEP.L |
Coca-Cola Europacific Partners | Consumer Staples | 33,970 | 1.24% | 2019-03-28 |
CCH.L |
Coca-Cola HBC | Consumer Staples | 16,773 | 0.61% | 2013-04-29 |
CPG.L |
Compass Group | Industrials | 39,850 | 1.46% | 2000-01-04 |
CCC.L |
Computacenter | Technology | 5,494 | 0.20% | 1998-05-21 |
CTEC.L |
Convatec | Health Care | 4,210 | 0.15% | 2016-10-26 |
CRDA.L |
Croda International | Basic Materials | 4,405 | 0.16% | 1995-01-02 |
DCC.L |
DCC Energy | Industrials | 5,412 | 0.20% | 2000-01-04 |
DGE.L |
Diageo | Consumer Staples | 35,856 | 1.31% | 1995-01-02 |
DPLM.L |
Diploma | Industrials | 9,514 | 0.35% | 1995-01-02 |
EDV.L |
Endeavour Mining | Basic Materials | 10,799 | 0.40% | 2018-01-30 |
ENT.L |
Entain | Consumer Discretionary | 3,190 | 0.12% | 2004-12-21 |
EXPN.L |
Experian | Industrials | 24,708 | 0.90% | 2006-10-09 |
FCIT.L |
F & C Investment Trust | Financials | 6,325 | 0.23% | 1995-01-02 |
FRES.L |
Fresnillo plc | Basic Materials | 21,458 | 0.79% | 2008-05-09 |
GAW.L |
Games Workshop | Consumer Discretionary | 5,823 | 0.21% | 1995-01-02 |
GLEN.L |
Glencore | Basic Materials | 68,250 | 2.50% | 2011-05-19 |
GSK.L |
GSK plc | Health Care | 73,884 | 2.70% | 1995-01-02 |
HLN.L |
Haleon | Health Care | 29,693 | 1.09% | 2022-07-18 |
HLMA.L |
Halma plc | Technology | 13,075 | 0.48% | 1995-01-02 |
HSX.L |
Hiscox | Financials | 5,984 | 0.22% | 2000-01-04 |
HWDN.L |
Howdens Joinery | Industrials | 4,078 | 0.15% | 1995-01-02 |
HSBA.L |
HSBC | Financials | 261,258 | 9.56% | 1995-01-02 |
ICG.L |
ICG | Financials | 5,336 | 0.20% | 1995-01-02 |
IGG.L |
IG Group | Financials | 4,324 | 0.16% | 2005-04-28 |
IHG.L |
IHG Hotels & Resorts | Consumer Discretionary | 16,711 | 0.61% | 2003-03-31 |
IMI.L |
IMI | Industrials | 7,067 | 0.26% | 1995-01-02 |
IMB.L |
Imperial Brands | Consumer Staples | 18,955 | 0.69% | 1996-10-01 |
INF.L |
Informa | Consumer Discretionary | 11,071 | 0.41% | 1998-12-22 |
IAG.L |
International Airlines Group | Consumer Discretionary | 17,987 | 0.66% | 2003-01-02 |
ITRK.L |
Intertek | Industrials | 8,995 | 0.33% | 2002-05-24 |
INVP.L |
Investec | Financials | 4,121 | 0.15% | 2002-07-22 |
JD.L |
JD Sports | Consumer Discretionary | 3,640 | 0.13% | 1996-10-22 |
BGEO.L |
Lion Finance Group | Financials | 5,812 | 0.21% | 2006-11-24 |
KGF.L |
Kingfisher plc | Consumer Discretionary | 4,766 | 0.17% | 1995-01-02 |
LAND.L |
Land Securities | Real Estate | 4,654 | 0.17% | 1995-01-02 |
LGEN.L |
Legal & General | Financials | 15,955 | 0.58% | 1995-01-02 |
LLOY.L |
Lloyds Banking Group | Financials | 63,462 | 2.32% | 1995-12-28 |
LMP.L |
LondonMetric Property | Real Estate | 4,324 | 0.16% | 2007-11-07 |
LSEG.L |
London Stock Exchange Group | Financials | 40,010 | 1.46% | 2001-07-20 |
MNG.L |
M&G | Financials | 7,914 | 0.29% | 2019-10-21 |
MKS.L |
Marks & Spencer | Consumer Staples | 7,822 | 0.29% | 1995-01-02 |
MRO.L |
Melrose Industries | Industrials | 5,818 | 0.21% | 2003-10-28 |
MTLN.L |
Metlen Energy & Metals | Utilities | 5,683 | 0.21% | 2025-08-04 |
NG.L |
National Grid plc | Utilities | 55,446 | 2.03% | 1995-12-11 |
NWG.L |
NatWest Group | Financials | 55,018 | 2.01% | 1995-01-02 |
NXT.L |
Next plc | Consumer Discretionary | 16,860 | 0.62% | 1995-01-02 |
PSON.L |
Pearson plc | Consumer Discretionary | 7,084 | 0.26% | 1995-01-02 |
PSH.L |
Pershing Square Holdings | Financials | 6,559 | 0.24% | 2017-03-10 |
PSN.L |
Persimmon | Consumer Discretionary | 3,540 | 0.13% | 1995-01-02 |
PCT.L |
Polar Capital Technology Trust | Financials | 7,032 | 0.26% | 1996-12-16 |
PRU.L |
Prudential plc | Financials | 24,049 | 0.88% | 1995-01-02 |
RKT.L |
Reckitt | Consumer Discretionary | 32,013 | 1.17% | 1995-01-02 |
REL.L |
RELX | Consumer Discretionary | 43,793 | 1.60% | 1995-01-02 |
RTO.L |
Rentokil Initial | Industrials | 8,271 | 0.30% | 1995-01-02 |
RIO.L |
Rio Tinto | Basic Materials | 116,821 | 4.28% | 1995-01-02 |
RR.L |
Rolls-Royce Holdings | Industrials | 117,686 | 4.31% | 1995-01-02 |
SGE.L |
Sage Group | Technology | 8,979 | 0.33% | 1995-01-02 |
SBRY.L |
Sainsbury's | Consumer Staples | 7,340 | 0.27% | 1995-01-02 |
SDR.L |
Schroders | Financials | 9,130 | 0.33% | 1995-01-02 |
SMT.L |
Scottish Mortgage Investment Trust | Financials | 15,503 | 0.57% | 1995-01-02 |
SGRO.L |
Segro | Real Estate | 12,583 | 0.46% | 1995-01-02 |
SVT.L |
Severn Trent | Utilities | 8,820 | 0.32% | 1995-01-02 |
SHEL.L |
Shell plc | Energy | 207,336 | 7.59% | 1996-08-29 |
SMIN.L |
Smiths Group | Industrials | 7,207 | 0.26% | 1995-01-02 |
SN.L |
Smith & Nephew | Health Care | 8,688 | 0.32% | 1995-01-02 |
SPX.L |
Spirax Group | Industrials | 5,050 | 0.18% | 1995-01-02 |
SSE.L |
SSE plc | Utilities | 28,058 | 1.03% | 1995-01-02 |
STAN.L |
Standard Chartered | Financials | 49,956 | 1.83% | 1995-01-02 |
SDLF.L |
Standard Life | Financials | 9,325 | 0.34% | 2009-11-17 |
STJ.L |
St. James's Place | Financials | 5,572 | 0.20% | 1995-01-02 |
TSCO.L |
Tesco | Consumer Staples | 30,036 | 1.10% | 1995-01-02 |
BBOX.L |
Tritax Big Box REIT | Real Estate | 4,222 | 0.15% | 2013-12-09 |
ULVR.L |
Unilever | Consumer Discretionary | 99,502 | 3.64% | 1995-01-02 |
UU.L |
United Utilities | Utilities | 9,873 | 0.36% | 1995-01-02 |
VOD.L |
Vodafone Group | Telecommunications | 30,286 | 1.11% | 1995-01-02 |
WEIR.L |
Weir | Industrials | 6,817 | 0.25% | 1995-01-02 |
WTB.L |
Whitbread | Consumer Discretionary | 3,901 | 0.14% | 1995-01-02 |