How to convert RIC to Mnemonic?

federico.fontana
federico.fontana Newcomer
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

Categories