missing data for field "Trade - Bid Price" and "Trade - Ask Price"
I am extracting data for RIC="CLZ7" (Crude Oil Futures contract).
I would like to receive return rows in which all of the following fields filled:
"Trade - Bid Price","Trade - Price",
"Trade - Ask Price","Trade - Volume",
"Trade - Exchange Time"
However the "Trade - Bid Price" and "Trade - Ask Price" fields are always returned blank.
I understand that I can use the fields "Quote - Bid Price" and "Quote - Ask Price" to retrieve Bid and Ask Prices before and after the trade, but these Bids and Asks are returned in separate rows from the "Trade" data. While it is possible to accomplish what I'd ultimately like to accomplish with post-extraction processing, extractions that include "Quote - []" fields are orders of magnitude larger than extractions that include only "Trade - []" fields and I'd like to avoid extracting this extraneous information and avoid highly inefficient extractions.
-Jake
Best Answer
-
@Jake DeSantis_deprecated_0, really sorry, this slipped my attention. Here is the answer from the support team: this is as intended, what TRTH v2 delivers aligns with what was delivered by TRTH v1.
0
Answers
-
@Jake DeSantis_deprecated_0, I observe the same as you, also with other instruments.
I escalated the issue to try to find out why. It looks like you might have to use the Quote fields, even though I agree this is not ideal ...
0 -
@Christiaan Meihsl I noticed that from 2019 onwards, the "Trade - Bid Price" and "Trade - Ask Price" fields are actually populated. (at least for EX, FV and VX futures) Any chance to get them backfilled further back into the past?
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
- 687 Datastream
- 1.4K DSS
- 623 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 557 WebSocket API
- 38 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
- 276 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
- 682 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
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 105 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 91 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛