Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Refinitiv Data Platform /
avatar image
Question by philippe.soleri · Jan 18 at 01:24 PM · workspaceworkspace-data-apirics

How to find RIC Refinitiv identifiers from eMAXX’s CINS identifiers for the same bond issue list?

How to link eMAXX (CINS) identifiers to their Refinitiv Workspace (RIC) identifiers?

For example, the CINS "N7280EA", which corresponds to the 9-digit CINS "N7280EAK6", exists in the Refinitiv Workspace database, and corresponds to the RIC NL030415957 (which I can check manually), but I cannot retrieve this information automatically.

It’s extremely embarrassing, because it has a very detailed price history, for example, that I can’t recover unless I check each of the 150,000 items on the list by hand.

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.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by nick.zincone · Jan 18 at 02:08 PM

Hi @philippe.soleri

The RDP (Refinitiv Data Platform) symbology endpoint (/discovery/symbology/v1/lookup) found within the API Playground provides a way to programmatically convert a CINS value to multiple RIC identifiers. For example:

{
  "from": [
    {
      "identifierTypes": ["CinsNumber"],
      "values": ["N7280EAK6"]
    }
  ],
  "to": [
    {
      "identifierTypes": ["RIC"]
    }
  ],
  "type": "auto"
}
Comment
wasin.w

People who like this

1 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
philippe.soleri · Jan 18 at 02:22 PM 0
Share

Thanks a lot

avatar image
REFINITIV
Answer by umer.nalla · Jan 18 at 02:13 PM

Hi @philippe.soleri

Do you have access to the RDP Symbology API?

For example, on the API Playground using for the Symbology API lookup API - https://api.refinitiv.com/discovery/symbology/v1/lookup

If I try the following lookup:

{
  "from": [
    {
      "identifierTypes": [
        "CinsNumber"
      ],
      "values": [
        "N7280EAK6"
      ]
    }
  ],
  "to": [
    {
      "identifierTypes": [
        "PreferredRIC"
      ]
    }
  ],
  "reference": [
    "name",
    "status",
    "classification"
  ],
  "type": "strict"
}

I get a response (I have truncated) - which includes the RIC NL030415957=

 {
  "data": [
    {
      "input": [
        {
          "value": "N7280EAK6",
          "identifierType": "CinsNumber"
        }
      ],
      "output": [
        {
          "value": "NL030415957=",
          "identifierType": "PreferredRIC",
          "name": "4.75%STR 2007-2022 EMTN",
          "status": "Active",
          "classification": "Short / Medium Term Notes"
        }
      ]
    }
  ],
  "requestId": "9c04a24d-02ec-4970-adcd-95369c20d243",
  "effectiveAt": "2022-01-18T14:07:08.126Z",
  "messages": []
}

Assuming you are licenced for the Symbology API, you should be able to bulk convert your CINS to RICs using a script.

For instance, the following simple example converts ISINs read from a file to RICs -

Refinitiv-API-Samples/Example.RDPLibrary.Python.ConvertSymbology: Simple notebook to convert ISINs (or other Symbology) to RICs using the Refinitiv Data Platform Symbology API (github.com)

You should be able to modify the script to convert Cins to Rics. Although, I expect you will have to split your requests into much smaller batches of your 150,000 items.

Comment
wasin.w

People who like this

1 Show 0 · 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
Answer by philippe.soleri · Jan 18 at 02:23 PM

Thanks a lot

Comment

People who like this

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

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 >
10 People are following this question.

Related Questions

Volatility surfaces for japanese equities?

Force logout

Is there a logic or guidance on when to use spot/Cross/Refinitiv RIC while constructing RIC Code for forex ?

Decode chain RIC using Refinitiv Data Platform with C#

How to find out when RIC codes will be changed or updated by using RFA C++?

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges