What is best API to lookup ISINs by number or name?
In other words, ideally I would like to have an rest-api like this:
http://api.isinlookup.org/filter={"isin":"US38259P5089"} ->
[
{
"isin": "US38259P5089"
"name": "Google Inc.",
"type": "Equity"
}
]
http://api.isinlookup.org/filter={"name":"Google"} ->
[
{
"isin": "US38259P5089"
"name": "Google Inc.",
"type": "Equity"
},
...
]
Coming rather late to this party and because I've been researching the same (or at least similar) question, I'd like to share my solutions:
I've signed up (for free) at lemon.markets to request an API key. Following their documentation you can use the REST API to e.g. query for a certain ISIN with the latest quotes, e.g.
https://data.lemon.markets/v1/quotes/latest?isin=LU0629459743
which results in
{
"status": "ok",
"time": "2022-12-17T20:33:45.654+00:00",
"results": [
{
"isin": "LU0629459743",
"b_v": 190,
"a_v": 190,
"b": 108.62,
"a": 108.78,
"t": "2022-12-16T20:59:55.000+00:00",
"mic": "XMUN"
}
],
"previous": null,
"next": null,
"total": 1,
"page": 1,
"pages": 1
}
Alternatively, you can also query historical data for certain dates (and times), e.g.:
https://data.lemon.markets/v1/quotes?isin=LU0629459743&from=2022-01-03T00:00:00.000%2B0000&limit=1
{
"status": "ok",
"time": "2022-12-17T20:34:59.288+00:00",
"results": [
{
"isin": "LU0629459743",
"b_v": 80,
"a_v": 80,
"b": 134.72,
"a": 135.44,
"t": "2022-01-03T07:43:37.000+00:00",
"mic": "XMUN"
}
],
"previous": null,
"next": "https://data.lemon.markets/v1/quotes?isin=lu0629459743&from=2022-01-03T00%3A00%3A00.000%2B0000&limit=1&page=2",
"total": 22003,
"page": 1,
"pages": 22003
}
Note (1): You need to request an API key and send it with the request, so just clicking on the links above without that information won't work
Note (2): You won't get any data for days that aren't business days for the stock exchange, so make sure to take that into account
A second provider is leeway.tech - you also have to sign up for a free API key and then use this query to find out your Symbol and Exchange
https://api.leeway.tech/api/v1/public/general/isin/LU0629459743?apitoken=token-goes-here
[
{
"Code": "UC44",
"Exchange": "LSE",
"Name": "UBS MSCI World Socially Responsible UCITS USD A-dis",
"Type": "ETF",
"ISIN": "LU0629459743",
"previousClose": 9449,
"previousCloseDate": "2022-12-16",
"countryName": "UK",
"currencyCode": "GBX"
},
...
{
"Code": "WSRUSA",
"Exchange": "SW",
"Name": "UBS MSCI World Socially Responsible UCITS USD A-dis",
"Type": "ETF",
"ISIN": "LU0629459743",
"previousClose": 107.6,
"previousCloseDate": "2022-12-16",
"countryName": "Switzerland",
"currencyCode": "CHF"
}
]
Then choose your Symbol from the response (here it is Code) and the Exchange and query for historical quotes:
[
{
"date": "2022-01-03",
"open": 135.48,
"high": 135.98,
"low": 134.78,
"close": 135.2,
"adjusted_close": 133.5272,
"volume": 127570
}
]
A solution would be to use Palmy Investing‘s Stocks API. Here are four examples: 2 more general (Quotes)& 2 specific for receiving id, ticker, isin and company name as response by passing isin/company name as parameters
# For python as an example
import requests
base = "https://palmy-investing.com/api/v1/stocks"
lookup = "?isin=US38259P5089"
lookup_company = "?company=Alphabet"
quote_by_isin = base + "/quote" + lookup
quote_by_company = base + "/quote" + lookup_company
basic_information_by_isin = base + "/tickers" + lookup
basic_information_by_company = base + "/tickers" + lookup_company
def request_url(url: str, API_KEY: str):
headers = {"Authorization": f"Token {API_KEY}"}
response = requests.get(url)
return response.text
When we execute this code with you‘re credentials as token:
pprint.pprint(request_url(quote_by_company, token))
{
"count":1,"next":null,"previous":null,
"results": [{'ads': None,
'company': 'Alphabet Inc.',
'eps': 4.55,
'evaluation': None,
'fws': None,
'id': 447,
'last_update': '2023-06-14T15:17:38.951111Z',
'lts': None,
'market_cap': 1576639062659,
'pe_ratio': 27.37,
'price': 124.54,
'ps': None,
'ticker': 'GOOG'},
}
Same as pprint.pprint(request_url(quote_by_isin, token))
The following two are also equal regarding their response:
pprint.pprint(request_url(basic_information_by_isin, token))
pprint.pprint(request_url(basic_information_by_company, token))
[{'company': 'Alphabet Inc.',
'id': 404,
'isin': 'US38259P5089',
'ticker': 'GOOG'}]
Here‘s a link about how to receive an API token for free:
[https://palmy-investing.com/docs/api/auth][Token]
Note that there are some limitations:
Also note that I am the project dev& therefore biased, but I commented working code& answered the question regarding a free alternative.
