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.
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hello @afsarleeds,
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
-AHS
Hi @afsarleeds
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
