Using Getdata function to Get CUSIP based on RIC

How

Hello!

Sorry, I need to change a bit about my question. When I was using Getdata function in Refinitiv Workspace API, I used RIC to get CUSIP (and I set the parameter: 'SDate' and 'EDate', I tried to make they are the same day to get the certain day's data). However, most of the transfer is right, some of the CUSIP I got is nothing. And I use RIC Search to search, it also shows that 'CUSIP' is N/A, but with other information. For example:

code:

import lseg.data as ld
ld.open_session()
testdate = '2008-02-26'

datatest = ld.get_data(
universe=['FDP.N'],
fields=['TR.CUSIP'],
parameters={'SDate': testdate, 'EDate': testdate}
)
display(datatest)

And the result is:

Instrument CUSIP
0 FDP.N

And I search 'FDP.N' in 'RIC Search', it shows many things except 'CUSIP': Exchange-New York Stock Exchange, Ex dividend date-2025-03-07T00:00:00.000Z, etc. And I search other databases, this company has CUSIP in this date.

Thank you!

Gurpreet

Hello @How

Can you please show some code or example securities of what you expect vs get.

Thanks

How

https://community.developers.refinitiv.com/discussion/comment/124896#Comment_124896

Hi, thank you!

I changed a bit about my question and show the code and results.

Jirapongse

@How

You can use the TR.CUSIPExtended field instead and this field doesn't support the SDate and EDate parameters.

You can use the Data Item Browser tool to search for fields and parameters.