Eikon Python API Query - How do you get the list of ASX listed stocks which have Company Guidance issued for Fiscal Year 2020?
How do you get the list of ASX listed stocks which have;
- Company Guidance issued for "Revenue" for Fiscal Year 2020
- Company Guidance issued for "EBIT" or "EBITDA" for Fiscal Year 2020
- Company Guidance issued for any measures for Fiscal Year 2020
Once the list is created, the user likes to retrieve all the guidance related fields.
Best Answer
Hi @Naoko.Habe
Get all RIC from ASX
syntax = 'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeMarketIdCode,"XASX"), CURN=USD)' df,e = ek.get_data(syntax, 'TR.RIC') asx_rics = df['Instrument'].tolist() len(asx_rics)
Build a full table of Guidance Measure base on the ASX all RIC:
df2,e = ek.get_data(asx_rics,['TR.GuidanceMeasure','TR.GuidanceText'],
{'Period':'FY2020','GuidMeasure':'REV,EBIT,EBITDA'})
df2.head()
Filter out to answer each of the question:
df2[df2['Guidance Measure']=='Revenue']
df2[df2['Guidance Measure'].isin(['EBIT','EBITDA'])]
