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.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
336
●0 ●0 ●1
I what to know how can I get the Earning Season-like filter on the Eikon API.
336
●0 ●0 ●1
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;
@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,
1.4k
●6 ●2 ●2
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
