FTSE 100 Companies – Live Data in a Spreadsheet

This tool gives you the latest financial data for stocks in the FTSE 100. Get the latest price, EBIDTA, dividend yield and more.

The 100 largest companies in the London Stock Exchange – that’s what you’re getting with the FTSE 100.

The index is full of blue chips stocks across many industries, such as oil and gas, mining and consumer goods. These companies operate across the globe.

Analysis often need the latest financial data for these companies, for fair value analysis, technical analysis, stock filtering or finding cheap income shares. This data is not often easily available in a computable format.

This is a list of the current constituents of the FTSE 100 (as of 8th March 2017).

TickerCompany
ABF.LASSOCIATED BRITISH FOODS PLC OR
ADM.LADMIRAL GROUP PLC ORD 0.1P
AAL.LANGLO AMERICAN PLC ORD USD0.549
ANTO.LANTOFAGASTA PLC ORD 5P
AHT.LASHTEAD GROUP PLC ORD 10P
AZN.LASTRAZENECA PLC ORD SHS $0.25
AV.LAVIVA PLC ORD 25P
BAB.LBABCOCK INTERNATIONAL GROUP PLC
BA.LBAE SYSTEMS PLC ORD 2.5P
BARC.LBARCLAYS PLC ORD 25P
BDEV.LBARRATT DEVELOPMENTS PLC ORD 10
BLT.LBHP BILLITON PLC ORD $0.50
BP.LBP PLC $0.25
BATS.LBRITISH AMERICAN TOBACCO PLC OR
BLND.LBRITISH LAND COMPANY PLC ORD 25
BT.LN/A
BNZL.LBUNZL PLC ORD 32 1/7P
BRBY.LBURBERRY GROUP PLC ORD 0.05P
CPI.LCAPITA PLC ORD 2.066666P
CCL.LCARNIVAL PLC ORD USD 1.66
CNA.LCENTRICA PLC ORD 6 14/81P
CCH.LCOCA-COLA HBC AG ORD CHF6.70 (C
CPG.LCOMPASS GROUP PLC ORD 10 5/8P
CTEC.LCONVATEC GROUP PLC ORD 10P
CRH.LCRH PLC ORD EUR 0.32
CRDA.LCRODA INTERNATIONAL PLC ORD 10.
DCC.LDCC PLC ORD EUR0.25
DGE.LDIAGEO PLC ORD 28 101/108P
DLG.LDIRECT LINE INSURANCE GROUP PLC
DC.LDIXONS CARPHONE PLC ORD 0.1P
EZJ.LEASYJET PLC ORD 27 2/7P
EXPN.LEXPERIAN PLC ORD USD0.10
FRES.LFRESNILLO PLC ORD USD0.50
GKN.LGKN PLC ORD 10P
GSK.LGLAXOSMITHKLINE PLC ORD 25P
GLEN.LGLENCORE PLC ORD USD0.01
HMSO.LHAMMERSON PLC ORD 25P
HL.LHARGREAVES LANSDOWN PLC ORD 0.4
HIK.LHIKMA PHARMACEUTICALS PLC ORD S
HSBA.LHSBC HOLDINGS PLC ORD $0.50 (UK
IMB.LIMPERIAL BRANDS PLC ORD 10P
INF.LINFORMA PLC ORD 0.1P
IHG.LINTERCONTINENTAL HOTELS GROUP P
ITRK.LINTERTEK GROUP PLC ORD 1P
IAG.LINTERNATIONAL CONSOLIDATED AIRL
INTU.LINTU PROPERTIES PLC ORD 50P
ITV.LITV PLC ORD 10P
JMAT.LJOHNSON MATTHEY PLC ORD 110 49/
KGF.LKINGFISHER PLC ORD 15 5/7P
LAND.LLAND SECURITIES GROUP PLC ORD 1
LGEN.LLEGAL & GENERAL GROUP PLC ORD 2
LLOY.LLLOYDS BANKING GROUP PLC ORD 10
LSE.LLONDON STOCK EXCHANGE GROUP PLC
MKS.LMARKS AND SPENCER GROUP PLC ORD
MDC.LMEDICLINIC INTERNATIONAL PLC OR
MERL.LMERLIN ENTERTAINMENTS PLC ORD 1
MCRO.LMICRO FOCUS INTERNATIONAL PLC O
MNDI.LMONDI PLC ORD EUR 0.20
MRW.LMORRISON (WM) SUPERMARKETS PLC
NG.LNATIONAL GRID PLC ORD 11 17/43P
NXT.LNEXT PLC ORD 10P
OML.LOLD MUTUAL PLC ORD 11 3/7P
PPB.LPADDY POWER BETFAIR PLC ORD EUR
PSON.LPEARSON PLC ORD 25P
PSN.LPERSIMMON PLC ORD 10P
PFG.LPROVIDENT FINANCIAL PLC ORD 20
PRU.LPRUDENTIAL PLC ORD 5P
RRS.LRANDGOLD RESOURCES LD ORD $0.05
RDSA.LROYAL DUTCH SHELL PLC 'A' ORD E
RDSB.LROYAL DUTCH SHELL PLC 'B' ORD E
RB.LRECKITT BENCKISER GROUP PLC ORD
REL.LRELX PLC ORD 14 51/116P
RIO.LRIO TINTO PLC ORD 10P
RR.LROLLS-ROYCE HOLDINGS PLC ORD SH
RBS.LROYAL BANK OF SCOTLAND GROUP PL
RMG.LROYAL MAIL PLC ORD 1P
RSA.LRSA INSURANCE GROUP PLC ORD GBP
SGE.LSAGE GROUP PLC ORD 1 4/77P
SBRY.LSAINSBURY (J) PLC ORD 28 4/7P
SDR.LSCHRODERS PLC VTG SHS 1
SVT.LSEVERN TRENT PLC ORD 97 17/19P
SHP.LSHIRE PLC ORD 5P
SKY.LSKY PLC ORD 50P
SN.LN/A
SMIN.LSMITHS GROUP PLC ORD 37.5P
SKG.LSMURFIT KAPPA GROUP PLC ORD EUR
SSE.LSSE PLC ORD 50P
STJ.LST. JAMES'S PLACE PLC ORD 15P
STAN.LSTANDARD CHARTERED PLC ORD USD0
SL.LSTANDARD LIFE PLC ORD 12 2/9P
TW.LTAYLOR WIMPEY PLC ORD 1P
TSCO.LTESCO PLC ORD 5P
TUI.LTUI AG ORD REG SHS NPV (DI)
ULVR.LUNILEVER PLC ORD 3 1/9P
UU.LUNITED UTILITIES GROUP PLC ORD
VOD.LVODAFONE GROUP PLC ORD USD0.20
WTB.LWHITBREAD PLC ORD 76 122/153P
WOS.LWOLSELEY PLC ORD 10 53/66P
WPG.LWORLDPAY GROUP PLC ORD 3P
WPP.LWPP PLC ORD 10P

This Excel spreadsheet downloads the latest financial information for every company in the FTSE 100. It’s prepopulated with the companies in the table above.

A series of drop-down menus let you choose the data you want; you can pick from the P/E ratio, PEG, 52-week trading range, dividend yield, EPS ttm and more.

An Excel spreadsheet that download financial data for the companies in the FTSE 100

The table of data is updated when you click the refresh button.

The data is computable – you could, for example, calculate the intrinsic value of a share, or find undervalued stocks by looking for low values of the PE, price-to-cash flow, and low price-to-book ratios.

If the members of the FTSE 100 change, then simply update the ticker list. That’s all there is!

This tool is driven by VBA. A great way to learn VBA is by studying and modifying existing code. Start with the code in this tool – the VBA in this tool is open to anyone to view, modify and learn from.

I would really appreciate a link to investexcel.net if you like this tool. Extra links and website traffic motivates me to write new spreadsheets.

Excel Spreadsheet to Retrieve Financial Data for all Companies in the FTSE 100


4 thoughts on “FTSE 100 Companies – Live Data in a Spreadsheet

  1. Hi,
    Just looking at the spreadsheet for FTSE top 100, it looks as though it could be quiet usefull, is there a way to make duplicate sheets? to say have US markets on one sheet, ASX markets on another UK makets on another stc.

    I like your work

    Regads
    Brian

  2. Samir, I would like to make most of your spreadsheets over at excel calculations.blogspot.com available on our company network. What would you consider as a reasonable donation? Plus I would like to add a small bio about the author of the programs, yourself I assume, and something to the effect that we made a donation.

Leave a Reply

Your email address will not be published. Required fields are marked *

What is 7 + 13 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)