Eikon Python API Query - How do you get the list of ASX listed stocks which have Company Guidance...

Naoko.Habe

... 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.

chavalit-jintamalit

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'])]