I what to know how can I get the Earning Season-like filter on the Eikon API.

pedro.alexandre

I what to know how can I get the Earning Season-like filter on the Eikon API. I want to have the name of the company's that are releasing the earning on a given day.

pedro.alexandre

the correct ansour would be:

df, e = ek.get_data("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/),TR.ExpectedReportDate(Period=FQ1)<"+d1.strftime('%Y%m%d')+"/*dt:Date*/,TR.ExpectedReportDate(Period=FQ1)>="+d0.strftime('%Y%m%d')+"/*dt:Date*/)",['''TR.CommonName;

jonathan.legrand

Hi @pedro.alexandre ,

To find the field names of items such as company names, please use the Data Item Browser as outlined in this video:

https://developers.refinitiv.com/en/video-catalog/data-item-browser

jason.ramchandani01

@pedro.alexandre Thanks so much for taking the time to post the solution back here so the whole community can benefit - the last bit was missing from the end and also d0 and d1 designations - so i just added those here:

d1 = datetime(2021,12,1)
d0 = datetime(2021,8,1)
df, e = ek.get_data("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/),TR.ExpectedReportDate(Period=FQ1)<"+d1.strftime('%Y%m%d')+"/*dt:Date*/,TR.ExpectedReportDate(Period=FQ1)>="+d0.strftime('%Y%m%d')+"/*dt:Date*/)",['TR.CommonName,TR.ExpectedReportDate(Period=FQ1)'])
df

Once again, thanks,