How can I get time series data for ETF % ownership of individual stocks.

ronan.cox

Hi All, How can I get time series data for ETF % ownership of individual stocks. I can find this data on the fund ownership summary data but only for the latest filing date. I also want to collect this data on the SP500 so ideally I would be able to collect this information for all 503 stocks at once rather than doing so individually. For example apple is owend by 7% ETFs.

raksina.samasiri

hi @ronan.cox ,

In case you'd like to use the Eikon Data API with Python to retrieve this data,

Regarding the answer in this thread

Is this what you're looking for?

cols1 = ['TR.ETPConstituentRIC',
       'TR.ETPConstituentName',
       'TR.ETPConstituentShares.date',
       'TR.ETPConstituentShares',
       'TR.ETPConstituentWeightPercent']

df1, e = ek.get_data('.SPX',cols1, {'SDate':'2020-02-04'})
df1