Is it possible to download events info using Eikon API on an exchange and event type basis instre...

KennethCedric.Gonzales

...ad of for a single company?

Is it possible to download events info using Eikon API on an exchange and event type basis instead of for a single company?

raksina.samasiri

hi @KennethCedric.Gonzales ,

You may consider using a formula exported from the SCREENER app to retrieve the company list in each exchange then use Eikon get_data function to retrieve event of these company, then filter an event type in the output dataframe with python code, for example

1. Use the SCREENER app to retrieve a list of company with the country of exchange is the Philippines (for more detail, please check article Find Your Right Companies with SCREENER | Eikon Data APIs(Python))
   

   df, err = ek.get_data('SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,"PH"), CURN=USD)'
                         ,['TR.CommonName','TR.ExchangeCountry'])
   df
   

2. Put the RICs list into a python list

   rics_list = df['Instrument'].tolist()

3. retrieve events of these companies using the code below

   event_df, err = ek.get_data(rics_list
                         ,['TR.CommonName','TR.EventStartDate','TR.EventType','TR.EventTitle'])
   event_df

Please let me know in case you have any further questions.

raksina.samasiri

https://community.developers.refinitiv.com/discussion/comment/92662#Comment_92662

here's an output of the third step