question

Upvotes
3 0 0 2

Workspace is able to recognize specific SEDOLs but api fails

Hi,


if you search 6195739 (sedol code), you'll get

Chubu Steel Plate Co Ltd on Workspace;


However, if I use


rd.get_data(universe=['6195739'], fields=['TR.PriceClose'])


it returns

RDError: Error code -1 | Unable to resolve all requested identifiers in ['6195739'].


However, if I use the corresponding RIC code: 5461.T, and run: rd.get_data(universe=['5461.T'], fields=['TR.PriceClose'])


it returns me the data I need


seems like it doesnt recognize it

Does anyone have any idea?

same for

B56ZM74

BYZFF24

BF29PR1

BMDGT12

BYWFSG2

BPH27X5

6195739

6985037

6219297

workspace#productdatasedol
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
15.3k 32 5 10

Hi @Tim Lai ,

Have you tried using the code below to convert instrument from SEDOL to RIC first, then use the RICs list as an input of get_data function to retrieve the data

import refinitiv.data as rd
from refinitiv.data.discovery import (
    convert_symbols,
    SymbolTypes
)

rd.open_session()

response = convert_symbols(
    symbols=['B56ZM74','BYZFF24','BF29PR1','BMDGT12','BYWFSG2','BPH27X5','6195739','6985037','6219297','6195739'], 
    from_symbol_type=SymbolTypes.SEDOL,
    to_symbol_types=[SymbolTypes.RIC],
)
rics = response['RIC'].to_list()

rd.get_data(universe=rics, fields=['TR.PriceClose'])

1725854210202.png



1725854210202.png (73.6 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
3 0 0 2

Thanks @raksina.samasiri,


Yes I did, that's my original method, I convert SEDOL to RIC using get_data like:

rd.get_data(universe=sedol_list, fields=['TR.RIC']),


but not converting to RIC could save me almost a minute in running time


btw, may I ask which methods, convert_symbols or get_data, is more appropriate (in terms of speed or anything else) in converting them?


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
3 0 0 2

Also, when I tried your method, I got 'internal server error', could you pls help one the issue

1725860609584.png


1725860609584.png (67.3 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
15.3k 32 5 10

Hi @Tim Lai ,

I'd suggest using the convert_symbols function to convert the symbols.

Regarding the Internal server error, it could come from specific instrument, could you please provide the list of symbols used for further investigation?

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.