DSCREEN Query API Error

scott.curry

Getting errors trying to pull in deal data, any idea why?

Find more posts tagged with

python

api

workspace

eikon-data-api

workspace-data-api

#technology

Accepted answers

Jirapongse

@scott.curry

Thank you for reaching out to us.

The following code is easier to read.

df, err = ek.get_data('SCREEN(U(IN(DEALS)), relativedate(TR.MnAAnnDate,LQ), IN(TR.MnAStatus,"W","SW","IW","DR"), CURN=USD)',
                     fields=["TR.MnASDCDealNumber","TR.MnAAnnDate","TR.MnARankDate"])
df

The output is:

If you still get the same error, please run the following code to enable logging.

import eikon as ek
ek.set_log_level(1)
ek.set_app_key('<app key>')
...

All comments

Jirapongse

@scott.curry

Thank you for reaching out to us.

The following code is easier to read.

df, err = ek.get_data('SCREEN(U(IN(DEALS)), relativedate(TR.MnAAnnDate,LQ), IN(TR.MnAStatus,"W","SW","IW","DR"), CURN=USD)',
                     fields=["TR.MnASDCDealNumber","TR.MnAAnnDate","TR.MnARankDate"])
df

The output is:

If you still get the same error, please run the following code to enable logging.

import eikon as ek
ek.set_log_level(1)
ek.set_app_key('<app key>')
...

scott.curry

Thank you! This worked.

How can I specify a date range using this API, rather than using relativedate(TR.MnAAnnDate,LQ)?

Jirapongse

@scott.curry

Please try this one: BETWEEN(TR.MnAAnnDate,20221116,20231116).

EXPLORE OUR SITES