Home > Business Databases, News & Feedback > Industry/sector codes in Datastream

Industry/sector codes in Datastream

Update Oct 2013 – Datastream variables for GICS (Global Industry Classification Standard) added.

Researchers often want to select companies based on their industry or sector.

There are a variety of systems for classifying industries/sectors: SIC codes, ICB codes, GICS codes … For more detail see post on Industry classification codes.

This Datastream AFO sheet shows a static request to get a variety of industry/sector codes.

Datastream - industry/sector codes

Datastream industry/sector codes

Datastream variables:

  • WC07021 – SIC1, SIC primary code from Worldscope
  • WC07040 – ICB, ICB code from Worldscope
  • ICBIC, ICBIN – ICB industry code and name
  • INDG, INDM – Datastream level 6 industrial classification number and name
  • TR1, TR1N – TRBC (Thomson Reuters Business Classification) economic sector code and name
  • MSCISC, MSCSIC – MSCI Sector and Sub-Industry GICS codes
    (The GICS Direct codes give “not available” as these are not part of the University of Manchester Datastream subscription.)

Note: This is not a complete list of all industry/sector codes available in Datastream.

Thomson Reuters Business Classification (TRBC)  Quick Guide – for background and methodology see http://financial.thomsonreuters.com/trbc

The Datastream results illustrated above were created using a company sector codes Datastream request table – see Datastream Request Table post for more information.

Advertisements
  1. Giuly
    30 October 2015 at 12:26 pm

    Using datastream, how can I find the SIC code for each company?
    thanks
    Giuly

    • Mark Greenwood
      2 November 2015 at 12:50 pm

      Industry codes are static (i.e. only one value) so you need to use a Datastream Static request, rather than a time series request. I’d recommend doing a test request with smaller constituent list (e.g. LFTSE100 ) before trying to get results for a large list of equities/companies.
      If you want to include your static request in a DS request table see – combine-a-static-request-into-a-time-series-request-in-datastream/ and datastream-request-table/

      The primary SIC code is available as variable WC07021 – other secondary SIC codes are also available.
      Note:
      SIC code WC07021 is part of Worldscope and so will only be available for equities/companies covered by Worldscope.
      SIC codes come in US and UK versions – I think Worldscope uses the US one but check the definition to be on the safe side.

  2. animator
    9 November 2015 at 1:54 pm

    Hi Mark,

    Thank you very much for all your useful tips on this website. I would like to ask the following question and hope there will be good comments on it. Worldscope accessed through Datastream has two different datatypes:

    1) SIC code 1, SIC code 2, SIC code 3, SIC code 4, SIC code 5, SIC code 6, SIC code 7, SIC code 8.

    2) Product segment 1 – SIC code, Product segment 2 – SIC code, Product segment 3 – SIC code and so until Product segment 10 – SIC code.

    How are these two different?

    Thank you

    • Mark Greenwood
      10 November 2015 at 2:15 pm

      You should check the Worldscope Data Definitions Guide (see Worldscope posts for access details)
      1) The SIC codes 1 to 8 are part of the company header information, static data items so only current/latest values are available.
      2) The Product segment SIC codes are part of the product segment data. This may only be available for companies that report multiple product segments in their accounts. However, where it is available you should be able to get annual time series data.

      • Yerzhan
        25 February 2016 at 5:47 pm

        Hi Mark,

        Thank you for your comment. I have now another question on SIC codes in Thomson One. As you said previously SIC codes in Worldscope accessed through Datastream are only current/latest values. How about Acquirer Primary SIC code/Acquirer SIC codes and Target Primary SIC code/Target SIC codes in data downloaded from Thomson ONE (previously known as SDC). Are they given for that year when acquisition was announced or also current/latest values as in Worldscope?

        Thank you

  3. XiaHong
    8 March 2016 at 4:35 pm
  4. XiaHong
    8 March 2016 at 5:16 pm

    Hi Yerzhan,

    The SIC codes assigned to the Acquirer or Target in the SDC database (or ThomsonOne.com deal) are the SIC codes used at the time of the transaction.

    Best wishes!
    Xia

  1. No trackbacks yet.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s