Downloading company research headlines using API

Hi,


I am new to Eikon Data Api, and I am using it on R studio in a Windows 11 environment.


I am trying to search company reports in the Advanced Research Search (New) app library, and my searching criteria is: 1) Country = US, 2) Report type = Company, 3) Date = All. This gives me 25,618 total reports, and there is an option allows me to "export the selected headlines to an excel", as shown in the screenshot. The excel will summarize the company ticker, report date, analyst name, etc, which is exactly what I need.

eikon-screenshot-small.png

However, this page only allows selecting files on the same page, and the maximum selection is therefore 200. I don't want to manually do this for every page, and therefore wonder if I could download the headlines to a single excel using Eikon data api. I wonder if any of you could help me with the code? What should I do after:


library(eikonapir)

eikonapir::set_app_key("# my api key")


Thank you so much for your help! Wish you a wonderful weekend.

Best Answer

  • @eikon0000 Thanks for your questions - unfortunately we dont deliver company research report release headlines via API in Eikon/Workspace. We do however provide curated. research roundups from Reuters News:

    import refinitiv.data as rd
    rd.open_session()
    rd.news.get_headlines("Source:RSCH OR Report:RCH/EUROPE", count=100)

    1726845792776.png

    I notice you are using the eikonapir package - this is an older package that is not being actively maintained. There is a newer r wrapper that is being kindly maintained by a customer who kindly open sourced it here.

    I hope this can help.

Answers

  • Hi Jason, thanks for your advice! I will definitely try the new package. I understand that unfortunately we do not have access to headlines via API, but can we do it in a different way, that I use api to access data of the selected columns from the company report search, e.g. date, company ticker, analyst name? I am working on an academic research, that I only need the analyst coverage of firms but not the report details.


    Thanks again and wish you a wonderful weeekend!