How to convert RIC to Mnemonic?

federico.fontana
federico.fontana
in Eikon Data APIs

I've retrieved a set of static metadata associated with a large list of instruments using Eikon Scripting API. I now want to obtain the time series associated with these ETFs and indices using Datastream (DDL with FTP). However, DDL only accepts mnemonic as identifiers so I cannot provide RICs.

Question: How to convert RIC (for example .dMIJP00000NUS) to Mnemonic?

Attempt: I've explored the Data Item Browser in Eikon Scripting API but I haven't found any data item code associated with the instrument mnemonic.

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    You can use Datastream add-on to Eikon Excel. If you don't see Thomson Reuters Datastream tab in Excel ribbon, select Thomson Reuters tab, click on Add-ons button in the Options group in the ribbon and in the pop-up dialog box click Enable button against Datastream add-on. After you restart Excel you should see Thomson Reuters Datastream tab in Excel ribbon, and you can use the following worksheet function:
    =DSGRID(".dMIJP00000NUS","MNEM","Latest Value","","","Sym=RIC")
    Since you have a large list of instruments you'd want to use cell references instead of referencing the RIC as a string in the formula.
    I hope this helps.

Answers

  • federico.fontana
    federico.fontana

    Somehow, it seems that your solution does not work with several RICs. For example, =DSGRID(".DJI","MNEM","Latest Value","","","Sym=RIC") for Dow Jones works but =DSGRID(".SPXTR","MNEM","Latest Value","","","Sym=RIC") for S&P 500 TR does not work. A small subset of problematic RICs is: .SPXTR, EURA=D2, .DJSM, .GLDD, .RUTTU, .RUATU and many others. Could you please provide an alternative solution?

  • Alex Putkov.1
    Alex Putkov.1

    One of the RICs you mentioned: EURA=D2 wouldn't have an equivalent in Datastream. This is a highly specialized RIC for Euro/US Dollar exchange rate quoted on Thomson Reuters Dealing system during Asian trading session. Datastream does not have series for such highly specialized exchange rates.
    One other RIC: .RUTTU does not exist. Perhaps you meant .RUTTR?
    Yet others such as .SPXTR do have equivalents in Datastream, but for some reason the symbology is not mapped.

  • Alex Putkov.1
    Alex Putkov.1

    I'm afraid I cannot suggest any alternatives. But since this is a pure product question not directly related to any APIs, I suggest you raise it to Thomson Reuters Helpdesk. Perhaps a Datastream product specialist on the Helpdesk can suggest an alternative solution?

Categories