question

Upvotes
Accepted
31 2 4 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.

Upvotes
Accepted
31 2 4 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
82.5k 278 53 77

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