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

question

Upvotes
Accepted
quetz05 avatar image
1 ●1 ●1 ●1

Get DataState/StreamState in Excel

While using RMDS API in C++ we can get information about StreamState and DataState (included in messages).

Is there any possibility to get analogical data in Excel while using some functions to retrieve real-time data? For example if I would like to retrieve BID and ASK for EUR/PLN=D2 using function RData.

In general we would like to know if data we receive via Excel is valid and have a tool for distinguish no market movement and some connections/data issues. Of course this tool should be fully automatic.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apirefinitiv-realtimedataexcelstream-state
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.

chavalit-jintamalit avatar image   chavalit-jintamalit

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

warat.boonyanit avatar image   warat.boonyanit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

TR/RData functions have this functionality included. When state of the subscription changes, the spreadsheet function will return an error, e.g. #N/A Item Stale.

As for the COM API (rtx.dll), there will be a state change event that you need to subscribe to, that will provide you with the current state (RT_ItemStatus). For more info, have a look at this tutorial.

Here is a list of possible statuses:

 RT_ITEM_OK
 RT_ITEM_INVALID
 RT_ITEM_UNKNOWN
 RT_ITEM_STALE
 RT_ITEM_DELAYED
 RT_ITEM_NOT_PERMISSIONED
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.