Get RIC from CUSIP

Hemant

Hello team, I am referering to the standard documentation to find the RIC sysmbols for the following cusips and but this is giving nothing in return, Can u please guide on the same?

response = symbol_conversion.Definition(    symbols=['72699S228','67V99K227','61499E224','26F99M227','35U99M221','60T99A227','71M99Y229','337999924','16S99L226','13X99W223','803021104','926283920'],    from_symbol_type=symbol_conversion.SymbolTypes.CUSIP,    to_symbol_types=[        symbol_conversion.SymbolTypes.RIC    ],).get_data()response.data.df.head()

I also tried to get the data for a few SEDOLs to RIC using the similar code:

response = symbol_conversion.Definition(    symbols=['BD4D737','BLD2CY7','BGS21V7','B296314','B59HM77','B9J4K16','BRJFXN8','6357852','BLGTZK2','B00SV00','6776703','6929325','BD1F0W6','BFMZJ55','BYV98H6','BLD1SB3','B3X0F91','B15F5K1','6439567','6121176','B44P7W9','BZ7NDP2','6397825','B02FBC1','6586872','6168838','6317072','BYVQ673','BDRY2P4','BMQ69T7','6073556','BD5CND5','BR1R6P5','BNHBMG6','BFYTT00','BLD9KX3','BK6YZP5','BP41ZD1','BF06LG5','6181482','B61TX08','BH0VXF7','BYVRFP7','B8F2T65','BH4TZ73','BD5CPN9','6196077','B01JCK9','BD5CPP1','BMZ14N2','BBPD5F0','B39GMS1','BFSQNZ0','B1XDJC7','6321954','BNYK8H9','BK1K3N2','BTF4P59','B1L3WW0','B2RJYH8','BZ04KX9','B633D97','B7MD0V6','6105738','B01B1L9','BMH5F39','BFB4S78','0','B3MPN59','6903556','B29MKF5','B1Z7648','BZ0D252','BD9GZX7','BD5M1Z3','BN74BB3','BPVGW16','BQL7RK0','B755514','BP3R8G4','BNCDW78','6560995','6782045','6162692','B5MDP39','BVVPXP6','BD5CHT9','BG8HFQ5','6803225','BNK9Q76','6742340','B4Q4CJ6','B3ZVDV0','BYP9J68','6045180','BPFGJZ5','BKRD2S3','BD5CJ26','BYZJV17','BCDBKF8','B297KM7','BP3R2Q2','BMD2L36','BK71CZ4','BMGBJV4','BK5DF97','BMQDPD4','BN320D6','BJQWRW3','BN936W4','6579010','B296ZH4','BS9BY18','6743956','BYVDW43','B133G60','BLC7TD1','6015644','BNR4N95','BNV5PM1','BP98612','BMQDPG7','BPLGW83','BD5CFP1','BNM7KH6','BRHXHZ4','BN19HM7','B1DN3X6','B44ZV94','B54DPL5','B890GY2','B3TYW07','BMTCVV8','B1P1JS5','B3ZNGT5','6000305','BHQPST2','B4N6NB4','6803247','6192150','6193766','B56KLY9','BK8JKG4','6333937','6092357','6856995','6193681','BF09MJ4','6444497','6465874','BKL9QV8','6555087','B1WMLF2','B2NDF82','6039558','6317339','BLLHKZ1','BJQ2P07','BH0W286','B01RQM3','B61X7R5','BHB1WW6','B4YWZT3','BQT2R07','B128WL3','BD87BS8','B00HR98','BF06TZ0','BN46YN5','6121563','B4Z9XF5','B1GKL41','6253767','6139362','BPFJHC7','BF0VND1','BFT7KB7','6368520','BK1N461','2781648','BMH4TB2','6171900','BSZ2BY7','6101026','B40MFF3','BD6FGZ6','B96RL59','6652881','BS4DBX0','BF2B3K6','BN8ZT55','BWCGVX9','BNQNGS3','BNRNLH6','B1LDTB8','B0YJJ27','B1L9PJ6','BZC0W28','BF37466','BKMFNP8','BK7GN01','B19HGC2','6404996','B07LTC0','B1WT818','2398822','BD6F8V6','B1R3S15','BWFGD63','6099938','6437624','BNHWKG5','BYT56K5','BRC0Q31','B1BL581','BNVXB61','B0YVBS3','B233LP1','B233HS6','B00L819','B7JW351','6120270','6305442','6653334','6366999','B4LD3M8','B9DG2Q7','BL4P3Q4','6651048','6727121','BFY6H41','B80NSQ6','BFZ8G27','B1F1R58','B00D9M3','BC1J0F4','6214195','6202178','6291767','B4KWQ72','BDHBG75','B232R27','B7T5KQ0','6449544','BWB95X7','6212564','6529792','6515434','BD95QN1','BZ60JT0','6896849','6155937','B01LXY6','B00VS64','B01T146','6434562','6155250','6397502','B00GJN3','BF07GJ6','B94K2F7','6315054','B42MSJ6','BLF9YV7','B3F2324','BNGJH11','6316875','BNSP8W5','6180230','B7D29Z9','BYXYVM5','6450267','BS7JCP4','6249584','6988155','6346913','6693233','BD85VX7','B78CP12','B142NG5','BDFM6W5','6493585','B088VB3','6609304','BFN65V5','6113429','BPK3M63','B7RLFB0','BLRL853','B2NRDM4','6736213','BQ13Z04','B2NRDY6','BNDMZJ7','B92RW83','B0XNCB0','BM8X3Q1','B7WJ188','B2927P4','BPYD720','BNZKT97','B1G16Z0','6094825','B1VT035','BXC7XC2','B23DMQ9','BF249P2','BL9YQK1','B0DJQ38','B5ZXWL3','6186540','6475538','BQY2KF8','6160384','BSZLN15','6874027','BJYRGH8','B58J1S8','6729503','B033QQ3','B56VQB4','B5SG8Y4','B97NLT0','B4VYX10','6432566','6715557','B00VD14','6316121','6439620','B8DJMF8','6451668','6372480','6577081','6599676','B43HJN1','BK0MPZ5','B43MWS2','2113382','6889106','6716538','6290355','B0P6L87','BJDS3L5','B734XQ4','B05PZJ3','B15F664','6887887','BXCZ9P1','BNG18T2','BF1QN02','6554675','6554697','BDVKB40','6589473','BD215T5','BRS7681','BMY0YX0','BVFMFG8','B6TCNK9','BMC4B77','BMWS3X9','B23DBK6','2257019','2463247','2588184','BP3RNW5','BDSFW67','B16GK97','BFMST43','B1XLCQ6','6110497','6534837','BVBH523','BPSMGV5','BTDBK35','6717456','BL6HQ81','BS2KWR4','BQXH1K6','B24FZ32','BRZWZC6','B0RJCG9','BKC9L01','B3N0H17','B3PZ2V5','BPGKFW5','BYYFJV2','BSFTLJ3','BT14FF3','BYNKP98','BMX09H0','BN7RMD1','BGMHP50','6002895','B1L2RC2','BSF1LV1','BKSBTW9','B56HH42','B953PM3','BSN62Q0','B1VRCG6','6725299','BN6HJY2','BYYMZN7','BHR0FS4','B58YWF7','B1KYHF2','B4Q1532','B4JSTL6','B0190C7','BP5JGC0','6100454','B07Y2F3','B15T3F4','6543877','6687184','6048156','BFNBJ41','B01C1P6','BRBXGH5','6454861','BGXQL36','6505316','BPF0559','6451055','6984959','B622C10','BDVLJ72','BD6GC06','6248332','B4NYSN5','B1P1GJ5','6771720','BM9Q3H0','B2QQP88','BK5CYG4','BKPN4N4','BQ95T22','6744722','BNXK2C3','BSDZ375','6320832','B28SKW1','6283601','6421928','6254083','BS7HXD3','B1359J0','BLZGSM7','B0166H5','BXC7WG9','BGH17Y0','BD41Z93','BD72GW3','BMY5866','B15XDH8','B64FX58','B1GJZD5','BS3KM73','BQTPLM6','BSJ50P6','6518217','6739739','BF4NQP6','6549013','BVYDL20','BJP0B04','B4YX1N2','B3ZPCV5','B00FYK2','6254511','BV8DR17','B1LJQC6','6638115','6770556','B5VN637','B5YGG00','B52J816','B6RV676','6349354','BWQ7SK4','BVB7YT3','BMGQCT8','B5TQ1L1','BGK4T39','BNNMVP5','BNVTTV0','BRK2Z98','6490928','6282062','6406271','B0TB3F9','B08X163','0753810','BNTBRX6'],    from_symbol_type=symbol_conversion.SymbolTypes.SEDOL,    to_symbol_types=[        symbol_conversion.SymbolTypes.RIC    ],).get_data()

It did return me some values and not all, I am expecting if there is no data at the backend, it should give me NA or something rather than skipping the sedol altogether, Can u please guide on this

Jirapongse

@Hemant

Thank you for reaching out to us.

For the first question, I couldn't find those CUSIPs. Please contact the helpdesk team directly to verify those CUSIPs.

For the second question, I checked and found that this is how the API works; it will exclude unmatched instruments from the response. The code to get the unmatched SEDOLs could be like this:

import pandas as pd
from lseg.data.delivery import endpoint_request

SEDOLs = […..]

response = symbol_conversion.Definition(    
    symbols=SEDOLs,
    from_symbol_type=symbol_conversion.SymbolTypes.SEDOL,
    to_symbol_types=[symbol_conversion.SymbolTypes.RIC],).get_data()

not_found = (list(set(SEDOLs) - (set(response.data.df.index.to_list()))))

discovery_lookup = "/discovery/search/v1/lookup"
request_definition = ld.delivery.endpoint_request.Definition(
    method = ld.delivery.endpoint_request.RequestMethod.POST,
    url = discovery_lookup,
    body_parameters =
        {
          "View": "SearchAll",
          "Scope": "OldQuoteSEDOLs",
          "Terms": ','.join(not_found),
          "Select": "DocumentTitle,RIC,IssueISIN,ISIN,CinCUSIP,CUSIP,SEDOL,TickerSymbol,IssuerOAPermID,FundClassLipperID"
        }
)
response1 = request_definition.get_data()
df_oldsedols = pd.DataFrame(response1.data.raw['Matches'])
not_found2 = list(set(not_found) - set(df_oldsedols.columns.to_list()))
not_found2

The unmatched SEDOLs after using the OldQuoteSEDOLs are:

['BNM7KH6',

 'BKRD2S3',

 'BSF1LV1',

 'BPVGW16',

 '0',

 'B0YVBS3',

 'BS3KM73',

 'BWQ7SK4',

 'BMGBJV4',

 'BP98612',

 'BNV5PM1',

 'BQL7RK0',

 'BNHBMG6',

 'BMQDPD4',

 'BN19HM7',

 'BSJ50P6',

 'BPLGW83',

 'BG8HFQ5',

 'BMQDPG7',

 'BPFGJZ5',

 'BSN62Q0',

 'BQTPLM6',

 'BSFTLJ3',

 'BRHXHZ4',

 'BFYTT00',

 'BR1R6P5',

 'BN936W4',

 'BNCDW78',

 'BN74BB3']

You need to contact the helpdesk team via LSEG Support to verify those SEDOLs.