1
●0 ●1 ●1
What would be the best endpoint to use to grab all the RIC, ISIN, SEDOL etc. codes for a universe of US stocks. Ideally using RDP.
38.1k
●71 ●35 ●53
You can use the RDP Search API to search for all codes in US stocks.
The endpoint is https://api.refinitiv.com/discovery/search/v1/.
The request is:
{
"View": "EquityQuotes",
"Filter": "ExchangeCountry eq 'USA' and AssetType eq 'EQUITY' and AssetStateName eq 'Active'",
"Select": "ExchangeCountry,RIC,CUSIP,SEDOL,AssetType,AssetStateName",
"Top": 1000
}
The output is:
{
"Total": 230942,
"Hits": [
{
"ExchangeCountry": "USA",
"RIC": "TSLA.O",
"CUSIP": "88160R101",
"AssetType": [
"EQUITY"
],
"AssetStateName": "Active"
},
{
"ExchangeCountry": "USA",
"RIC": "AAPL.O",
"CUSIP": "037833100",
"AssetType": [
"EQUITY"
],
...
For more information, please refer to the API documentation or the Building Search into your Application Workflow article.
