Home > company information > All French listed companies in 2002 (Datastream)

All French listed companies in 2002 (Datastream)

In fuller response to a comment on Finding inactive/dead companies on Datastream (posted Feb 2012)

Although it is good for worldwide historic company data, Thomson Reuters Datastream does not give a quick way of getting a historic list for all companies from a specific country.

DSworldscopeFranceFor all French companies listed in 2002 we can use the Worldscope French company list (WSCOPEFR) since worldscope will cover French companies by 2002.

For WSCOPEFR we do a static request including:

  • ESTAT – company status
  • BDATE – base date
  • TIME – latest valid price data
  • EXDSCD – exchange code
  • MAJOR – major security for company
  • ISINID – primary quote

Using the results we filter to get companies listed in 2002

1837 – original Worldscope France list (WSCOPEFR)

1503 – removing companies that died before 2002, TIME < 01 Jan 2002

1015 – removing companies that listed after 2002, BDATE > 31 Dec 2002

You might want to further trim the list: only companies listed on the Paris exchange (EXDSDC = PR), only equities (TYPE = EQ), or only major securities (MAJOR = Y).

reviewing French companies 2002 (click to expand)

reviewing French companies 2002 (click to expand)

Rather that using the Worldscope list as a starting point you could use the Datastream lists FFRA (Active French companies) and DEADFR (Dead French companies), or do an explicit criteria search in Datastream Navigator.

All UK listed companies (part 3) (posted June 2013) gives details of the different approaches for the UK market. The first question about “all French companies” is – all companies with their primary listing on the Paris exchange, or all companies headquartered/registered in France whereever they are listed, or all French registered companies with their primary listing  in Paris.

Advertisements
Categories: company information Tags:
  1. No comments yet.
  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