Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
43 2 4 7

Received negative volume on June 24th from .AD.N ric

On June 24th, the volumes on NY were very high, with Advancing Volumes exceeding 2^31-1.

ric = “.AD.N”

fields = ['ISSUES_ADV','ISSUES_DEC','ISSUES_UNC','TOT_ISSUES','NEW_HIGHS','VOLUME_ADV','VOLUME_DEC','VOLUME_UNC','TOT_VOLUME','NEW_LOWS']


df,err = ek.get_data(ric,fields)

Returned in df:

{"Status":"Success","Data":{"Instrument":".AD.N","ISSUES_ADV":3486,"ISSUES_DEC":751,"ISSUES_UNC":245,"TOT_ISSUES":4482,"NEW_HIGHS":26,"VOLUME_ADV":-2147483648,"VOLUME_DEC":727025064,"VOLUME_UNC":47062337,"TOT_VOLUME":-2147483648,"NEW_LOWS":480}}

Advanced should be near 2,473,029,156 and total volume 3,400,054,220, not negative numbers

Is this a known issue?


eikon-data-apipythonvolume
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 @dgarrard

Thanks for reporting this. I have asked the EDAPI to comment on your observations.

Upvotes
Accepted
14k 30 5 10

hi @dgarrard ,

The resolution in case number 11368891 is mentioned below.

Our Content Team has already confirmed that TRTH on 24 Jun 2022 shows no negative values anymore.
We'd like to check if the client is still having issues with the data so we can further investigate.
We can get in touch with the client directly if need be for follow-up. 

It should be good now. However, please let us know if the issue still persists so we can do further investigation

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
78.1k 246 52 72

@dgarrard

I can replicate this issue with the ACVOL_1 and NUM_MOVES fields which have the same type and length as the TOT_VOLUME and VOLUME_ADV fields.

Yes, you are correct. The problem occurs if the values of those fields exceed 2147483647 (2^31 - 1).

1656423218033.png

The correct value of NUM_MOVES is 2147483648. :

1656423263749.png

I checked the raw data and found that Eikon sent -2147483648 to the API.

2022-06-28 20:36:24,078 P[3520] [MainThread 10636] HTTP Response: {"responses":[{"columnHeadersCount":1,"data":[["TRCCTEST05",2147483647,-2147483648,451.55,451.57]],"headerOrientation":"horizontal","headers":[[{"displayName":"Instrument"},{"displayName":"ACVOL_1","field":"ACVOL_1"},{"displayName":"NUM_MOVES","field":"NUM_MOVES"},{"displayName":"BID","field":"BID"},{"displayName":"ASK","field":"ASK"}]],"rowHeadersCount":1,"totalColumnsCount":5,"totalRowsCount":2}]}

My colleague has contacted the Eikon team to verify the problem.


1656423218033.png (14.7 KiB)
1656423263749.png (30.8 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.

Upvotes
25.3k 87 12 25

Hi @dgarrard

The Eikon API team will escalate this to the Eikon/Workspace Core team

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
43 2 4 7

Thank you for this. My client monitors these numbers daily and I will have her report to me if she sees any more neagtive numbers in hre future.

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.

You're welcome and thank you too.

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.