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 laurens · Jul 07, 2020 at 08:14 PM · ricget_timeseriesisinget_symbologyisocur

Get_Symbology from ISIN to RIC with currency

Royal Dutch Shell has a dual listing with the same ISIN on both LSE (GBX) and on AEX Amsterdam (EUR). The ISIN is the same but the currency is different. When carelessly converting symbology with this information for timeseries/portfolio value calculation can be very dangerous. 
As shown below doing a lookup from ISIN to RIC with symbology can get the wrong currency listing. As I have lots of information from third parties from which I don't get a RIC. I am looking for a way to translate an ISIN and an ISOCURRENCY into the right RIC. This issue does not only occur at RDSa but also at many ETFS that are listed with the same ISIN on many different exchanges. How can I best tackle this?

get_symbology( symbol = ["GB00B03MLX29"]
    , from_symbol_type = ["ISIN"]
    , to_symbol_type = ["RIC"]
    )
[[1]]
                 RIC
GB00B03MLX29 RDSa.AS

As shown below the transformation in the other direction goes ok. 

get_symbology( symbol = ["RDSa.AS"]
    , from_symbol_type = ["RIC"]
    , to_symbol_type = ["ISIN"]
    )
[[1]]
                ISIN
RDSa.AS GB00B03MLX29

get_symbology( symbol = ["RDSa.L"]
    , from_symbol_type = ["RIC"]
    , to_symbol_type = ["ISIN"]
    )
[[1]]
               ISIN
RDSa.L GB00B03MLX29

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya.farberov · Jul 08, 2020 at 06:05 PM

Hello @laurens,

Now that I better understand what you are trying to do, identify the RIC for specific currency, how about :

  • Get all RICs:
df = ek.get_symbology( symbol = ["GB00B03MLX29"] , from_symbol_type = "ISIN" , to_symbol_type = "RIC" , bestMatch = False)
ricList = df['RICs'].tolist()
  • Get currency per RIC
ek.get_data(ricList[0],['CURRENCY'])
  • Pick the RIC with the appropriate currency from the received

Does this work for your use case?

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 zoya.farberov · Jul 07, 2020 at 09:14 PM

Hello @laurens,

I think using:

ek.get_symbology( symbol = ["GB00B03MLX29"] , from_symbol_type = "ISIN" , to_symbol_type = "RIC" , bestMatch = True)

Is one way to avoid any difference, per Eikon Data API Reference this parameter will yield only primary RIC, of which there can be only one.

Will this help?

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
Answer by laurens · Jul 08, 2020 at 08:35 AM

Dear @zoya.farberov,


Thank you very much for your fast response. Much appreciated. I am aware of the BestMatch option. Unfortunately, if I have a list of portfolio stocks with an ISIN and ISOcur. it is not so helpful which stock is considered the primary ric. Calculating the portfolio value is not possible without being able to pinpoint the value of the stock in the correct currency. If I own RDSa stock in GBP currency I believe that I am unable to calculate the correct portfolio value if I have an ISIN and isocur.

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.

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

Related Questions

Ability for get_symbology to return all possible matches

Unable to download Fund price

Why CF_CURR does not return currency when asking same instrument via different types of identifier?

I dont recieve all information when quering a list of RIC using get_timeseries in python

Get Historical Prices from Bond ISIN

  • 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
  • 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