For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Ha.T.Nguyen avatar image
21 ●1 ●0 ●0

Match SDC Deal Number from Loan database to RIC

Hi,

I got the data of all loans in the EU in 2020 from Excel Screener, but I need to match with RIC to find the firms' financial data and also match with my current list of firms to know if they also issue a loan this year.

Here is what I got at the moment:

- My SDC Loan file, I have SDC Deal Number, PermID, SEDOL, 6 digit CUSIP, Issuer/Borrower Company ID, TICKER. It contains around 3700 loans.

Only 6 digit CUSIP, Issuer/Borrower Company ID, SDC Deal Number have full value and the rest are missing a lot of value.

- My EU Firm List, I have PERMID, ISIN, SEDOL, CUSIPExtended, RIC - Full value. This contains around 9000 firms. I download using Eikon Data API

- I use PermID, SEDOL, 6-digit-CUSIP to match from the SDC Loan database to my firm list, but I'm not sure how many firms I could match since none is a full list.

Form using PERMID, I can match 480, CUSIPExtend (I use first 6 value) 474, 'SEDOL' 512

I combine all and got 964.

I hope I could receive some advice on this.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

@Ha.T.Nguyen this is a more involved content query - I have opened a case for you with the content team and they will be in touch shortly. I will also send you an email with the case number.

I hope this can help.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Ha.T.Nguyen avatar image Ha.T.Nguyen

THank you so much

Click below to post an Idea Post Idea