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
Best Answer
-
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'])
dfThe 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],
)
responseThe 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
1
Answers
-
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
0 -
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
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛