ISIN returns no best match in GetSymbology or get_data. Records found manually

Question

question

ricardo.henriquez

38 ●4 ●9 ●17

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 #content rics historical symbology isin

Dec 06, 2022 at 09:58 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.

Answer 1 · 2022-12-07T05:02:58Z

wasin.w

24.7k ●54 ●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:

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.

result.png (95.5 KiB)

rdp-eikon-content.png (23.0 KiB)

Dec 07, 2022 at 05:02 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.

Answer 2 · 2022-12-06T10:27:35Z

wasin.w

24.7k ●54 ●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

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.

isin-1.png (76.2 KiB)

isin-2.png (52.9 KiB)

Dec 06, 2022 at 10:27 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.

wasin.w Dec 06, 2022 at 10:29 AM

Example 2:

BE0003790079 the search bar suggests the BAR.BR RIC.

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

isin-3.png (60.3 KiB)

isin-4.png (52.4 KiB)

wasin.w Dec 06, 2022 at 10:31 AM

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

isin-6.png (32.8 KiB)

Answer 3 · 2022-12-06T13:18:29Z

umer.nalla

25.3k ●87 ●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)

Dec 06, 2022 at 01:18 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.

Answer 4 · 2022-12-06T17:38:49Z

ricardo.henriquez

38 ●4 ●9 ●17

@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

Dec 06, 2022 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.

Q&A Forum

question

ISIN returns no best match in GetSymbology or get_data. Records found manually

4 Answers

Write an Answer

question

ISIN returns no best match in GetSymbology or get_data. Records found manually

4 Answers

Write an Answer

Related Questions