Hi all,
I have been using the Refinitiv API to retrieve % Institutional Ownership data, and my current Python script is able to fetch this information on a monthly basis. However, for my analysis, I only need the year-end data for each year.
Here is the code I have written so far:
[Python code]
import pandas as pd
import refinitiv.dataplatform.eikon as ek
df,err=ek.get_data(company_isin,
['TR.CategoryOwnershipPct.date',
'TR.CategoryOwnershipPct',
'TR.InstrStatTypeValue'],
{'StatType':7, 'SDate':'20201231', 'EDate':'20231231'})
[Python code]
The results I get are in monthly intervals. Could someone please advise on how to modify this code to retrieve only the year-end % Institutional Ownership data? Specifically, I am looking for the data at the end of each year (e.g., December 31st).
Thank you in advance for your assistance!
Best regards,
Xiaohan