Is it possible to download events info using Eikon API on an exchange and event type basis instead of for a single company?
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
1
●0 ●0 ●1
Is it possible to download events info using Eikon API on an exchange and event type basis instread of for a single company?
14.4k
●30 ●5 ●10
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
- 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
- Put the RICs list into a python list
rics_list = df['Instrument'].tolist()
- 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.
