Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
0 2 0 5

DSCREEN Query API Error

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


1699977369886.png

eikon-data-apipythonworkspaceworkspace-data-api#technologyapi
1699977369886.png (56.7 KiB)
icon clock
10 |1500

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

Upvote
Accepted
80k 257 52 75

@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:

1700045255785.png

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>')
...



1700045255785.png (33.7 KiB)
icon clock
10 |1500

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

Upvotes
0 2 0 5

Thank you! This worked.


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

icon clock
10 |1500

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

@scott.curry

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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