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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

john.pilbeam avatar image
2 1 1 2

Keyword search across multiple company Filings (FIL)

I need to search for a keyword in the filings of multiple companies (example search in Eikon Web below). Is this possible via the Python API? If so, what is the syntax for setting this up in Jupyter Notebook? Thanks.

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikondatacompany
10 |1500

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

jason.ramchandani01 avatar image
7.4k 10 6 8

Hi @john.pilbeam - you could try using the NEWS monitor app to generate the queries you want from news - which does include filings. Then use the get_news_headlines API call to gather the list of filings - each of which has a storyID field which you use to request the actual story with a second API call to get_news_story.

df1 = ek.get_news_headlines("Topic:FILING AND R:VFC.N", count=100)
for idx, storyId in enumerate(df1['storyId'].values):  #for each row in our df dataframe
    newsText = ek.get_news_story(storyId) #get the news story
    If newsText:
        #then do something

You can further narrow down the universe of filings by invoking addition query terms in the news monitor app and then adjusting the query you pass to get_news_headlines API call.

I have an article on this here: https://developers.thomsonreuters.com/article/introduction-news-sentiment-analysis-eikon-data-apis-python-example

10 |1500

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

Zhenya Kovalyov avatar image
4.6k 26 7 22

@john.pilbeam this is not possible, as the filtering is done on the app level, rather than the API level

10 |1500

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