For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 0 1 6

Excel continuous retrieval of data

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)

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-apiapiexcel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
39.2k 75 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.

createpdf.zip


createpdf.zip (15.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea