What is the ID retrieved in the API?

Question

question

BQXQ

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

eikon eikon-data-api #content symbology

Feb 04 at 05:38 PM

10 |1500

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

Jirapongse Feb 13 at 07:47 AM

@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

Answer 1 · 2024-02-05T10:59:48Z

aramyan.h

5.2k ●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

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

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

screenshot-2024-02-05-at-105533.png (60.0 KiB)

screenshot-2024-02-05-at-105738.png (14.2 KiB)

Feb 05 at 10:59 AM

10 |1500

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

BQXQ Feb 05 at 03:24 PM

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

aramyan.h Feb 05 at 04:14 PM

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

Q&A Forum

question

What is the ID retrieved in the API?

1 Answer

Write an Answer

question

What is the ID retrieved in the API?

1 Answer

Write an Answer

Related Questions