DSWS API - SEARCH FOR COMPANIES AND CODES

afsar
afsar Newcomer
in Datastream

How do I get list of company names, and TR mnemonic code (eg 319608 for Astrazeneca)? I would like define my list as either matching a partial string search (eg *zenec*), specific stock exchange (eg LON)?

I know how to get a list based on an index (eg LFTSE100), but its the other two search options I'm struggling with. Any help would be greatly appreciated.

Tagged:

Best Answer

  • paul.bacon
    paul.bacon LSEG
    Answer ✓

    image

    Hi @afsar

    There is a basic search within DSWS that will allow a short response back based on a partial name search, i believe it only pulls back the top 5 responses across all content sets.

    This can be done in a snapshot request with the value being the word you are searching on and the datatype being DS.SYMBOLLOOKUP.

    You can restricted the response back to a category for example Equities

    DS.SYMBOLLOOKUP(Category=Equities)


    You can also change the default of 5 series being returned to a different number

    DS.SYMBOLLOOKUP(Count=20)

    It does have limits so for example if you used "Astraz" then you will get back Astrazeneca but just "zenica" will fail.

    The only way to get a list of all instruments on an exchange is either to use an exchange list for UK (I would recommend FBRIT) or use Navigator directly and create a list from their using the filters on the left hand side

    Regards

    Paul

Categories