question

Upvotes
Accepted
torben1 avatar image
31 ●2 ●3 ●6

Error code 412 | Unable to resolve all requested identifiers in ['0#.STOXX'].

When trying to retrieve Joiner and Leaver data for STOXX I get the RDError 412: Unable to resolve all requested identifiers in ['0#.STOXX'].

I used this program in jupyter notebook:

rd.open_session()
sdate = "0D"
edate = "1980-01-02"
ic_l = "L"
currency = "EUR"
fields_jl = ["TR.IndexJLConstituentRIC", "TR.IndexJLConstituentChangeDate",\ "TR.IndexJLConstituentChangeDate.change"]
uni_euro = "0#.STOXX"
response = fundamental_and_reference.Definition(
universe = uni_euro,
fields = fields_jl,
parameters = {"Sdate": sdate, "EDate": edate, "IC": ic_l}
).get_data()


The parameters are the same as I worked in Refinitiv Workspace Excel and there it worked.
What is wrong?

#technologyrdp-apifundamental-data
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.

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

2 Answers

· Write an Answer
Upvotes
Accepted
torben1 avatar image
31 ●2 ●3 ●6

I checked it and found the error: in Excel I use ".STOXX" instead of "0#.STOXX".

With this for the index it also works with the API!

1689852519569.png

Thank You for Your hint!



1689852519569.png (161.0 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
Jirapongse avatar image
79.2k ●251 ●52 ●74

@torben1

Thank you for reaching out to us.

I got the "Unable to resolve all requested identifiers" error when running the following formula in Eikon Excel.

=@TR("0#.STOXX","TR.IndexJLConstituentRIC;TR.IndexJLConstituentChangeDate;TR.IndexJLConstituentChangeDate.change","SDate=0D EDate=2021-01-01 CH=Fd RH=IN",B2)

1689840854248.png

Please share the formula that you are using in Refinitiv Workspace Excel.


1689840854248.png (12.9 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.

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.