question

Upvotes
Accepted
Jake DeSantis_deprecated_0 avatar image
1 ●1 ●1 ●3

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

tick-history-rest-apitradecommoditiesquote
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

· Write an Answer
Upvotes
Accepted
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

@Jake DeSantis, 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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

@Jake DeSantis, 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 ...

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
mdziel avatar image
7 ●2 ●2 ●3

@ 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?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.