How can I pull information via the EIKON API without the use of a monitor?

Dear Sir/Madam,

Currently I am trying to pull data from Reuters via the EIKON API. In short my question is, how can I pull information (list of all current Dutch ISINs) via the EIKON API without creating a monitor that has all this information.

Thank you in advance.

Find more posts tagged with

python

eikon

isin

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

@s.vermeer the only option that is available to you is to execute a screener query. For example, all companies that have HeadQuarters in Netherlands:

df, e = ek.get_data('SCREEN(U(IN(Equity(active,public,primary))), IN(TR.HQCountryCode, NL), CURN=USD)', 'TR.ISIN')

All comments

Zhenya Kovalyov

@s.vermeer the only option that is available to you is to execute a screener query. For example, all companies that have HeadQuarters in Netherlands:

df, e = ek.get_data('SCREEN(U(IN(Equity(active,public,primary))), IN(TR.HQCountryCode, NL), CURN=USD)', 'TR.ISIN')

s.vermeer

Dear Zhenya,

Thank you for your helpful response to my question. So far this worked for me.

I am currently trying to find a variable/column that displays the type of the instrument. The variable "Instrument Type Description" is the most complete when it comes to showing the instrument type. Unfortunately this "Instrument Type Description" is not unambiguously as it uses for example "Dutch State Loan" and "Bond" together, which are the same instrument. Are there perhaps other variables that show precisely what I want to know, without using synonyms?

Thank you in advance.

Alex Putkov.1

Try "TR.AssetCategory". If this doesn't give you what you're looking for, I suggest you contact Refinitiv Helpdesk. This forum is aimed at software developers using Refinitiv APIs. The moderators on this forum are not the best content experts. Content questions that are not specific to the use of APIs are best directed to Refinitiv Helpdesk, which does have or can reach out to the experts on every bit of content available through Refinitiv products.

s.vermeer

Thanks for your response @Alex Putkov . I will take my second question to the Refinitiv Helpdesk.

EXPLORE OUR SITES