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
lanzani.juli avatar image
3 ●0 ●0 ●3

Data retrival for delisted ETFs

Hi Team,


trying to get benchmark name and ric for several ETFs (using their respective rics).

The following code works perfectly for listed/ active ETFs:

fields = ["TR.FundBenchmarkName", "TR.FundBenchmarkType", "TR.FundBenchmarkInstrumentRIC"]
ric = "SPY"
benchs = rd.get_data(ric, fields=fields)


However, for all delisted/ liquidated ETFs usually no data is returned or is missing, e.g., ric = "AAIT.O^H15"


I wasn't able to make it work using the search function if that would be an alternative [rdp.search()]


Is there any way to retrieve that data using the python API?

workspace#technologypython apihistoricalrefinitiv-data-librariesetf
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.

3 Answers

· Write an Answer
Upvotes
Accepted
aramyan.h avatar image
7k ●18 ●2 ●8

posting the response from the content team for reference -


Note:- It extracts the data for delisted RIC, but in this example, AAIT.O^H15, there is no Fund Manager benchmark index is mapped. If any index is fees liable index, we don't map Fund benchmark details to any ETF/Funds.

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
aramyan.h avatar image
7k ●18 ●2 ●8

Hi @lanzani.juli ,


I have raised a content query (case id- 13628947) on your behalf, you will receive an email shortly.


Best regards,

Haykaz

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
bob.lee avatar image
1.7k ●3 ●3 ●4

Hi @lanzani.juli , Your sample functions are using contents from Lipper (i.e. TR.Fundxxxxx), but from Lipper's perspective (i.e., data from fund companies, not exchanges), the "non-active" funds (liquidated and merged) funds currently are not supported on the Workspace platform. Liquidated and merged funds (historical data) are supported on Lipper Funds API and other Lipper products/services.

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.