ISIN returns no best match in GetSymbology or get_data. Records found manually
I am having trouble matching some ISIN codes to their respective company information (attached the list).
I tried the get_symbology() and get_data() methods without luck. However, when I look for each ISIN manually on the RefinitivWorkspace Search Bar, there is information on the company, with a given RIC and all.
I wanted to check if there is another method to match these ISINs with their corresponding identifiers, instead of doing this manually.
Thank you
list_isin_nas=['AT0000676903',
'BE0003790079',
'BG1500003188',
'CH0001308904',
'CH0001503199',
'CH0001752309',
'CH0006227612',
'CH0008012236',
'CH0012271687',
'CH0012280076',
'CH0012530207',
'CH0015251710',
'CH0015940247',
'CH0020739006',
'CH0045039655',
'CH0214706357',
'CY0100470919',
'DDK0010244771',
'DDK0016026164',
'DE0003304101',
'DE0005437305',
'DE0005790406',
'DE0007239402',
'DE0007921835',
'DE000A1JBPV9',
'DE000LTT0243',
'DE000TRATON7',
'DE000XNG8888',
'DK0010040500',
'DK0010171362',
'DK0010242999',
'DK0010243450',
'DK0010259530',
'DK0010268440',
'DK0010268606',
'DK0010303619',
'DK0060013274',
'DK0060027142',
'DK0060032068',
'DK0060082915',
'DK0060102614',
'DK060636678',
'EE3100073644',
'ES0162600417',
'ES0169501030',
'ES0171996012',
'FDK0060696300',
'FI000330972',
'FI0009007835',
'FI0009010110',
'FI0009015309',
'FR0000038259',
'FR0000053829',
'FR0000075988',
'FR0000120354',
'FR0000121261',
'FR0000121725',
'FR0000130650',
'FR0000182479',
'FR0004026714',
'FR0004076891',
'FR0010342329',
'FR0010918292',
'FR0011067669',
'FR0012938884',
'GB0001741544',
'GB0002162385',
'GB0002335270',
'GB0002520509',
'GB0004065016',
'GB0004579636',
'GB0005331532',
'GB0006294382',
'GB0007190720',
'GB0007739609',
'GB0007995243',
'GB0008754136',
'GB0008847096',
'GB0009252882',
'GB0009290080',
'GB0009457366',
'GB00B01D1K48',
'GB00B02L3W35',
'GB00B03MLX29',
'GB00B140Y116',
'GB00B18V8630',
'GB00B1FP8915',
'GB00B1H0DZ51',
'GB00B3Y2J508',
'GB00B42VYZ16',
'GB00B43G0577',
'GB00B587FC42',
'GB00B5W55H93',
'GB00B74CDH82',
'GB00B7T77214',
'GB00B9NWP991',
'GB00BD2YHN21',
'GB00BDCXV269',
'GB00BFXZC448',
'GB00BHD66J44',
'GB00BJFLLV84',
'GB00BLT1Y088',
'GB00BM7S7K96',
'GB00BRS65X63',
'GB00BVVHWX30',
'GB00BYX91H57',
'GB00BYY5B507',
'GB00BZ1G4322',
'GRS001003029',
'GRS014003024',
'GRS120131008',
'IE0000197834',
'IT0001063210',
'IT0003126783',
'IT0004513666',
'IT0004922826',
'IT0005188336',
'IT0005218752',
'IT0005252140',
'IT0005252165',
'IT0005252207',
'IT0005319444',
'K0060495240',
'K0061027356',
'KYG813131011',
'LU0307018795',
'LU1066226637',
'NL0000288876',
'NL0000352565',
'NL0000474351',
'NL0000852549',
'NL0010489522',
'NO0005668905',
'NO0006390004',
'NO0010031479',
'NO0010299068',
'NO00108611115',
'RSANTBE1109',
'SE0000101032',
'SE0000102378',
'SE0000103699',
'SE0000106320',
'SE0000109811',
'SE0000112906',
'SE0000115008',
'SE0000115578',
'SE0000170110',
'SE0000171506',
'SE0000190134',
'SE0000193120',
'SE0000224446',
'SE0000236515',
'SE0000241614',
'SE0000310336',
'SE0000314304',
'SE0000331225',
'SE0000379844',
'SE0000390296',
'SE0000401622',
'SE0000408189',
'SE0000412363',
'SE0000412371',
'SE0000412991',
'SE0000422107',
'SE0000470395',
'SE0000472268',
'SE0000489098',
'SE0000514408',
'SE0000547929',
'SE0000635401',
'SE0000718017',
'SE0000789711',
'SE0000808396',
'SE0000816043',
'SE0000869646',
'SE0000950636',
'SE0001198714',
'SE0001413600',
'SE0001852211',
'SE0002000083',
'SE0002133975',
'SE0002367797',
'SE0002452623',
'SE0002683557',
'SE0003652163',
'SE0003993770',
'SE0005137031',
'SE0005568136',
'SE0005569100',
'SE0005876968',
'SE0006370730',
'SE0007074844',
'SE0007439112',
'SE0007704788',
'SE0007982814',
'SE0008008262',
'SE0008294078',
'SE0009189657',
'SE0009241706',
'SE0009664253',
'SE0009947534',
'SE0011116508',
'SE0011167956',
'SE0011205194',
'SE0012455202',
'SE0012455525',
'SE0012674232',
'SE0012676336',
'SE001473108',
'SE001519206',
'SE001519577',
'SE001565785',
'SE0015949847',
'SE0016803241',
'SSE0000103806',
'SSE0009242225',
'US45103T1079']
from refinitiv.dataplatform.content import symbology
response = symbology.Symbology.convert(list_isin_nas, from_symbol_type='ISIN')
response=response.data.df
import refinitiv.dataplatform.eikon as ek
df, err = ek.get_data(
instruments = list_isin_nas,
fields = [
'TR.CompanyName',
'TR.CommonName',
'TR.TickerSymbol',
'TR.RIC',
'TR.CUSIP',
'TR.ISIN',
'TR.LegalEntityIdentifier'
]
)
Thank you for your help
Best Answer
-
Hello @ricardo.henriquez
The Eikon Data API get_symbology function has the bestMath parameter with the following description:
When set to True (default), only the primary symbol is requested. When set to False, all symbols are requested.
I did a quick test with the following code:
ek.get_symbology(
list_isin_nas,
from_symbol_type='ISIN',
to_symbol_type='RIC',
best_match=False)The result is as follows:
Does this match your requirement?
Additionally, I highly recommend you contact the Content support team to verify your ISIN names. You can contact the team directly via the https://my.refinitiv.com/content/mytr/en/productsupport.html website.
0
Answers
-
Hello @ricardo.henriquez
Thank you for contacting us. Do your ISIN codes are the valid code list?
I quickly checked some of the given ISIN codes with the Workspace Search. Workspace suggests a RIC for some of your ISIN codes, but the Workspace Data Item Browser app (DIB) shows that the valid ISIN of that RIC is a different code.
Example 1:
AT0000676903 the search bar suggests the RHIM.L RIC
But the Data item browser shows that the RHIM.L's ISIN is NL0012650360
Some ISIN like NO00108611115 or BG1500003188, etc is not available on the Workspace search result at all.
0 -
The Eikon Data API query with NL0012650360 and BE0974362940 shows a valid result.
0 -
If you try your list of ISINs on the API Playground with the actual symbology/lookup endpoint, you will note that most that for most of them the response is:
"Input value does not exist in current time. You can use look-up type endpoint or 'showHistory' parameter to get more information".
See input and output below.
1 -
@wasin.w @umer.nalla Thank you both for your response.
I believe some of these ISINs might be delisted/merged companies. Still, I haven't figured out how to programmatically get the suggested/actual ISIN instead, without looking one by one on the DIB or search bar. Thank you again
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 中文论坛