I have list of CUSIPS for approx 7000 companies and I want to get the Number Of Analysts of these in a historic perspective over severalt years.I have tried different codes but I can't get the date/month/year in the output. How can I manage to do this?
Here's the code I have tried, it just gives the output of 12 in Period Month, I want to have the month and year as output.
fields = ['TR.CommonName', 'TR.NumberOfAnalysts.periodmonth', 'TR.NumberOfAnalysts']
df_eikon_timeseries = ek.get_data(cusips, fields, {'SDate':'2014-01-01','EDate':'2015-12-31','Frq':'M'})
See screenshot.