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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
27 1 2 6

How to retrieve constituents of a fund via Eikon Data API?

How can I retrieve constituents of a fund via Eikon Data API?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
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.

1 Answer

Upvotes
Accepted
707 2 1 1

@hiroko.yamaguchi1 ,

I believe you mean fund's full holdings data. Below is a sample.

import refinitiv.dataplatform.eikon as ek
import pandas as pd

ek.set_app_key('<your app key>')

fund_holdings = ek.get_data('LP40065886', ['TR.FundHoldingRIC','TR.FundHoldingName',
        'TR.FundPercentageOfFundAssets',
        'TR.FundNumberOfShares',
        'TR.FundNumberOfSharesChanged'],
        {'Endnum':'5000'})

pd.set_option('display.max_rows', 20000)
print(fund_holdings)

Notes, 'LP40065886' is the fund's RIC ('LP' followed by Lipper ID).


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.

Many thanks, @b.lee ! I could retrieve the data what I wanted to retrieve. Is there any why to retrieve the data in not tuple but in dataframe so that I can easily manipulate the data?
I figured it out!
Click below to post an Idea Post Idea