Scrolling news in Excel?

michael.bruce
michael.bruce Newcomer
in Eikon Data APIs

I have an excel sheet that pulls news headlines from Eikon and scrolls the news headlines from the top of the Excel page to bottom as news stores come in. It just stopped working about 2 weeks ago. It looks like the Excel sheet uses a macro to pull in the new stories. I don't know who built it. I don't see any errors. Refinitiv Eikon is online and pulling data. I reached out to Eikon customer support and they told me to come here and ask for help. Thanks

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    @michael.bruce

    I think that most likely the spreadsheet used to retrieve news headlines using the RIC N2_UBMS, which has been retired. The VBA code in the spreadsheet needs to be updated to use the RIC NFCP_UBMS. Some field names and perhaps the filtering logic may also need to be updated. If you post the spreadsheet on this thread (put it in a zip file and attach it to your post), I can take a look and update it. But given that no one owns this spreadsheet, you may want to consider alternative solutions, as software not owned by anyone may stop working at any time, and you may not be able to fix it.

Answers

Categories