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.
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:
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.