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

Find more posts tagged with

eikon

eikon-com-api

Accepted answers

Alex Putkov.1

@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.html

https://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.

All comments

Alex Putkov.1

=TR("G.M.T=","CF_DATE;CF_TIME")

https://community.developers.refinitiv.com/questions/24672/synchronous-refresh-methods-for-vba-in-excel.html

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.

mgabri

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.png eikon-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

Alex Putkov.1

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.

EXPLORE OUR SITES