question

Upvotes
Accepted
sjh0724 avatar image
11 ●0 ●2 ●4

How to find symbols of specific item

I am trying to get Symbols (such as Mnemonic, RIC, and/or ISIN) of items that I am specifically searching for with keywords (e.g. Apple, Amazon, Google, etc) with Datastream Python API. Is there any way to get such information as a dataframe?

Also, in the above question, I am looking for that specific item. But, if search gives more results (such as Apple Credit, Apple Rush when I search for Apple), is there also a way to get all these items and their info as dataframe (as in DFO Navigator result format)?

pythondatastream-apidsws-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@sjh0724

You can use the DS.SYMBOLLOOKUP data type to find symbols.

The python code looks like:

df = ds.get_data(tickers="Apple", fields=["DS.SYMBOLLOOKUP"], kind=0)
df

The result is:


1587109819229.png (18.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

sjh0724 avatar image sjh0724

Thank you so much :) And also, I would like to know data type for getting RIC, ISIN, CODE, MNEMONIC.

Click below to post an Idea Post Idea