question

Upvotes
Accepted
1 4 2 8

How to choose which API "DEX2 CreateRData" or "EikonDesktopDataAPI CreateAdxRtList"

To get Data from Eikon

I'm using "EikonDesktopDataAPI CreateAdxRtList()" for

=RData("JP03420067=","MATUR_DATE","RTFEED:IDN")

I'm using "DEX2 CreateRData()" for

=RData("JP03420067=","EJV.C.MaturityDate",)

And I select which API to use with "Fileds Name " has contains ".".

Is there any one know better way How to select API for fiels?

eikoneikon-com-apirdata
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.

Upvotes
Accepted
38.1k 71 35 53

AdfinX Real-time "EikonDesktopDataAPI CreateAdxRtList()" is used to access real-time data. You can verify fields of real-time data by using Eikon Quote. For example, MATUR_DATE is a field displayed when subscribing to JP03420067= via Eikon Quote.

Therefore, you can use CreateAdxRtList() to access the value of MATUR_DATE.

On the other hand, DEX2 is used to access fundamental data. Normally, Eikon Quote can't access fundamental data.

In conclusion, for all fields displayed in Eikon Quote, you can use CreateAdxRtList() to retrieve the data. For other fields (fundamental data), you need to use DEX2.


matur-date.png (12.5 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.

Upvotes
18k 21 12 20

@SAKAMOTO

Is this the data you are looking for ?

I use "Data Item Browser" on Eikon to search for the field name. (see bottom right of the window)


dex2api.png (18.1 KiB)
dib.png (109.0 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.

I attach the sample code in this post. dex2adcsamplecsharp.zip

Please note that you cannot use Eikon Desktop Data API in App Studio .NET SDK project. However, you can use App Studio WEB SDK to retrieve the same data as mentioned by Zhenya Kovalyov at https://community.developers.refinitiv.com/questions/8206/how-to-get-data-like-ejv-fileds.html#answer-8207

I tested the App Studio WEB SDK with this request:

        var request = {
           "instruments":"JP03420067=",
           "fields":"TR.FIMaturityDate"
         };
                 
         JET.Data("datagrid").then(function (service) {
           service.request(request).then(function (result) {
             console.log(result);
           }, function (err) { console.log(err); });
         });

And this is the result I received:

{"columnHeadersCount":0,"data":[["2026-03-20"]],"rowHeadersCount":0,"totalColumnsCount":1,"totalRowsCount":1}
Click below to post an Idea Post Idea