Getting errors trying to pull in deal data, any idea why?
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
0
●2 ●0 ●5
DSCREEN Query API Error
Hello @scott.curry
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
79.2k
●251 ●52 ●74
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>')
...
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)?
