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.
57Names included
43Names 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: BGEO.L PCT.L ULVR.L
Dropped for too little history:
The universe
| Ticker | Name | ICB industry | Mkt cap (£m) | Weight | From |
|---|---|---|---|---|---|
III.L |
3i | Financials | 26,524 | 1.51% | 1995-01-02 |
ALW.L |
Alliance Witan | Financials | 4,924 | 0.28% | 1995-01-02 |
ANTO.L |
Antofagasta plc | Basic Materials | 35,234 | 2.00% | 1995-01-02 |
ABF.L |
Associated British Foods | Consumer Staples | 12,894 | 0.73% | 1995-01-02 |
AZN.L |
AstraZeneca | Health Care | 185,734 | 10.55% | 1995-01-02 |
AV.L |
Aviva | Financials | 21,290 | 1.21% | 1995-01-02 |
BAB.L |
Babcock International | Industrials | 4,795 | 0.27% | 1995-01-02 |
BA.L |
BAE Systems | Industrials | 57,731 | 3.28% | 1995-01-02 |
BARC.L |
Barclays | Financials | 63,743 | 3.62% | 1995-01-02 |
BTRW.L |
Barratt Redrow | Consumer Discretionary | 3,826 | 0.22% | 1995-01-02 |
BP.L |
BP | Energy | 88,975 | 5.05% | 1995-01-02 |
BATS.L |
British American Tobacco | Consumer Staples | 90,161 | 5.12% | 1995-01-03 |
BLND.L |
British Land | Real Estate | 4,041 | 0.23% | 1995-01-02 |
BT-A.L |
BT Group | Telecommunications | 20,131 | 1.14% | 1995-01-02 |
BNZL.L |
Bunzl | Industrials | 8,233 | 0.47% | 1995-01-02 |
CRDA.L |
Croda International | Basic Materials | 4,405 | 0.25% | 1995-01-02 |
DGE.L |
Diageo | Consumer Staples | 35,856 | 2.04% | 1995-01-02 |
DPLM.L |
Diploma | Industrials | 9,514 | 0.54% | 1995-01-02 |
FCIT.L |
F & C Investment Trust | Financials | 6,325 | 0.36% | 1995-01-02 |
GAW.L |
Games Workshop | Consumer Discretionary | 5,823 | 0.33% | 1995-01-02 |
GSK.L |
GSK plc | Health Care | 73,884 | 4.20% | 1995-01-02 |
HLMA.L |
Halma plc | Technology | 13,075 | 0.74% | 1995-01-02 |
HWDN.L |
Howdens Joinery | Industrials | 4,078 | 0.23% | 1995-01-02 |
HSBA.L |
HSBC | Financials | 261,258 | 14.84% | 1995-01-02 |
ICG.L |
ICG | Financials | 5,336 | 0.30% | 1995-01-02 |
IMI.L |
IMI | Industrials | 7,067 | 0.40% | 1995-01-02 |
KGF.L |
Kingfisher plc | Consumer Discretionary | 4,766 | 0.27% | 1995-01-02 |
LAND.L |
Land Securities | Real Estate | 4,654 | 0.26% | 1995-01-02 |
LGEN.L |
Legal & General | Financials | 15,955 | 0.91% | 1995-01-02 |
MKS.L |
Marks & Spencer | Consumer Staples | 7,822 | 0.44% | 1995-01-02 |
NWG.L |
NatWest Group | Financials | 55,018 | 3.12% | 1995-01-02 |
NXT.L |
Next plc | Consumer Discretionary | 16,860 | 0.96% | 1995-01-02 |
PSON.L |
Pearson plc | Consumer Discretionary | 7,084 | 0.40% | 1995-01-02 |
PSN.L |
Persimmon | Consumer Discretionary | 3,540 | 0.20% | 1995-01-02 |
PRU.L |
Prudential plc | Financials | 24,049 | 1.37% | 1995-01-02 |
RKT.L |
Reckitt | Consumer Discretionary | 32,013 | 1.82% | 1995-01-02 |
REL.L |
RELX | Consumer Discretionary | 43,793 | 2.49% | 1995-01-02 |
RTO.L |
Rentokil Initial | Industrials | 8,271 | 0.47% | 1995-01-02 |
RIO.L |
Rio Tinto | Basic Materials | 116,821 | 6.63% | 1995-01-02 |
RR.L |
Rolls-Royce Holdings | Industrials | 117,686 | 6.68% | 1995-01-02 |
SGE.L |
Sage Group | Technology | 8,979 | 0.51% | 1995-01-02 |
SBRY.L |
Sainsbury's | Consumer Staples | 7,340 | 0.42% | 1995-01-02 |
SDR.L |
Schroders | Financials | 9,130 | 0.52% | 1995-01-02 |
SMT.L |
Scottish Mortgage Investment Trust | Financials | 15,503 | 0.88% | 1995-01-02 |
SGRO.L |
Segro | Real Estate | 12,583 | 0.71% | 1995-01-02 |
SVT.L |
Severn Trent | Utilities | 8,820 | 0.50% | 1995-01-02 |
SMIN.L |
Smiths Group | Industrials | 7,207 | 0.41% | 1995-01-02 |
SN.L |
Smith & Nephew | Health Care | 8,688 | 0.49% | 1995-01-02 |
SPX.L |
Spirax Group | Industrials | 5,050 | 0.29% | 1995-01-02 |
SSE.L |
SSE plc | Utilities | 28,058 | 1.59% | 1995-01-02 |
STAN.L |
Standard Chartered | Financials | 49,956 | 2.84% | 1995-01-02 |
STJ.L |
St. James's Place | Financials | 5,572 | 0.32% | 1995-01-02 |
TSCO.L |
Tesco | Consumer Staples | 30,036 | 1.71% | 1995-01-02 |
UU.L |
United Utilities | Utilities | 9,873 | 0.56% | 1995-01-02 |
VOD.L |
Vodafone Group | Telecommunications | 30,286 | 1.72% | 1995-01-02 |
WEIR.L |
Weir | Industrials | 6,817 | 0.39% | 1995-01-02 |
WTB.L |
Whitbread | Consumer Discretionary | 3,901 | 0.22% | 1995-01-02 |