how to find field that returns the same value with illogical ones

Hello
There's one more thing I'd like to ask.
First of all, the field values we received in the early days are as follows.

GEN_VAL2

GEN_VAL4

GEN_VAL6

CLOSE1

OPINT_1

ACVOL_1

HST_CLOSE

PRIMACT_1

TRDPRC_1

ASK

PRV_LAST

OFF_CLOSE

SEC_ACT_1

And you told me in the previous question that it would be better not to use these because they are illogical.
Then what I'm curious about is how to find a proper field value that matches this illogical field value.
Of course, you said before that not all illogical fields match, but I still wonder how many of these fields match properly.
If the illogical fields depend on the instrument value, I will also convey it additionally.
Thank you.

Find more posts tagged with

fields

eikon-data-api

illogical-fid

Accepted answers

nick.zincone

Hi @jwlee08,

The logic behind defining a value of zero vs NA is that NA represents there has been no value defined for the field. For example, in a normal trading day, numerical values can range, depending on the field. A value of 0 has meaning, such as a net change of zero. During the closing run for a specific exchange, they typically set specific values to NA, meaning those values are reset as having no activity. Hope this makes sense.

All comments

raksina.samasiri

Hi @jwlee08 ,

Thank you for participating in this forum. However, The members of the developer's community and the moderators of the forum may have some understanding of the content involved. We aim to answer the question if our answer can be of help.

However, an in-depth understanding of specific content requires the knowledge of an expert in that content area. As our customer, you can tap this expertise by opening a case via Content Helpdesk Online or calling your local Refinitiv support number. The option to pick is ' i need help identifying content".

nick.zincone

hI @jwlee08

I would also recommend you spend some time familiarizing yourself with the Data Discovery Tool. You can find the link from the home page of the Developer Community. The tool is quite detailed and comprehensive covering the FIDs and details around the illogical use. You may have questions around the use of this tool and how to get the most out of it. If the tool is something that you would like to investigate more, I would recommend when you do reach out to the helpdesk, they should be able help with its use.

jwlee08

Hello, @nick.zincone
I accepted the advice you gave me, so I'm proceeding a little now.
By the way, can you explain the case where the context id value is 0 or <NA> as shown in the picture below?

nick.zincone

Hi @jwlee08,

EXPLORE OUR SITES