EIKON excel add-in

mgabri
mgabri Newcomer
in Eikon COM

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    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.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.

Answers

Categories