DSWS API - SEARCH FOR COMPANIES AND CODES

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.

Find more posts tagged with

api

datastream-api

dsws-api

Accepted answers

paul.bacon

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

All comments