Dex2 request using ISIN

I'm testing the requests for Fundamental data using Dex2 with ISIN code as a search criteria. I saw somewhere that instead of RIC, ISIN can be used.

And it works for most of the cases.

However, I have several examples that it does not work.

ISIN: LU1536459578 . Dex2 request for TR.SEDOLCode field - return NULL

RIC for this ISIN: DLCMSGSG_t.SI . If I use RIC in the Dex2 request, it return TR.SEDOLCode: BF34791

From other side, TR.SEDOL field for ISIN has the same value as TR.SEDOLCode for RIC. But I was told not to use this field because SEDOLCode is newer and has all updates.

I have 20-30 ISINs like this. Why behavior of dex2 is different when I search for ISIN and RIC for this ISIN? I expected the search result will be linked to the same data.

Find more posts tagged with

eikon

eikon-com-api

Accepted answers

Alex Putkov.1

You can do this using RSearch:

=RSearch("EQUITY","IssueISIN:'BMG246371030' ExchangeName:'Singapore Exchange Securities Trading Ltd' RawContextFilter:'AssetState ne \'DC\''")

Then grab the first RIC returned and use DEX2 to get the SEDOL.

All comments

Alex Putkov.1

You may want to verify this with Refinitiv Helpdesk, but my understanding is that the relationship between TR.SEDOL and TR.SEDOLCode is the opposite to what you were told. To the best of my knowledge TR.SEDOL has broader coverage than TR.SEDOLCode, and I've been recommending TR.SEDOL and TR.ISIN over TR.SEDOLCode and TR.ISINCode.
In any case content questions such as this one are best directed to Refinitiv Helpdesk. Btw if the Helpdesk will require replication, the issue is very easy to reproduce using Eikon Excel: =TR("LU1536459578","TR.SEDOL;TR.SEDOLCode")

igorg

I talked to them and I was told twice to use TR.SEDOLCode instead of TR.SEDOL during last 2 days...I will ask them about this ISIN case.

Thanks

igorg

Another question about dex2 request using ISIN.

BMG246371030 - it returns SEDOL for RIC : 1145.HK

But there is another RIC: COUA.SI and it has the same ISIN.

Is there a way to specify an exchange name to indicate which one I want to use in request by ISIN?

Alex Putkov.1

You can do this using RSearch:

=RSearch("EQUITY","IssueISIN:'BMG246371030' ExchangeName:'Singapore Exchange Securities Trading Ltd' RawContextFilter:'AssetState ne \'DC\''")

Then grab the first RIC returned and use DEX2 to get the SEDOL.

igorg

I use multiple isin codes in IssueISIN. At some point it complains "Unable to read instrument list" in Excel. Is there any limitation on a length or number of ISINs in the IssueISIN parameter?

Alex Putkov.1

There's no such thing as "no limit". There's always a limit of some sort. Not all limits are documented though. This one isn't, so it can only be determined empirically. In my experimentation the cut off is at 59 ISINs. I.e. 60 ISINs is "too many".

igorg

I did that test too. 60 was ok, 61 - too many in my case

EXPLORE OUR SITES