Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
18 0 1 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
guidancemeasure.jpg (312.6 KiB)
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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