question

Upvotes
Accepted
100 14 15 20

Why TR_TRD_FLG value doubled quoted in TRTH normalized

We noticed that only TR_TRD_FLG value is doubled quoted, see below example:

"R[ACT_FLAG1];R[CONDCODE_1];[CONDCODE_2];N [ELIGBL_TRD];Off Book Trades[USER];""RX ""[TR_TRD_FLG];45------MP----[MMT_CLASS]"

Are there reasons for that?

Also some values are white space trimmed (like ACT_FLAG1), while some others are not (N [ELIGBL_TRD]). Just curious why it's this way.

Thanks


#producttick-history-rest-apihistoricaltrth-rest-apimarket-price
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.

Hello @jzhao ,

Please share the complete request that you submit to RTH, it will help us to reproduce what you see and to see what we can find.

@jzhao

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

<AHS>

case 11347932 is still in progress, extending triage for a week.

<AHS>

case 11347932 is still in progress, extending triage for a week.

<AHS>

case 11347932 is still in progress, extending triage for a week.

Show more comments

1 Answer

· Write an Answer
Upvotes
Accepted
78.8k 250 52 74

@jzhao

I checked and found that the double quotes of [TR_TRD_FLG] could be a bug in the API. I found a similar case raised by another client.

You can raise this issue to the Refinitiv Tick History Support team directly via MyRefinitiv to verify this problem.

These fields are real-time fields. Their definitions are defined in the Data Model Discovery.

The ELIGBL_TRD and TR_TRD_FLG are enumeration fields. Their values could be:

ELIGBL_TRD 12840
!
! VALUE      DISPLAY   MEANING
! -----      -------   -------
      0        "   "   undefined
      1        "Y  "   Last Trade is eligible
      2        "N  "   Last Trade is ineligible


TR_TRD_FLG 13432
CAN_TRTFLG 13489
!
! VALUE      DISPLAY   MEANING
! -----      -------   -------
      0      "     "   undefined
      1      "OB   "   Order Book
      2      "OH   "   Order Book - Hidden
      3      "AU   "   Auction Trades
      4      "DK   "   Dark order book trades
      5      "RX   "   Real time On exchange reported trades

I think this is why there are spaces in their values.


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.

Hi Jirapongse,

I opened a support ticket Case : 11347932, and it's still open and I'm awaiting the answer. Thank you.

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.