How do you get the list of ASX listed stocks which have;
Once the list is created, the user likes to retrieve all the guidance related fields.
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'])]