Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Elektron /
  • ETA /
avatar image
Question by Ypar · Jul 18, 2017 at 03:55 PM · elektronrefinitiv-realtimeelektron-sdkrrteta-apielektron-transport-apifields

How should blank values be handled?

This is a general question with a specific case as example.

Should blank values in fields that normally should not be blank, be considered an error? Should we just ignore the field? Should it be 0 (or equivalent for the data type)?

In my particular case, I have an unspecified event that would normally represent a trade, except for the presence of a quote price & qty field that are blank. The easy solution would be to ignore fields with blank values in this case, but how general is this solution? Should it be a solution only for unspecified events? Any event? Any field? Any data type?

Stream RBU7-X7 --- RSSL_MC_UPDATE/RDM_UPD_EVENT_TYPE_UNSPECIFIED field values
   TIMACT (5)                18:18:00:000:000:000
   TRDTIM_1 (18)             18:18:00:000:000:000
   ACT_TP_1 (270)             Þ (2)
   SC_ACT_TP1 (280)           + (1)
   TRDPRC_1 (6)              0.1323
   PRIMACT_1 (393)           0.1323
   NETCHNG_1 (11)            0.0062
   SEC_ACT_1 (275)           0.0062
   PRCTCK_1 (14)             Þ (1)
   ACVOL_1 (32)              1935
   PCTCHNG (56)              4.92
   NUM_MOVES (77)            1234
   ASK (25)                  <<blank>>
   ASKSIZE (31)              <<blank>>
   TRDVOL_1 (178)            38
   SALTIM (379)              18:18:32:000:000:000
   SEQNUM (1021)             63235757

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

2 Replies

  • Sort: 
avatar image
Best Answer
Answer by Ypar · Aug 10, 2017 at 10:14 AM

So what I figured is that blank values can sometimes mean something. I still have not figured out what they would mean in my example above, but in other cases, they tell you indirect information about the data. E.g. For futures, a blank "number of orders" indicates an implied order.

So my conclusion is that blank values should be ignored (as if the tag was not part of the data set) unless otherwise stated and the information they provide is needed.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by warat.boonyanit · Jul 20, 2017 at 05:23 AM

Hi @Ypar

You should never treat a blank field as zero.

Blank field means you should clear the field, no value, just blank.

The actual reason behind the clearing differs case by case. But in your particular case, you have to look at the bigger picture.

RBU7-X7	Market Price	2017-07-18T18:18:30.098416602Z	UPDATE	UNSPECIFIED
	FID	25		ASK		0.1322
	FID	31		ASKSIZE		4
	FID	3264		PRC_QL3		339
...
...
BU7-X7	Market Price	2017-07-18T18:18:32.717695993Z	UPDATE	UNSPECIFIED
	FID	5		TIMACT		18:18:00
	FID	18		TRDTIM_1	18:18:00
	FID	270		ACT_TP_1	2
	FID	280		SC_ACT_TP1	1
	FID	6		TRDPRC_1	0.1322
	FID	393		PRIMACT_1	0.1322
	FID	11		NETCHNG_1	0.0061
	FID	275		SEC_ACT_1	0.0061
	FID	14		PRCTCK_1	1
	FID	32		ACVOL_1		1897
	FID	56		PCTCHNG		4.84
	FID	77		NUM_MOVES	1233
	FID	178		TRDVOL_1	4
	FID	379		SALTIM		18:18:32
	FID	1021		SEQNUM		63235757
RBU7-X7	Market Price	2017-07-18T18:18:32.718579330Z	UPDATE	UNSPECIFIED
	FID	5		TIMACT		18:18:00
	FID	18		TRDTIM_1	18:18:00
	FID	270		ACT_TP_1	2
	FID	280		SC_ACT_TP1	1
	FID	6		TRDPRC_1	0.1323
	FID	393		PRIMACT_1	0.1323
	FID	11		NETCHNG_1	0.0062
	FID	275		SEC_ACT_1	0.0062
	FID	14		PRCTCK_1	1
	FID	32		ACVOL_1		1935
	FID	56		PCTCHNG		4.92
	FID	77		NUM_MOVES	1234
	FID	25		ASK	
	FID	31		ASKSIZE	
	FID	178		TRDVOL_1	38
	FID	379		SALTIM		18:18:32
	FID	1021		SEQNUM		63235757
RBU7-X7	Market Price	2017-07-18T18:18:32.718579330Z	UPDATE	UNSPECIFIED
	FID	25		ASK		0.1323
	FID	31		ASKSIZE		38
	FID	3264		PRC_QL3		339
RBU7-X7	Market Price	2017-07-18T18:18:32.718579330Z	UPDATE	UNSPECIFIED
	FID	25		ASK		0.1324
	FID	31		ASKSIZE		13
	FID	3264		PRC_QL3		339

The trade is filling two prices. You could see that the SEQNUM are the same.

The blank was sent because this trade fills multiple prices.

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Ypar · Jul 20, 2017 at 09:12 AM 0
Share

Because it "fills multiple prices" makes no sense to me as a reason to add quote fields to a trade event, independently of their values. I see no sane justification there.

Aside from that, what I am understanding from your response is that we should just ignore blank values as if the fields were not even present.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
8 People are following this question.

Related Questions

ETA: request a view, but get an error: State: Open/Ok/Invalid view - text: "All is well"

Meaning of ACVOL_1 when no trade details are ever present.

is there an example of single threaded code with ETA

ETA Contribution Error

Does ETA API send a warning message before disconnecting a client ?

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges