question

Upvotes
Accepted
1 0 0 0

How to get interest rate by ELEKTRON_DD API

hi,I used to get currency by ELEKTRON_DD, and now we also buy interest rate service. when I tried to change currency code(CNYUSD=R) into interest rate code (USDONFSR=) What it returns is NaN (empty) for all fields.


eikon-data-apielektronrefinitiv-realtimeelektron-sdkrrtema-apielektron-message-api
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
20.3k 73 10 20

Hi @muweijia

Looking at your code snippets etc, you say that when you change the RIC you no longer get any data back.

Are you logging/outputting any StatusMsg to the console or log file?

It could be that you are not entitled / permissioned for the different RICs and in which case you would get a StatusMsg back communicating this to you. The StautsMsg is handled by the onStatusMsg callback you define in your OmmConsumerClient implementation.

If you are not sure, then as recommended by my colleague, you should run a simple example like example100 with the different RICs and see if you get any data or status msg.


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

Hi @muweijia

I would like to clarify that you are using Eikon Data API (Python) ?

If so you can follow this sample code to find field you are interested and and use Eikon Data APIs to retrieve them.

1. Use DIB to find any fields.


2. Retrieve the fields on Eikon Data APIs

In this sample, I request for CF_BID and CF_LAST fields.


ahs.png (167.4 KiB)
ahs1.png (6.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.

sorry...I am using Eikon Data API (java) .and my code are as follows



1570774968345.png (157.7 KiB)
1570775151131.png (64.9 KiB)
Upvotes
18k 21 12 20

Hi @muweijia

So you are using Elektron Messaging API (EMA) (Not Eikon Data API).

I moved this question to EMA Java forum.

I strongly advise you to look at the example series 100

\Elektron-SDK1.2.2.java.rrg\Java\Ema\Examples\src\main\java\com\thomsonreuters\ema\examples\training\consumer\series100\example100__MarketPrice__Streaming

Here is the sample code:


Here is the refresh message:

You have to know which field you are looking for (Maybe BID and TRDPRC_1 ?)

RefreshMsg
    streamId="5"
    domain="MarketPrice Domain"
    solicited
    RefreshComplete
    state="Open / Ok / None / 'All is well'"
    itemGroup="00 01"
    permissionData="03 01 01 34 20 c0"
    name="USDONFSR="
    nameType="1"
    serviceId="257"
    serviceName="ELEKTRON_DD"
    Payload dataType="FieldList"
        FieldList FieldListNum="92" DictionaryId="1"
            FieldEntry fid="1" name="PROD_PERM" dataType="UInt" value="3420"
            FieldEntry fid="2" name="RDNDISPLAY" dataType="UInt" value="153"
            FieldEntry fid="4" name="RDN_EXCHID" dataType="Enum" value="214"
            FieldEntry fid="6" name="TRDPRC_1" dataType="Real" value="1.79263"
            FieldEntry fid="7" name="TRDPRC_2" dataType="Real" value="1.79"
            FieldEntry fid="8" name="TRDPRC_3" dataType="Real" value="1.8055"
            FieldEntry fid="9" name="TRDPRC_4" dataType="Real" value="1.80825"
            FieldEntry fid="10" name="TRDPRC_5" dataType="Real" value="1.82075"
            FieldEntry fid="22" name="BID" dataType="Real" value="1.79263"
            FieldEntry fid="23" name="BID_1" dataType="Real" value="1.79"
            FieldEntry fid="24" name="BID_2" dataType="Real" value="1.8055"
            FieldEntry fid="53" name="TRD_UNITS" dataType="Enum" value="5"
            FieldEntry fid="115" name="BID_TICK_1" dataType="Enum" value="1"
            FieldEntry fid="259" name="RECORDTYPE" dataType="UInt" value="241"
            FieldEntry fid="270" name="ACT_TP_1" dataType="Enum" value="26"
            FieldEntry fid="271" name="ACT_TP_2" dataType="Enum" value="27"
            FieldEntry fid="272" name="ACT_TP_3" dataType="Enum" value="27"
            FieldEntry fid="393" name="PRIMACT_1" dataType="Real" value="1.79263"
            FieldEntry fid="394" name="PRIMACT_2" dataType="Real" value="1.79"
            FieldEntry fid="395" name="PRIMACT_3" dataType="Real" value="1.8055"
            FieldEntry fid="728" name="BCAST_REF" dataType="Rmtes" value="INT-US"
            FieldEntry fid="825" name="CROSS_SC" dataType="Enum" value="0"
            FieldEntry fid="831" name="CTBTR_1" dataType="Rmtes" value="IBA"
            FieldEntry fid="836" name="CTB_LOC1" dataType="Rmtes" value="LON"
            FieldEntry fid="875" name="VALUE_DT1" dataType="Date" value="10 OCT 2019"
            FieldEntry fid="876" name="VALUE_DT2" dataType="Date" value="09 OCT 2019"
            FieldEntry fid="877" name="VALUE_DT3" dataType="Date" value="08 OCT 2019"
            FieldEntry fid="995" name="GEN_TEXT16" dataType="Rmtes" value="10/10/19"
            FieldEntry fid="1000" name="GV1_TEXT" dataType="Rmtes" value="FIX   "
            FieldEntry fid="1001" name="GV2_TEXT" dataType="Rmtes" value="USD"
            FieldEntry fid="1003" name="GV4_TEXT" dataType="Rmtes" value="ON"
            FieldEntry fid="1010" name="VALUE_TS1" dataType="Time" value="10:55:04:000:000:000"
            FieldEntry fid="1011" name="VALUE_TS2" dataType="Time" value="10:55:04:000:000:000"
            FieldEntry fid="1012" name="VALUE_TS3" dataType="Time" value="10:55:04:000:000:000"
            FieldEntry fid="1080" name="PREF_DISP" dataType="UInt" value="0"
            FieldEntry fid="1275" name="GN_TXT32_1" dataType="Rmtes" value="(blank data)"
            FieldEntry fid="1383" name="DSO_ID" dataType="UInt" value="16416"
            FieldEntry fid="3263" name="PREV_DISP" dataType="UInt" value="0"
            FieldEntry fid="3364" name="MPV" dataType="Enum" value="(blank data)"
            FieldEntry fid="5357" name="CONTEXT_ID" dataType="Real" value="3016.0"
            FieldEntry fid="6401" name="DDS_DSO_ID" dataType="UInt" value="12403"
            FieldEntry fid="6480" name="SPS_SP_RIC" dataType="Ascii" value=".[SPSLIBL1"
        FieldListEnd
    PayloadEnd
RefreshMsgEnd


To iterate on field on the message, you can take a look at example number 120 (MarketPrice_FieldListWalk)


ahs.png (51.8 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