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