How to get interest rate by ELEKTRON_DD API

muweijia
muweijia Newcomer
in EMA

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.


Tagged:

Best Answer

  • umer.nalla
    umer.nalla LSEG
    Answer ✓

    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.


Answers

  • chavalit-jintamalit
    chavalit-jintamalit admin

    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.

    image


    2. Retrieve the fields on Eikon Data APIs

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

    image

  • muweijia
    muweijia Newcomer
    https://community.developers.refinitiv.com/discussion/comment/50174#Comment_50174

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


    image


    image

  • chavalit-jintamalit
    chavalit-jintamalit admin

    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:

    image


    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)

Categories