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.
1
●0 ●0 ●0
How can I get time series data for ETF % ownership of individual stocks.
hi
@ronan.cox ,
May I confirm that would you like to use Eikon COM or Eikon Data API (with Python or any other programming language) to retrieve this data?
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
14.2k
●30 ●5 ●10
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
