Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by federico.fontana · Jul 31, 2017 at 09:50 AM · python apiidentifiers

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.

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Jul 31, 2017 at 10:47 AM

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.

Comment

People who like this

0 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
federico.fontana · Aug 01, 2017 at 10:54 AM 0
Share

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?

avatar image
REFINITIV
Alex Putkov. ♦♦ federico.fontana · Aug 01, 2017 at 06:23 PM 0
Share

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.

avatar image
REFINITIV
Alex Putkov. ♦♦ federico.fontana · Aug 01, 2017 at 06:25 PM 0
Share

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?

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

ID type being used for TR.ISIN or TR.ISINcode

Is it possible to call up the Attribution Analysis (Brinson Style Attribution in Portfolio Analysis) via Python?

Problem with delisted stocks and TR.AvgDailyValTraded20D

Missing Quotes for packages users have access to

Looking for an efficient way to download price quotes for a list of stock tickers into dataframe.

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges