question

Upvotes
Accepted
21 0 0 3

Why do we have negative values for bid prices ?

EMA 3.6.3.1 Java

We receive negative values for Some Rics through EMA API.

We check with the Speed Guide Tool. We receive also the same negative values with this tool.

Can you check please an feedback ?

2.png1.png

IDRicNameBidPriceAskPriceLastPriceQuoteTimeNanos2043208/TESXH4-314

Jun 30 2023 03:03:07:024PM1980115/TESXH4-314

Jun 30 2023 03:03:07:024PM2043225/TESXM8-36284

Jun 30 2023 09:23:51:961AM1980132/TESXM8-36284

Jun 30 2023 09:23:51:961AM


Regards,

Jean,



ema-api#contentjava
1.png (17.7 KiB)
2.png (29.4 KiB)
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.

@jean.questiaux

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

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

Otherwise please post again offering further insight into your question.

Thanks,

AHS

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

Thanks,
AHS

Upvotes
Accepted
79.2k 251 52 74

@jean.questiaux @luc.dossche

I checked the historical data of TESXM8 and TESXH4 and found that the values of OPEN_BID were -36 and -3 respectively.

TESXM8,Market Price,2023-07-01T02:17:41.212498800Z,+2,Raw,REFRESH,,,,,8151,20,14767,,266
,,,,FID,1,,PROD_PERM,8151,
,,,,FID,2,,RDNDISPLAY,120,
,,,,FID,3,,DSPLY_NAME,TESX JUN8,
,,,,FID,4,,RDN_EXCHID,0,"   "
,,,,FID,5,,TIMACT,20:25:00.000000000,
,,,,FID,6,,TRDPRC_1,,
,,,,FID,7,,TRDPRC_2,,
,,,,FID,8,,TRDPRC_3,,
,,,,FID,9,,TRDPRC_4,,
,,,,FID,10,,TRDPRC_5,,
,,,,FID,11,,NETCHNG_1,,
,,,,FID,12,,HIGH_1,,
,,,,FID,13,,LOW_1,,
,,,,FID,14,,PRCTCK_1,,
,,,,FID,15,,CURRENCY,978,EUR
,,,,FID,16,,TRADE_DATE,,
,,,,FID,17,,ACTIV_DATE,2023-06-30,
,,,,FID,18,,TRDTIM_1,,
,,,,FID,19,,OPEN_PRC,,
,,,,FID,21,,HST_CLOSE,54,
,,,,FID,22,,BID,49,
,,,,FID,25,,ASK,59,
,,,,FID,30,,BIDSIZE,100,
,,,,FID,31,,ASKSIZE,100,
,,,,FID,32,,ACVOL_1,,
,,,,FID,41,,CONTR_MNTH,JUN8,
,,,,FID,42,,BLKCOUNT,,
,,,,FID,43,,BLKVOLUM,,
,,,,FID,53,,TRD_UNITS,2,"2DP "
,,,,FID,54,,LOTSZUNITS,54,UNITS
,,,,FID,56,,PCTCHNG,,
,,,,FID,57,,OPEN_BID,-36,
,,,,FID,59,,OPEN_ASK,284,
,,,,FID,60,,CLOSE_BID,49,
,,,,FID,61,,CLOSE_ASK,59,
...
...
TESXH4,Market Price,2023-07-01T03:50:38.863913874Z,+2,Raw,REFRESH,,,,,8151,20,15391,,266
,,,,FID,1,,PROD_PERM,8151,
,,,,FID,2,,RDNDISPLAY,120,
,,,,FID,3,,DSPLY_NAME,TESX MAR4,
,,,,FID,4,,RDN_EXCHID,0,"   "
,,,,FID,5,,TIMACT,20:25:00.000000000,
,,,,FID,6,,TRDPRC_1,,
,,,,FID,7,,TRDPRC_2,,
,,,,FID,8,,TRDPRC_3,,
,,,,FID,9,,TRDPRC_4,,
,,,,FID,10,,TRDPRC_5,,
,,,,FID,11,,NETCHNG_1,,
,,,,FID,12,,HIGH_1,,
,,,,FID,13,,LOW_1,,
,,,,FID,14,,PRCTCK_1,,
,,,,FID,15,,CURRENCY,978,EUR
,,,,FID,16,,TRADE_DATE,2023-03-28,
,,,,FID,17,,ACTIV_DATE,2023-06-30,
,,,,FID,18,,TRDTIM_1,,
,,,,FID,19,,OPEN_PRC,,
,,,,FID,21,,HST_CLOSE,12,
,,,,FID,22,,BID,10,
,,,,FID,25,,ASK,14,
,,,,FID,30,,BIDSIZE,100,
,,,,FID,31,,ASKSIZE,300,
,,,,FID,32,,ACVOL_1,,
,,,,FID,41,,CONTR_MNTH,MAR4,
,,,,FID,42,,BLKCOUNT,,
,,,,FID,43,,BLKVOLUM,,
,,,,FID,53,,TRD_UNITS,2,"2DP "
,,,,FID,54,,LOTSZUNITS,54,UNITS
,,,,FID,56,,PCTCHNG,,
,,,,FID,57,,OPEN_BID,-3,
,,,,FID,59,,OPEN_ASK,14,
...

Please contact the content support team directly via MyRefinitiv to verify the content.

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.

Upvote
1.5k 5 6 7

It is because the world of finance is bigger than just Equities and Bonds. :-)
I don't know what kind of financial instrument this is, but for some financial instruments, a negative value is a perfectly valid price. Also, even the value 0 (zero) is a valid value for a price of a financial instrument.

If you want an example: FX Swaps. (because the price of a FX Swaps expresses a differential it of course means it can be both negative, positive, or zero)

As a side note: The value 0 (zero) is even a tradable price. This is why it is so very very important no to use the zero value to indicate "no price", you have blank values for that.

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
1 0 0 0

Hi, after a check with the business, the Refinitiv value -3 isn't correct.

Can you tell us what to do for receiving the correct on ?

SpeedGuide generates the same value.

ID


RicName

RicName DS

Bid DS

Ask DS

BidPrice

AskPrice

LastPrice

PriceTime DS

QuoteTimeNanos

2043208


TESXH4

TESXH4

10

14

-3

14


30/06/2023 15:03:07

Jun 30 2023 03:03:07:024PM

1980115


TESXH4

TESXH4

10

14

-3

14


30/06/2023 15:03:07

Jun 30 2023 03:03:07:024PM

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.