Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by rtc_data · Dec 11, 2018 at 06:42 AM · ric lookupticker

how to map exchange ticker to RIC on a given date

RIC may change for some stock ticker, so how can I get RIC on a given date?

One case is that Lastest RIC for 1686 in HKG is 1686.HK, while RIC before 2018-01-19 is 8008.HK

Is there some way to retrieve RIC for ticker+date

People who like this

0 Show 0
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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Dec 12, 2018 at 09:26 AM

@rtpublic,

I did not find a way to retrieve the RIC for ticker+date, but there are ways to find out if and when a RIC changed. I'm aware this does not really answer your need, but maybe it can help ?

Learning about recent name changes when running extractions

When you run an extraction, you should look at the maintenance notes. You will find them in a separate file if you run a scheduled extraction, but they are at the end of the extraction notes if you run an On Demand request. The maintenance notes tell you about name changes that have occurred over the last 10 days, which allows you to adapt your instrument lists accordingly. More information on the maintenance notes can be found here.

For any date in time

Use the Historical Reference functionality. Caveat: I'm not sure if this is available to you if you are a DSS customer, it might be restricted to TRTH customers.

In the GUI: start with a historical search. If you search for 8008.HK (1) over the entire date range (1996 till now) it will tell you that it has changed to 1686.HK (2). Clicking on Reference History (3) will give the details, we see the change of RIC on 22 Jan 2018 (4):

In the API, here is the request body (sent with a POST to Extractions/ExtractWithNotes):

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
        "ContentFieldNames": [ "RIC", "Ticker", "Change Date" ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [ { "Identifier": "8008.HK", "IdentifierType": "Ric" } ],
            "ValidationOptions": {"AllowHistoricalInstruments": true},
            "UseUserPreferencesForValidationOptions": false
        },
        "Condition": {
            "ReportDateRangeType": "Range",
            "QueryStartDate": "1996-01-01",
            "QueryEndDate": "2018-12-11"
        }
    }
}

The response contains many data elements, you will find several with RIC 8008.HK and several for 1686.HK. The oldest record that mentions 1686.HK tells us there was a RIC change:

        {
            "IdentifierType": "Ric",
            "Identifier": "8008.HK",
            "RIC": "1686.HK",
            "Ticker": "1686",
            "Change Date": "2018-01-20"
        },

Older records show the original RIC was 8008.HK:

        {
            "IdentifierType": "Ric",
            "Identifier": "8008.HK",
            "RIC": "8008.HK",
            "Ticker": null,
            "Change Date": "2002-10-19"
        },

The response using the API will be the same if you run the request for 8008.HK or 1686.HK, but will not return data if you use the ticker.


8008.png (60.6 KiB)
Comment

People who like this

0 Show 4 · 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
rtc_data · Dec 18, 2018 at 02:02 AM 0
Share

It almost solve my question but some special cases

I send request through API following your sample code for '7327.T', and the result do not make sense.

According to the response, RIC change from 8324.T to 7327.T on 2018-09-06, then back to 8324.T on 2018-09-27, and change to 7327.T again on 2018-09-28?

qa1.png (12.4 KiB)
qa2.png (10.4 KiB)
avatar image
REFINITIV
veerapath.rungruengrayubkul ♦♦ rtc_data · Dec 19, 2018 at 03:35 AM 0
Share

This could be related to this Data Notification. For further questions, please contact data specialist via MyRefinitiv as suggested by Christiaan.

avatar image
REFINITIV
Christiaan Meihsl ♦♦ veerapath.rungruengrayubkul ♦♦ · Dec 19, 2018 at 03:45 AM 0
Share

Data Notification: well spotted ! :-)

avatar image
REFINITIV
Christiaan Meihsl ♦♦ · Dec 18, 2018 at 10:21 AM 0
Share

@rtpublic, hmmm, that's an interesting one. I see the same.

The API is not at fault, the GUI also shows the ISIN going back and forth, so this must be related to the underlying data:

To get data now in Eikon I must use 7327.T, so that is definitely the current RIC. But I cannot explain this specific case, I'm no data specialist.

This forum is for software developers using Refinitiv APIs, and technical discussions. For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via MyRefinitiv or to call the Refinitiv Help Desk directly.

7327t.png (44.2 KiB)

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

Chain RICs for futures contracts 2 Answers

How to know if there was a change in ricname ? 1 Answer

How to perform on-demand Terms and Conditions extract using IdentifierType.Ticker 2 Answers

Search for RICs by Bloomberg ID/Identifier 2 Answers

OLD RIC codes 2 Answers

  • 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
  • Elektron Data Platform
  • 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
  • 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
  • Explore
  • Tags
  • Questions
  • Badges