Home > Business Databases > Finding UK listed companies – try LSPD

Finding UK listed companies – try LSPD

If you are looking for an active company (one currently listed on the London Stock Exchange) then your only problem is getting the name right. For example Royal Dutch Shell rather than just Shell. If you can find a SEDOL or ISIN code for the company you can use this to double-check.

Looking for a dead /inactive company, perhaps one that has been taken over in a merger, then things are more tricky.

  • Thomson One Banker will not give you data on dead companies (unless it was active recently)
  • Datastream will give you data. You need to know the last name of the company, and to remember that the default settings of Datastream Navigator are to only to search for active companies.
  • LSPD (London Share Price Database) has details on the name changes of active and inactive UK listed companies, and is therefore a useful resource if you are having problems.

Take the Halifax Building society, which demutualised and floated on the LSE in 1997.  If you search for Halifax in Datastream you will have no luck. However, searching the LSPD names file (lspdN.csv) will give a history of the companies name changes.

LSPD database - names example

This extract from lspdN.csv shows that Halifax plc listed in June 1997 (N1 – 61997), changed its name to Halixfax Group plc, then to HBOS plc, and was taken over (N7 – 5) in Jan 2009 (N2 – 12009) by the company with SEDOL 870612 (N8).  Searching lspdN.csv, or Datastream, will confirm that this is the SEDOL code for Lloyds Banking Group. [ Full details of the columns N1, N2 … are in the LSDP manual. You can also find this information in the LSPD master index file, lspdM.csv. ]

Categories: Business Databases Tags:
  1. markgreenwood
    31 March 2011 at 12:35 pm

    Granada PLC is another example of a UK company where it can be hard to find the historical data. The LSPD names file provides the full history of name changes: Granada Group, Granada Compass, Granada, ITV (and associated sedol changes).

    With the latest name (ITV) and Sedol it is easy to find the company in Datastream. Granada in identified as the previous name (PNAME) changed on 2 Feb 2004. Capital Issues and Changes describes the merger with Compass Group in 2000 and de-merger of Compass Group in 2001, but the name changes themselves are not recorded in Datastream.

    (Bloomberg was more helpful than Datastream in looking for historical data on Granada. It recognised the name “Granada” and provides corporate actions information.)

  1. 7 June 2012 at 11:03 am
  2. 31 October 2012 at 5:53 pm
  3. 11 June 2013 at 12:24 pm
  4. 28 June 2013 at 5:55 pm
  5. 31 October 2014 at 1:16 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.