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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
1 1 0 2

get_timeseries - Historical fields inconsistencies (interval = TAS)

Hello all,

I have the following code returning either 27 or 52 fields depending on the end date.

(the difference lies in line 2, startdate definition)

Scenario 1: 52 fields returned

endDate = datetime.datetime(year=2020,month=3,day=10)
startDate=datetime.datetime(year=2020,month=3,day=4)

tickreq = ek.get_timeseries('BNPP.PA', fields='*', start_date=startDate, end_date=endDate, interval='tas', calendar=None, corax=None, normalize=False, raw_output=True, debug=False)
#--------------Fields and data extraction from raw data
lfields=[]
for i in tickreq['timeseriesData'][0]['fields']:
    lfields.append(i['name'])
tickdf=pd.DataFrame(tickreq['timeseriesData'][0]['dataPoints'], columns =lfields)

Scenario 2: 27 fields returned

endDate = datetime.datetime(year=2020,month=3,day=10)
startDate=datetime.datetime(year=2020,month=3,day=8)

tickreq = ek.get_timeseries('BNPP.PA', fields='*', start_date=startDate, end_date=endDate, interval='tas', calendar=None, corax=None, normalize=False, raw_output=True, debug=False)
#--------------Fields and data extraction from raw data
lfields=[]
for i in tickreq['timeseriesData'][0]['fields']:
    lfields.append(i['name'])
tickdf=pd.DataFrame(tickreq['timeseriesData'][0]['dataPoints'], columns =lfields)

I understand 08032020 is a sunday, so no trades to be found in theory, but I would still expect to get the same data structure, as I'am asking for all fields.

Is this normal behaviour?

Thank you for your help

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontime-seriespricing
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.

Upvotes
23k 22 9 14

Hello @MF

I run the same test, the structure appears to be the same, some fields may not be populated?


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.

Upvotes
1 1 0 2

Hello Zoya,

thank you for your answer,

I rerun the test and still have a difference:


I am even more confused now as we run pretty much the same code but get different results...


1583917478908.png (224.5 KiB)
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.

Upvotes
1 1 0 2

Hello Zoya,

The problem is consistent as I can replicate it on my side for the same date,

I could no replicate it for the same stock at another date,

I can replicate it for another stock (SOGN.PA) for the same starting date: 08/03/2020

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.

Click below to post an Idea Post Idea