4

I am looking at data for Unit Trusts and OEICs in the UK.

They are identified by SEDOL or ISIN codes.

Given an SEDOL, how can I find the ISIN associated with the same product? And given an ISIN, how can I find the associated SEDOL?

Improve this question
3
  • For what purpose?
    – Chris W. Rea
    Commented Aug 3, 2014 at 18:45
  • 1
    For the purpose of matching data between different data sources.
    – Ginger
    Commented Aug 3, 2014 at 23:18
  • 1
    You can use the tool on ISINdb.com: Convert SEDOL to ISIN
    – Mike
    Commented Aug 21, 2017 at 20:33

2 Answers 2

Reset to default
3

There is a relatively straightforward transformation explained on the Wikipedia page here and on the links from that page. Note that this only applies to SEDOLs for instruments listed on the London Stock Exchange (LSE).

To convert SEDOL to ISIN you pad leading zeroes onto the SEDOL until you have 9 digits. Then you add the two letter country code (as defined in ISO 3166-1) to the front. Then you add a final checksum digit to the end, again as defined in the algorithm on the Wikipedia page.

To convert ISIN to SEDOL you do the reverse: remove the final digit, remove the two leading letters, and strip off any leading zeroes.

Example:

  • RIOl - SEDOL: 0718875 -> ISIN: GB0007188757
Improve this answer
5
  • It doesn't work as neatly as that in practice as you can have multiple SEDOLS for one ISIN for different currencies. E.g. Siemens Ords, ISIN DE0007236101 has SEDOLS 5727973, 5735233 and 5727973 on the German exchange and 5751615 on the French exchange.
    – Chris Degnen
    Commented Aug 4, 2014 at 15:48
  • I stand corrected. You are quite right about this mismatch in EU symbols. The algorithm on Wikipedia works only for symbols listed under the aegis of the London Stock Exchange (LSE). I have edited my answer to reflect that.
    – dg99
    Commented Aug 4, 2014 at 16:26
  • Excellent answer! Thanks! How did you know that?
    – Ginger
    Commented Aug 4, 2014 at 18:09
  • Because I recently read those Wikipedia pages. (But not well enough to notice the issues that @ChrisDegnen pointed out.)
    – dg99
    Commented Aug 4, 2014 at 18:20
  • 2
    Some further info here: Unique Security Identification
    – Chris Degnen
    Commented Aug 4, 2014 at 18:27
0

You can get this information through Bloomberg, but it's a paid service.

Improve this answer
2
  • OP does not appear to be asking how to get the raw data but rather how to convert between two different identifying keys in the data.
    – dg99
    Commented Aug 4, 2014 at 14:54
  • 1
    You will need a data source like Bloomberg to pick up all the SEDOL variations. Many of them do not follow the rule you quoted.
    – Chris Degnen
    Commented Aug 4, 2014 at 15:50

Not the answer you're looking for? Browse other questions tagged .