For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Naoko.Habe avatar image
18 ●0 ●0 ●1

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.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
guidancemeasure.jpg (312.6 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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



ahs.png (31.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea