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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aquilesjlp300 avatar image
98 ●10 ●21 ●27

Getting null values for prices and volumes.

Hi,

I'm using get_timeseries() to acquire prices and volumes timestamp sensitive. For confirmed transactions, I'm getting values that I shouldn't be getting (null values).

I say we shouldn't be getting them since the transaction has occurred, therefore the price and the volume should be reported, yet I've encountered with some specific cases like the ones in these screenshots that I would like to get some help to solve and spot what the issue could be.


First example:


Second example:


What could be the reason for this happening and how can we fix it? Happy to hear any suggestions.

And thanks a lot for the help you always provide throughout this forum.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
pierre.faurel avatar image
4.3k ●2 ●4 ●5

screenshots are not available (don't know why !?) but I assume that null values were retrieved as soon as the limit of datapoints is reached.

The response to any single get_timeseries request for timeseries interval is limited to 3K rows.

For more information, please refer to this question.

icon clock
10 |1500

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

aquilesjlp300 avatar image aquilesjlp300

Thanks for the reply and sorry to wait so long to answer back. Is extremely weird the screenshots can't be seen (I'm seeing them now).

I'll post them here again if you don't mind:


And this one:

1570893779526.png (27.3 KiB)
1570893813001.png (27.0 KiB)
pierre.faurel avatar image pierre.faurel aquilesjlp300

It isn't a result due to a limited size result (server still returns null values if range of date is limited).

I suggest to contact the Eikon support for deeper investigation.

chavalit-jintamalit avatar image chavalit-jintamalit aquilesjlp300

Hi @aquilesjlp300

I just re-checked the data using Eikon Excel.

And I got the same data point either from Eikon Data APIs or Eikon Excel.


You can contact Refinitiv Content Helpdesk at https://my.refinitiv.com/

To further check if the data is correct or not as @pierre.faurel advised.

ahs.png (129.2 KiB)
Click below to post an Idea Post Idea