Eikon Python API Query - How do you get the list of ASX listed stocks which have Company Guidance issued for Fiscal Year 2020?

Question

REFINITIV

Question by Naoko.Habe · Jul 28 at 08:17 AM · python python api python eikon

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.

guidancemeasure.jpg (312.6 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2020-07-29T03:08:48Z

REFINITIV

Best Answer

Answer by chavalit.jintamalit · Jul 29 at 03:08 AM

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)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

Eikon Python API Query - How do you get the list of ASX listed stocks which have Company Guidance issued for Fiscal Year 2020?

1 Reply

Watch this question

Related Questions