How to convert the different identifier codes like CUSIP, Sedol , ISIN to RIC and then sent to EMA
Best Answer
-
Hello @Chaitanya.Vishnubhotla,
As I mentioned earlier in this thread that DataScope Select (DSS) can resolve other identifier types to RIC. This name resolving step has to be done before you use real-time APIs, so this topic might not relate to EMA API directly.
Anyway, I will demonstrate how to do name resolving by DSS Web GUI.
To start with it, I prefer using public data from Thailand Stock Exchange (SET) that I’m familiar with.
If you click the previous link, it will lead to a page which tries to describe that Thailand Stock Exchange uses ISIN as an identifier of each security.
Next, the tutorial in the other thread that I suggested previously; REST API Tutorial 11: Search by Instrument will show you how to search an instrument using various identifier types. It also mentions about DSS web GUI that I’m going to use it here.
To access DSS web GUI, you need to have your login credential. Please contact your account team for yours.
- 1. Once I logged into it, click a DSS Home menu to use the GUI application.
- 2. After that, click a DATA SCOPE SELECT dropdown > Search. It’ll show a query form.
- 3. Now, I copy one of ISIN Codes (i.e. I used a Government bond: CB17502A for this example) from the excel from Thailand Stock Exchange to this web form, select identifier type as ‘ISIN’ and click the Search button.
- 4. Then, this website gave me three RICs that can be used to subscribed to real-time feed: Elektron.
From the previous steps, I have CB17502A=TS, THCB17502A=, and THCB17502A=RRPS. I’ll try to pass them to EMA; the real-time API.
consumer.registerClient(reqMsg.clear().serviceName("<<service name>>").name("CB17502A=TS"), appClient);
consumer.registerClient(reqMsg.clear().serviceName("<<service name>>").name("THCB17502A="), appClient);
consumer.registerClient(reqMsg.clear().serviceName("<<service name>>").name("THCB17502A=RRPS"), appClient);Finally, I get three results from Elektron as follows:
RefreshMsg
Note: If you have a chance to try, please pick an ISIN Code that its issue date is not in the future because DSS may not be updated (in this case, some Bonds already have ISIN Codes, but they haven’t issued to the public yet).
streamId="5"
domain="MarketPrice Domain"
solicited
RefreshComplete
state="Open / Ok / None / 'All is well'"
itemGroup="00 0f"
permissionData="03 08 43 31 65 c0"
name="CB17502A=TS"
nameType="1"
serviceId="2115"
serviceName="API_ELEKTRON_EPD_RSSL"
Payload dataType="FieldList"
FieldList FieldListNum="186" DictionaryId="1"
FieldEntry fid="1" name="PROD_PERM" dataType="UInt" value="3165"
FieldEntry fid="2" name="RDNDISPLAY" dataType="UInt" value="152"
FieldEntry fid="3" name="DSPLY_NAME" dataType="Rmtes" value="CB17502A "
...
RefreshMsg
streamId="6"
domain="MarketPrice Domain"
solicited
RefreshComplete
state="Open / Ok / None / 'All is well'"
itemGroup="00 0f"
permissionData="03 08 43 24 94 c0"
name="THCB17502A="
nameType="1"
serviceId="2115"
serviceName="API_ELEKTRON_EPD_RSSL"
Payload dataType="FieldList"
FieldList FieldListNum="26" DictionaryId="1"
FieldEntry fid="1" name="PROD_PERM" dataType="UInt" value="2494"
FieldEntry fid="2" name="RDNDISPLAY" dataType="UInt" value="152"
FieldEntry fid="3" name="DSPLY_NAME" dataType="Rmtes" value="CB17502A "
...
RefreshMsg
streamId="7"
domain="MarketPrice Domain"
solicited
RefreshComplete
state="Open / Ok / None / 'All is well'"
itemGroup="00 04"
permissionData="03 08 43 70 65 c0"
name="THCB17502A=RRPS"
nameType="1"
serviceId="2115"
serviceName="API_ELEKTRON_EPD_RSSL"
Payload dataType="FieldList"
FieldList FieldListNum="26" DictionaryId="1"
FieldEntry fid="1" name="PROD_PERM" dataType="UInt" value="7065"
FieldEntry fid="2" name="RDNDISPLAY" dataType="UInt" value="152"
FieldEntry fid="3" name="DSPLY_NAME" dataType="Rmtes" value="BANK OF THAILAND"
...Hope this helps.
0
Answers
Categories
- All Categories
- 6 AHS
- 38 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛