question

Upvotes
Accepted
jeremy.mayes avatar image
1 ●1 ●2 ●2

ACVOL_1 drifts away from cumulative TRDVOL

Hi,

I was observing the TRDVOL_1 / ACVOL_1 fields for ANHJ.J on 2021-03-29 and saw that at a few times during the day, trades came in that never seemed to be reflected in ACVOL_1. I was keeping a running tally of total TRDVOL_1 and comparing to ACVOL_1. Naturally, they deviate as trades are reported, but, usually ACVOL_1 catches up quickly. However, at 08:16:20 (CDT), a trade of size 230 comes through and we never see ACVOL_1 catch up after that. It is off by 230 until another similar event at 08:58:04 (CDT) which further adds to the discrepancy.


Did I miss a correction event or is something else going on?

elektronrefinitiv-realtimeelektron-sdkrrteta-apielektron-transport-apivolume
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.

Jirapongse avatar image   Jirapongse

@jeremy.mayes

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

Jirapongse avatar image   Jirapongse

@jeremy.mayes

Hi,

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@jeremy.mayes

I have verified the historical data of ANHJ.J and found those two trade volumes at 2021-03-29T13:16:20 GMT and 2021-03-29T13:58:03 GMT.

ANHJ.J,Market Price,2021-03-29T13:16:20.633226978Z,+2,Raw,UPDATE,TRADE,,,,92,,23790,,37
,,,,FID,3426,,ORDER_ID,,
,,,,FID,1667,,GN_TX20_3,,
,,,,FID,13432,,TR_TRD_FLG,5,"RX   "
,,,,FID,12840,,ELIGBL_TRD,2,"N  "
,,,,FID,5,,TIMACT,13:16:00.000000000,
,,,,FID,6,,TRDPRC_1,95260,
,,,,FID,178,,TRDVOL_1,230,
...
...
ANHJ.J,Market Price,2021-03-29T13:58:03.769904160Z,+2,Raw,UPDATE,TRADE,,,,92,,7150,,37
,,,,FID,3426,,ORDER_ID,,
,,,,FID,1667,,GN_TX20_3,,
,,,,FID,13432,,TR_TRD_FLG,5,"RX   "
,,,,FID,12840,,ELIGBL_TRD,2,"N  "
,,,,FID,5,,TIMACT,13:58:00.000000000,
,,,,FID,6,,TRDPRC_1,95926.5,
,,,,FID,178,,TRDVOL_1,197,
,,,,FID,975,,ACT_FLAG1,X,

I have compared the data with other trade volumes that reflect the ACVOL_1 field.

ANHJ.J,Market Price,2021-03-29T13:17:18.966073252Z,+2,Raw,UPDATE,TRADE,,,,92,,23902,,26
,,,,FID,13432,,TR_TRD_FLG,1,"OB   "
,,,,FID,12840,,ELIGBL_TRD,1,"Y  "
,,,,FID,5,,TIMACT,13:17:00.000000000,
,,,,FID,3885,,ORDBK_TRD,95254,
,,,,FID,14676,,OB_TRD_NS,13:17:18.835000000,
,,,,FID,1031,,GEN_VAL7,95254,
,,,,FID,11,,NETCHNG_1,1354,
,,,,FID,56,,PCTCHNG,1.44,
,,,,FID,6,,TRDPRC_1,95254,
,,,,FID,178,,TRDVOL_1,69,

I found that the values of TR_TRD_FLG and ELIGBL_TRD fields are different.

The values of those fields of the reported trades are:

,,,,FID,13432,,TR_TRD_FLG,5,"RX   "
,,,,FID,12840,,ELIGBL_TRD,2,"N  "

However, the values of those fields of the normal trades are:

,,,,FID,13432,,TR_TRD_FLG,1,"OB   " 
,,,,FID,12840,,ELIGBL_TRD,1,"Y  "

The definitions of those fields are:

TR_TRD_FLG "TR TRADE FLAG"      13432  NULL        ENUMERATED    5 ( 5 )  ENUM             2
!
! Enumerated Normalised Categorisation of trades for any trade price 
! field(e.g.TRDPRC_1 IRGPRC, OFFBKPRC, PDTRDPRC etc.)
!
...
ELIGBL_TRD "ELIGIBLE TRD FLAG"  12840  NULL        ENUMERATED    3 ( 3 )  ENUM             1
!
! Defines whether the last trade update to any trade price field (e.g.TRDPRC_1 IRGPRC, 
! OFFBKPRC, INSPRC etc.) is last eligible i.e. can populate the open, high, low or 
! close.
!

The meanings of those values are:

!
! ACRONYM    FID
! -------    ---
!
ELIGBL_TRD 12840
!
! VALUE      DISPLAY   MEANING
! -----      -------   -------
      0        "   "   undefined
      1        "Y  "   Last Trade is eligible
      2        "N  "   Last Trade is ineligible
...
!
! ACRONYM    FID
! -------    ---
!
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
      6      "DX   "   Delayed On exchange reported trades

I assume that I may relate to the values in these fields. To confirm it, please directly contact the content support team via MyRefinitv.

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.