Excel to Eikon apps via Side by Side
I have a client who has an Excel sheet with direct links to Bbg apps which display research, estimates and news. We can achieve this in Eikon by the use of RACE hyperlinks.
HOWEVER, the user is not entirely satisfied, because in his Bbg solution, the links are always pushed to the same window in the same screen position, whereas with RACE, you always get a new window, in a different position - so the screen quickly gets "cluttered" with lots of windows, and since he regularly reviews multiple companies, it is not convenient to be closing windows all the time.
SO, I thought that side by side API might provide a neater solution - unfortunately I don't have any experience with this, and I don't really know where I might start, or even if it's possible to program from Excel to Eikon using SxS.
Alternatively, it might still be possible to use VBA to launch Eikon apps (used to be possible using e.g. koBrowser)... but I don't have any working examples to hand.
Can anyone help? Or make other suggestions?
Best Answer
-
Using SxS API it's possible to do both: launch new instances of Eikon apps and update context in existing apps (either previously launched by application or linked on a color channel). However, updating context in existing apps requires a Websocket client. It's quite likely that customer's machine will not have a COM Websocket client (that could be used in Excel VBA) ready installed. This means that a solution using SxS would require installing and registering a 3rd party ActiveX component on customer's machine. There's a bunch of such components available on the Internet, including some from Microsoft. If customer would be willing to install such component, then this could be an option. Without Websocket client SxS can only launch new instances of Eikon apps. You can try for yourself how this experience compares to launching apps through RACE. I created a quick example you can play with, which I'll send you via email.
There's a couple of things to note about SxS. One is that it only allows to launch a limited number of apps. The full list is available in SxS API documentation here. The other is only relevant to updating context in existing instances of apps (which requires a Websocket client). Managing an SxS session with Eikon is a bit of a challenge, as one needs to handle cases where user may have closed Eikon application or Eikon application may have crashed.XMA Library is still installed with Eikon, but it is no longer registered, which means it's pretty much a dead end. Unless the user is very savvy and willing to register it and maintain the registration. But even in this case I wouldn't recommend using it. It does not allow updating context in existing instances of apps. It only allows one to launch new app instances, which you'd be better off doing using SxS API.
0
Answers
-
Yes, you can use Excel to Open Eikon applications by using SxS API.
I have created a sample Excel which uses VBA to connect to SxS API.
First, you need to have the product ID and application key. You can use App Key Generator in Eikon to create the product ID and application key.
Then, you need to know the application ID of the Eikon application, such as Quote Object, News, and Graph. You also need to know the format of the context used by that application.
After clicking the Button, the quote application will be launched.
You can refer to the SxS page on the Developer portal page.
I don't know the application IDs and contexts of other Eikon applications. For the application ID, you can directly contact the Eikon Support team.
0 -
Thanks Alex and Jirapongse. Sorry I have not responded sooner.
The potential solutions have turned out to be too complex for the end user. The competitor's solution just works out of the box, without any 3rd party software or websocket stuff. So he's not going forward with Eikon...
By the way, I got an error message when running the code: "License information for this component not found.You do not have an appropriate license to use this functionality in the design environment." This occurs on the function CreateObject("MSScriptControl.ScriptControl")0
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 中文论坛