EIKON excel add-in
Hi Support team,
I am using EIKON excel add-in to extract some measures. I have created C# .net application that opens this excel template and then saves the template. This is done to create excel file on daily basis automatically. This application was working fine from last few months and now it stopped working.
Excel is not updating values. Is there a way to check the status of the EIKON refresh through C# .net code or forcefully refresh data using C# .net.
Basically requirement is to create excel sheet with some measures from EIKON automatically on daily basis. Please advise
Thanks for the help
Regards
Meenakshi
Best Answer
-
@mgabri
There's no generic way you could rely on to check if worksheet functions have updated and returned values. For a specific use case you could develop logic based on say a function in the worksheet that returns current date & time, e.g.=TR("G.M.T=","CF_DATE;CF_TIME")
Compare the values in the cells where the above function returns data to with the current date & time. There's no guarantee however that if the the above function got updated that all the other data retrieval functions got updated as well. To some degree you could manage it by setting Excel calculation mode to manual and force synchronous update. See the following two previous threads for more details.
https://community.developers.refinitiv.com/questions/20247/can-you-please-send-me-the-excel-vba-code-which-ex.htmlhttps://community.developers.refinitiv.com/questions/24672/synchronous-refresh-methods-for-vba-in-excel.html
If you go down this route I suggest you first make sure that Eikon Excel add-in is signed in before refreshing the data. Check out this tutorial.
Or you could check the value in the cells containing data retrieval functions. If the value is a message like "Retrieving..." then the data has not been retrieved by this function.Alternatively you could do all your data retrieval programmatically using Eikon APIs and output the result into a spreadsheet. This way you have full control over data retrieval status.
0
Answers
-
Thanks Alex for the response, I was able to resolve partially. Now the problem I am facing is when I run my program using C# .net through solution EIKON add-ins are in active state and everything works but when I just run my complied exe, EIKON excel-addin remains in inactive state and nothing refreshes. Attached are the 2 screenshots for same. I am using Office excel 365 and Visual studio C# 2013.eikon-exceladd-inproblem.pngeikon-exceladd-incorrect.png
I am open for new solution if any. Like API for .net and if you can provide the sample code.
Looking forward for solution.
Regards
Meenakshi
0 -
You can programmatically manage which COM add-ins are loaded into a session of Excel. For an example of loading Eikon Excel COM add-in see one of the threads below.
https://community.developers.refinitiv.com/questions/41040/eikon-com-addin.html
https://community.developers.refinitiv.com/questions/29464/launch-excel-com-add-in-with-python-win32com.html
If you prefer retrieving data programmatically, the documentation for Eikon COM and .NET APIs including Quick Start guide, tutorials and code samples is available here on Refinitiv Developer Portal. Just follow the links to Eikon COM or .NET APIs.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 33 Data Model Discovery
- 682 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.8K Refinitiv Data Platform
- 625 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 83 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛