Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TRTH /
avatar image
Question by tradingTech · Oct 12, 2017 at 05:19 PM · dss rest apiric lookupsedol

Resolve RICs from multiple SEDOLs

I have an application that snapshots thousands of equities from the RFA API. I don't always have the most up-to-date RIC and would like to resolve these from a SEDOL. From answers in the portal, it seems the only way to do this is by leveraging some of the Reuters RESTful APIs.

I've found that this code both works and is very slow:

var extractionsContext = new ExtractionsContext(serviceUri, token);
var onlyEquities = new[] { InstrumentTypeGroup.Equities };
foreach (var sedol in sedols)
{
    var sedolresult = extractionsContext.InstrumentSearch(IdentifierType.Sedol, sedol, onlyEquities, IdentifierType.Ric, 1).FirstOrDefault();
    if (null == sedolresult) continue;
    if (sedolresult.IdentifierType != IdentifierType.Ric) continue;
    //Do something with sedol/ric pair
}

Is there a way to do this in a single call?

People who like this

0 Show 1
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
steven.peng ♦♦ · Oct 23, 2017 at 10:26 AM 0
Share

Hi @tradingTech,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Oct 13, 2017 at 03:07 AM

@tradingTech, you can do it using a T&C (Terms and Conditions) request, in one call for all instruments:

POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
    "ContentFieldNames": [ 
      "RIC", "Currency Code", "Exchange Code"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
        { "Identifier": "5641567", "IdentifierType": "Sedol" },
        { "Identifier": "B1YW440", "IdentifierType": "Sedol" },
        { "Identifier": "5231485", "IdentifierType": "Sedol" },
        { "Identifier": "BH4HKS3", "IdentifierType": "Sedol" }
      ],
      "ValidationOptions": { "AllowHistoricalInstruments": true },
      "UseUserPreferencesForValidationOptions": false
    }
  }
}

Result:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Sedol",
            "Identifier": "5641567",
            "RIC": "CARR.PA",
            "Currency Code": "EUR",
            "Exchange Code": "PAR"
        },
        {
            "IdentifierType": "Sedol",
            "Identifier": "B1YW440",
            "RIC": "LP71000002",
            "Currency Code": "GBp",
            "Exchange Code": "LIP"
        },
        {
            "IdentifierType": "Sedol",
            "Identifier": "5231485",
            "RIC": "ALVG.DE",
            "Currency Code": "EUR",
            "Exchange Code": "GER"
        },
        {
            "IdentifierType": "Sedol",
            "Identifier": "BH4HKS3",
            "RIC": "VOD.L",
            "Currency Code": "GBp",
            "Exchange Code": "LSE"
        }
    ]
}

Comments:

  • I added the currency and exchange codes to the result, you may not require this.
  • I set ValidationOptions to Allow Historical Instruments. If you are snapping prices with RFA you will probably only require current ones, in which case you could set that parameter to false.
  • I also set UseUserPreferencesForValidationOptions to override the user preferences in the GUI. Again, this is just a choice.
  • For more info on this call, see this DSS REST API Tutorial 7: On Demand T&C extraction (it also applies for TRTH).
  • For more info on how to convert from Sedols to RICs, see this article. It is about ISIN to RIC conversion, but applies to SEDOL to RIC as well.
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
zoya.farberov ♦♦ · Jul 20, 2020 at 02:26 PM 0
Share

Updated article link: ISIN to RIC conversion with the TRTH

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Request Pagination issue with Standard Extractions venue files list

ThomsonReuters Request Examples

how to use the ElektronTimeseriesExtractionRequest to get the open price,settlement price

Equivalent Java Code for the C# code[Download Package Deliveries]

how to filter on multiple FIDs with TickHistory Raw Request?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges