Upgrade from Eikon -> Workspace. Learn about programming differences.

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 ●3

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

Jirapongse avatar image   Jirapongse

@Ha.T.Nguyen

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question? If yes please click the 'Accept' text next to the reply.

If you know an answer, please share your answer, and then accept it. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Alex Putkov.1 avatar image   Alex Putkov.1

<AHS only>: Emailed Jason Ramchandani

1 Answer

· Write an Answer
Upvote
Accepted
jason.ramchandani01 avatar image
10.2k ●18 ●6 ●9

@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 512.0 KiB each and 1.0 MiB total.

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

THank you so much

zoya faberov avatar image   zoya faberov

Hello @jason.ramchandani,

Were there any findings? Can you please update this post?

Thanks

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.