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
5 0 0 2

What is the ID retrieved in the API?

Hello,

Using the following two fields: ['TR.InvestorFullName.investorid','TR.InvestorFullName'], I may get as ID "2928306", corresponding to "Mitsubishi UFJ Financial Group Inc".

If I try to use ek.get_data() with 'TR.ISIN' for the ID above then I get no match.

If I try to use ek.get_symbology() I have the same issue.

(For the complete list of investors I get only very few positive results..and they seem to be completely wrong, e.g. the Investor ID "2003672" leads to a Chinese bond)


So what is this Investor ID that is retrieved in this first step? I want to receive the ISIN for the Investor ID.


Edit:

After getting the Perm ID ('TR.InvestorFullName.investorpermid'), I now have the second problem that for some reason only very few instruments/PermIDs generate an output when searching for ['TR.ISIN','TR.RIC'].


Instrument ISIN RIC

0 5000000933 JP3902900004 8306.T

1 4297836130

2 4297651992

3 5000001144

4 4296477482


Searching manually for the other Perm IDs works perfectly fine, though.


Best,

BQXQ

eikoneikon-data-api#contentsymbology
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.

@BQXQ

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

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

1 Answer

· Write an Answer
Upvote
Accepted
5k 16 2 7

Hi @BQXQ ,


What if you use TR.InvestorFullName.investorpermid instead ofTR.InvestorFullName.investorid as I don't see investor id as a method under symbology requests neither for ek.get_symbology nor in rd symbol conversion.

df = rd.get_data('8306.T', fields =  ['TR.InvestorFullName', 'TR.InvestorFullName.investorpermid'])
df

screenshot-2024-02-05-at-105533.png

The you can use rd symbol conversion below to convert perm id to ISIN/RIC as below:

import refinitiv.data as rd
from refinitiv.data.discovery import convert_symbols
rd.open_session()
response = convert_symbols(
    symbols="5000000933", 
    from_symbol_type=SymbolTypes.OA_PERM_ID,
    # to_symbol_types=[SymbolTypes.RIC, SymbolTypes.TICKER_SYMBOL],
)
response

screenshot-2024-02-05-at-105738.png

The reason I am asking you to use our latest RD Libraries instead of eikon is because it doesn't seem permid is supported under ek.get_symbology() I am afraid.


I hope this helps.


Best regards,

Haykaz


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.

Hi Kaykaz,


I've tried using the RDP as you've suggested. It also generates only very few results. I've pasted a list of 300 PermIDs and only got output for 58. And only 19 of those got an ISIN. Just 9 got a TickerSymbol.


The list of PermIDs comes from 'TR.InvestorFullName.investorpermid' for 'MS.N'. (which was the example I also used for my original post)


Also, the RDP outputs seem odd, as they generate results such as loands or bonds in the "DocumentTitle" column (albeit for the issuing correct entity it seems).



Best,

BQXQ

Hi @BQXQ ,


This is related more to the content and our Helpdesk is better equipped to answer content related question. I would advice reaching out them MyRefinitiv.

You can let them know that we verify the code and the workflow you are using to get the data and your question is about the content or absence (in case of ISINs/ticker) of it. I am sure they will a clarification for


Best regards,

Haykaz

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.