question

Upvotes
Accepted
1 0 1 1

Excel Formula delay

We are able to get real time data using formulas, but the values are being fetched only after the completion of the event which triggers it (say a button click).

Could you please let me know if the any one of the following is feasible?
1. Calculate the Eikon formula and obtain value immediately after setting the formula to a cell.

2. Any way to find if Eikon formula calculation is complete.

eikoneikon-com-apieikon-for-office
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
39.4k 77 11 27

@pratheesh.devarajan

The expected behavior of =TR and other worksheet functions provided by Eikon Excel add-in is that they return the data into the range as soon as the function is validated and the data is retrieved. Moreover, if the Data Item argument of =TR function includes streaming market data fields, the function will update the values of these fields in the range in real time. This is assuming Excel is in auto calc mode. If Excel is in manual calc mode, then the expected behavior is that any worksheet functions, including those provided by Eikon Excel add-in, will only recalculate and update the values in the range when the range containing the function is recalculated.

If you find that Eikon Excel deviates from the expected behavior, please open a support case with Refinitiv Helpdesk. The Helpdesk can be reached by using Contact Us capability in your Eikon application or by visiting MyRefinitiv.

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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