Get opening quote price for all identifiers for each trading day

Hi everyone,
It seems like that when I do an API call to TickMarketDepthData with a list of identifiers, I don't get/see all identifiers in the API response. Could there be that some identifiers don't trade on specific days, so there is no price change and hence there are no mentions of those identifiers in the results? If that is the case, is there a way I could get the Opening price for each identifier for each trading day through some other API endpoints?
Example of the issue I mentioned above:
list_of_identifiers = [{'Identifier': 'ES1000C8', 'IdentifierType': 'Ric'},
{'Identifier': 'ES1000F8', 'IdentifierType': 'Ric'},
{'Identifier': 'ES1000I7', 'IdentifierType': 'Ric'}]
result = trth.extractions.tick_market_depth_data(
identifiers=list_of_identifiers,
fields=['Ask Price', 'Bid Price'],
start=dt.datetime(2017, 9, 14),
end=dt.datetime(2017, 9, 15)
levels=3,
)
print(result.text) => this will return only market data for {'Identifier': 'ES1000I7', 'IdentifierType': 'Ric'}
Best Answer
-
Hi @ivan.lovrencic ,
Looking into the results for these instruments on my side with ValidationOptions (I have run naked request with Postman, as it was quicker) - there appears to have been a HALT in trading on the first two instruments on that day:
#RIC,Domain,Date-Time,GMT Offset,Type,MsgClass/FID number,UpdateType/Action,FID Name,FID Value,FID Enum String,PE Code,Template Number,Key/Msg Sequence Number,Alias Underlying RIC,Market Depth RIC,Number of FIDs
ES1000C8,Market Price,2017-09-14T20:15:00.158552622Z,-5,Legacy Level 2,UPDATE,UNSPECIFIED,,,,4269,,336,,ES1000C8m,2
,,,,FID,6517,,HALT_REASN,0,
,,,,FID,6615,,HALT_RSN,0," "
ES1000C8,Market Price,2017-09-14T20:29:30.125826671Z,-5,Legacy Level 2,UPDATE,UNSPECIFIED,,,,4269,,352,,ES1000C8m,2
,,,,FID,6517,,HALT_REASN,0,
,,,,FID,6615,,HALT_RSN,0," "In my understanding, this should be the reason why there was no BIDs and ASKs, to learn more you may wish to engage with Refinitiv content experts directly vi Refinitiv Helpdesk Online -> Content -> DSS
0
Answers
-
Hello @ivan.lovrencic ,
All 3 instruments appear to be historical, in the Extraction Notes I see
"...\nHistorical Instrument <RIC,ES1000C8> expanded to 1 RIC: ES1000C8.\nHistorical Instrument <RIC,ES1000F8> expanded to 1 RIC: ES1000F8.\nHistorical Instrument <RIC,ES1000I7> expanded to 1 RIC: ES1000I7.\nTotal instruments after instrument expansion = 3..."
Therefore, ValidationOptions are required to request:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest",
"ContentFieldNames": [
"Ask Price",
"Ask Size",
"Bid Price",
"Bid Size"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "ES1000C8", "IdentifierType": "Ric" },
{ "Identifier": "ES1000F8", "IdentifierType": "Ric" },
{ "Identifier": "ES1000I7", "IdentifierType": "Ric"}
],
"ValidationOptions": {
"AllowHistoricalInstruments": true,
"AllowInactiveInstruments": true
},
"UseUserPreferencesForValidationOptions": false
},
"Condition": { ...With .NET SDK:
IdentifierList = InstrumentIdentifierList.Create(
new[]
new InstrumentIdentifier { Identifier = "ES1000C8", IdentifierType = IdentifierType.Ric }
},
new InstrumentValidationOptions
AllowHistoricalInstruments = true
},
false),Find more detail on .NET SDK in Refinitiv DSS C# Example Application
0 -
Hi @zoya faberov , thank you so much for your fast reply!
I added these fields to my request, but unfortunately, it did not help. For some reason, the last identifier is still the only one that returns some data, while the first two don't show up in the response.
Does it work for you? Maybe, it's something with my code.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 249 ETA
- 554 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛