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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

etf live market data and eod holdings

I need to use Eikon DATA API to extract live market data for etfs other funds and also their holdings as specified in the pictures. I wonder if anyone can help to identify available functions in api for this task. I have seen a post on month-end holdings for etfs here. I appreciate your help.


eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonetf
screenshot-39-li.jpg (236.5 KiB)
screenshot-37-li.jpg (173.5 KiB)
icon clock
10 |1500

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

Upvotes
Accepted
18k 21 12 20

Hi @afardgmx

I suggest that you use "CODE CREATOR" to explore the data field.

You can type in "CODECR" on Eikon Search Bar and press enter to launch the "CODE CREATOR"

Then you can add fields that you want to the Python code builder.

Once done, you can copy the code out and test it.


If you cannot find the fields, you can contact The Refinitiv Content Helpdesk to clarify the field name.

The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/


ahs.png (150.9 KiB)
ahs2.png (53.4 KiB)
icon clock
10 |1500

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

Upvotes
1 0 0 0

Thanks for the provided answer. My Eikon interface look a bit different than the one here and non of dropdowns have those options. Could you share your screen for QLD Proshares ETF? Are you getting daily holding or historical month-end reports, for example. I would be interested in live data and daily holdings. Thank you.

icon clock
10 |1500

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

Upvotes
18k 21 12 20

Hi @afardgmx

I do not know what is the instrument code for PLD Proshares ETF.

So I am using 2845.HK(some ETF in Hong Kong) for demonstration purpose.


You can follow the steps in this GIF image to see the same app as me.

The file is too large to attach to this portal, so I used imgur to host the file.

https://imgur.com/a/Kr000dT



icon clock
10 |1500

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

Upvotes
1 0 0 0

thanks for the instruction. Yes, it goes Lipper Funds > Corporate Action History > Fund Holdings.

As shown in the attachment, this instruction provide details based on the last filing only. However, I would be interested in the current data (updated daily), which are identified in the screenshots of my original post. I wonder if there are functions to extract those information. Thanks.


screenshot-42-li.jpg (196.7 KiB)
icon clock
10 |1500

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

Upvotes
39.2k 75 11 27

@afardgmx

I'm afraid only the latest holdings are available through Eikon APIs. Historical holdings can only be viewed in Eikon application.

icon clock
10 |1500

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

Click below to post an Idea Post Idea