1
●1 ●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.
Hello @raymund.pornasdoro1
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
79.1k
●250 ●52 ●74
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.
