question

Upvotes
Accepted
1 0 1 4

How to convert RIC / CUSIP / SEDOL to EstimateID in RDP

I see that EstimatedID is the primary company identifier in the ARM Output file for RDP Starmine. Please advise how can we convert RIC / CUSIP / SEDOL to EstimateID in RDP?


Should we do the conversion in RDP endpoint /discovery/symbology/v1/lookup? If so, may you kindly share the specific request POST parameters that we can use to convert RIC to EstimateID.

rdp-apirefinitiv-data-platformstarmine
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
13k 32 12 18

Hi @Jenna.Tabunda,

I am unable to find estimate ID in symbology conversion. However, you could use search or searchlight for this lookup.

Here is an example for RIC -> estimate ID conversion:

POST https://api.refinitiv.com/discovery/searchlight/v1/

{
  "View": "SearchAllLight",
  "Filter": "RIC eq 'IBM'",
  "Select": "QuoteEstimateID"
}

Response:

{
  "Total": 1,
  "Hits": [
    {
      "QuoteEstimateID": "US_4741N_1"
    }
  ]
}

similarly:

{
  "View": "SearchAllLight",
  "Filter": "CUSIP eq '459200101'",
  "Select": "QuoteEstimateID"
}

{
  "Total": 177,
  "Hits": [
    {
      "QuoteEstimateID": "US_4741N_1"
    },


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea