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 renee.yao · Oct 04, 2017 at 04:48 PM · ric lookuptickerric code identification

Converting a list of tickers to RICs

Hi there

I try to convert a list to tickers (such as IBM, AAPL) to RICs, such that I can carry out later queries. I have ~ 4000 of such tickers, which include delisted ones (such as OB). It is not wise to check them manually one-by-one, therefore I am looking for built-in methods to do the conversion.

I've tried two methods: get_data() and get_symbology(). For each of the command I can pass the list of tickers in, and hopefully the return values would contain the corresponding RICs, if applicable.

The get_data() method didn't do a good job, for example, for the ticker 'CALX', it won't return the corresponding RIC (should be CALX.K).

For CALX, the get_symbology() didn't return me the RIC either, but it return a ISIN. I then can call get_symbology() again, using ISIN as lookup argument, to get me the CALX.K. Therefore, I can manage to covert tickers to RIC through ISIN.

So far it seems that get_symbology() would solve my problem, however, I found I still missed few ticker --> RIC conversion. For example, if I am looking to convert the ticker SIR (RIC = SIR.O, from desktop version), there is no anything else available from ek.get_symbology('SIR', from_symbol_type='ticker'), other than its own ticker. Therefore, my ISIN solution won't work either.

Can someone wade in this problem?

Thanks!

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jorge.santos · Oct 06, 2017 at 11:44 AM

HI @renne.yao - you are getting this because there is a bestMatch parameter that is set to True by default. This is something that we will fix (add this on the function signature).

However meanwhile you can do the following:

ek.json_requests.send_json_request('SymbologySearch',{'symbols': ['CALX'], 'from': 'ticker', 'to': ['RIC'], 'bestMatchOnly': False})

This will always return a list of matching RICs. The first item should show the best match. For example - for the above request you would get:

{'mappedSymbols': [{'RICs': ['CALX.K', 'CALX.N', 'CALX.MW', 'CALX.ZY', 'CALX.Z', 'CALX.B', 'CALX.TH', 'CALX.DG', 'CALX.P', 'CALX.DY', 'CALX.C', 'CALX.PH', 'CALX.A', 'CALX.DF', 'CALX.BT1', 'CALX.NB', 'CALX.ITC', 'CALX.BAT', 'CALX.BYX', 'CALX.EI', 'CALX.W^E14'], 'bestMatch': {'error': 'No best match available'}, 'symbol': 'CALX'}]}

Comment

People who like this

0 Show 0 · 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
REFINITIV
Answer by Joris.Hoendervangers · Oct 05, 2017 at 11:42 AM

Maybe you can give PermID`s record matching a try:

https://permid.org/match

Nevertheless, the get_symbology() should work too. Any suggestions @Alex_Putkov. or @jorge.santos?

Comment

People who like this

0 Show 1 · 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
renee.yao · Oct 05, 2017 at 12:47 PM 0
Share

Thanks @Joris.Hoendervangers! However, the permid doesn't seem to give me RIC, but rather some detailed information about the underlying companies...

I had high hope for get_symbology() too, but the simple test for looking up ticker --> RIC with 'SIR' really get me down...

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 >
8 People are following this question.

Related Questions

Where do I find ExchangeCountryCodes?

Screen to capture a list of tickers

Search for a company's RIC by its name in PYTHON on Mac

How do I add additional criteria when retrieving RIC codes to a ‘screener_exp’ statement?

Exchange Specific RIC

  • 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