Datastream makes a difference between primary quotes and non-primary quotes – see the example of Google below. In the column Primary Quote you see a yes or a 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.
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):
When you use the datatype QTDALL, also the inactive quotes are shown. The maximum number of quotes is still 20.