Scrolling news in Excel?
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
Best Answer
-
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.
0
Answers
-
@Alex Putkov. Thanks Alex. Please see attached spreadsheetnews.zip
0 -
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.zip0 -
@Alex Putkov. this is perfect. Thank you for the help!
0 -
@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
0 -
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.0
-
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?
0 -
There is no way to use this spreadsheet in 64-bit Excel. No way at all.1
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛