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.
1
●1 ●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).
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
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.
