Hello, I'm using Eikon on Excel to retrieve live Data. I would like it to refresh and update datas continously even when My excel file(Workbook) is minimized(I'm working on something else or opening some other applications). Because I'm setting a timer on VBA to create a PDF from the excel file, and when I open the PDF I find #VALUE instead of the value(It means that eikon wasn't retrieving the DATA)
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
5
●0 ●1 ●6
Excel continuous retrieval of data
Hello @e-naji,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
39.4k
●77 ●11 ●27
I don't think the #VALUEs you see in the pdf file are a function of Excel being minimized. =TR and =RtGet functions in Eikon Excel continuously update the values returned in Excel worksheets no matter whether Excel is minimized or whether the workbook is active. I think something else must be causing the cells to return #VALUE at the time the pdf is created.
Attached is a quick example I created to test this. On my end I always see the values in the pdf created even if Excel is minimized and the workbook is not active.
