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
38 5 12 18

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


#technology#contentricshistoricalsymbologyisin
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.

Upvotes
Accepted
26.3k 60 17 14

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:

result.png

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.

rdp-eikon-content.png


result.png (95.5 KiB)
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.

Upvotes
26.3k 60 17 14

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

isin-1.png

But the Data item browser shows that the RHIM.L's ISIN is NL0012650360

isin-2.png


Some ISIN like NO00108611115 or BG1500003188, etc is not available on the Workspace search result at all.


isin-1.png (76.2 KiB)
isin-2.png (52.9 KiB)
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.

Example 2:

BE0003790079 the search bar suggests the BAR.BR RIC.

isin-3.png

But the Data item browser shows that the RHIM.L's ISIN is BE0974362940.

isin-4.png

isin-3.png (60.3 KiB)
isin-4.png (52.4 KiB)

The Eikon Data API query with NL0012650360 and BE0974362940 shows a valid result.

isin-6.png

isin-6.png (32.8 KiB)
Upvote
25.3k 89 12 25

Hi @ricardo.henriquez

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.

ISINtoRic.txt


isintoric.txt (83.8 KiB)
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.

Upvotes
38 5 12 18

@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

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.

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.