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
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
39.2k
●75 ●11 ●27
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.
39.2k
●75 ●11 ●27
I updated the spreadsheet. For now it is able to retrieve and display news headlines. If you need to change the filter expression, I'm afraid it won't be as easy as previously. You would need to add any news codes you'd like to use in the filter expression to the table in the News Codes worksheets that maps user friendly codes like "COM" to cryptic codes like "A:4" published with updates to NFCP_UBMS RIC. Since it looks like the purpose of this spreadsheet is to project news headlines to a wallboard, I'm guessing you don't need to change the filter expression frequently, so this shouldn't be a very big issue.
Let me know how it works for you.
news.zip
1
●0 ●0 ●1
@Alex Putkov.1 is there an easy way to update the new.zip spreadsheet in the thread above to 64bit? I'm getting a Visual Basic compile error, "The code in this project must be updated for use on 64-bit systems". Thanks, Mike
I'm afraid not. The COM library used in the VBA code in this spreadsheet is only available as 32-bit dll, which means it can only be used in 32-bit Excel. The spreadsheet can be used in 32-bit Excel on 64-bit Windows. But it cannot be used in 64-bit Excel.
1
●0 ●0 ●1
Thanks. So there is no way to modify the current code for 64 bit? Would it be possible to rebuild it from scratch using 64-bit Excel? Or can you run it in a compatibility mode?
