Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
federico.fontana avatar image
5 ●5 ●5 ●8

How to convert RIC to Mnemonic?

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.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apirics
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pimchaya.wongrukun01 avatar image   pimchaya.wongrukun01

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Nipat Kunvutipongsak avatar image   Nipat Kunvutipongsak

Hello again!

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

federico.fontana avatar image 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 avatar image Alex Putkov.1 federico.fontana

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 avatar image Alex Putkov.1 federico.fontana

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?

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.