FAQ: Cross-listed stocks in Datastream

Background

Datastream makes a difference between primary quotes and non-primary quotes – see the example of Google below. In the column Primary Quote you see: yes or no.  As you can see the ISIN code is the same for these four listings, but the DS Mnemonic, DS Code and SEDOL are different for each listing.

vb google
Searched by: name = google; Status = Active; Instrument type = Equity

Finding cross-listings

When you want to find for example Dutch companies that are cross-listed, use the Advanced Search option in Datastream Navigator:

–          Mark NO behind the field Primary Quote

–          Behind Market enter Netherlands

In the output you’ll see the cross-listings. Of course you can also use other search criteria, like exchange.
To get the corresponding primary listings: use the ISIN-codes of the cross-listings in a Static Request in Datastream and request the name, exchange, DS Mnemonic, DS Code and SEDOL (Datatypes: NAME,EXNAME,MNEM,DSCD,SECD) – this will give the information for the primary listing.

Is a stock cross-listed?

When you already have a list of identifiers and you want to know if there are currently cross-listings, there is another option in Datastream. Use a Static Request and request the datatype QTEALL.
(Related Country Quotes – this is the definition:  This composite static datatype provides all listing details for a security.  Dead and non-research quotes are excluded.  For each related quote, the following items are returned:
CD01     Datastream code
MN01   Datastream mnemonic
MJ01    Major security flag (Y or N)
PQ01    Primary quote (Primary or Secondary)
MK01   Exchange of quote
GL01    Country of exchange
Up to 20 quotes can be displayed for each security.)

This is an example of the results for the companies in the AEX-index (only showing the first two listings, the maximum number of listings in this example is 8, for AccelorMittal):

AEX QTEALL

When you use the datatype QTDALL, also the inactive quotes are shown. The maximum number of quotes is still 20.

Advertisements

4 thoughts on “FAQ: Cross-listed stocks in Datastream

  1. When I download H:RDSA(VO) for example, will that give me the volume for the main trading platform or an aggregate volume?

    • According to the definition of VO (turnover by volume):
      “”For stocks, which are traded on more than one exchange within a country, default volumes are taken from the primary exchange of that country (note that this is not necessarily the ‘home’ exchange of the stock)….The exception is for US listed shares where volumes are consolidated across all exchanges on which a share is listed.”
      So in this case you get the VO only for the Euronext Amsterdam.

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