Market identifier codes
Hi there,
I am using TRTH API to retrieve tick history for equity names. For each trade, I want to have the venue where the trade occurred. Can you please show me which field I should look at? I see "Trade - Exchange/Contributor ID" only. But the field doesn't return MIC but some code I cannot recognize. Is there a field that returns MIC directly? If not, do you have any doc that maps "Trade - Exchange/Contributor ID" to MIC? Can you please share?
Thank you
Liang
Best Answer
-
Hello @Liang Ge and @ankur.tyagi,
I do not see this information included in Refinitiv Tick History Data Coverage Guide -> Fields that includes all available fields with their descriptions, structured per report template.
However, in case there is a way to derive this information, from one of the available fields, that is not obvious to a developer, I would suggest to verify directly with Refinitiv content experts, by submitting the question on Refinitiv Helpdesk Online -> Content -> RTH and including the details of the content required.
0
Answers
-
Hello @Liang Ge and @ankur.tyagi,
In my understanding, MIC is assigned per instrument rather then per Tic. So in addition to TickHistoryTiemAndSales extraction request of the required ticks, one could request reference data per every instrument, including MIC, maybe TermsAndConditions request would be suitable for this purpose, for example:
{{protocol}}{{host}}{{api}}Extractions/ExtractWithNotes
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC", "Maturity Date", "MIC"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "US30YT=RR", "IdentifierType": "Ric" }
]
}
}
}Resulting in:
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "US30YT=RR",
"RIC": "US30YT=RR",
"Maturity Date": "2051-11-15",
"MIC": "BTEC"
}
],
...However, for an in-depth consultation on content requirements, I suggest to contact Refinitiv content experts directly, by submitting the question on Refinitiv Helpdesk Online -> Content -> RTH and including the details of the content required.
0 -
Hi @zoya faberov,
I think you misunderstood what I asked for. What I asked for is the tag 30 for each trade. E.g. 100 shares executed at New York stock exchange. When I used TRTH API to retrieve the trade info, I see "NYS", which I believe stands for new york stock exchange, populated for the field "Trade - Exchange/Contributor ID". In FIX protocol world, we usually have "XNYS", a standard mic code, for new york stock exchange. My question is - it there other field in TRTH that can return the mic code for each trade?
Best,
Liang
0
Categories
- All Categories
- 6 AHS
- 39 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 中文论坛