ERROR in Data

pablo

Hi guys, I am downloading a historical data of several instruments and I find the surprise that the number exported to my csv file comes with many decimal places. I would like to know if my code is wrong or simply the API has a problem.

My code is this:

import eikon as ek

ek.set_app_id('XXXXXXXXXXXXXX')

df=ek.get_timeseries(['CARC.BA'],
start_date='2016-01-01' , end_date='2018-01-01')

df.to_csv('CARC.BA_2016-01_2018-01-01.csv')

Then when i see my data i found numbers like this:

HIGH:

1,45E+16


1,44E+16


1,4E+16




1,4E+16



1,42E+16

1,52E+16

this same problem with all my historical data.

Jirapongse

I am unable to replicate the problem. This is data in csv file.

You can verify the data by setting raw_output to True.

df=ek.get_timeseries(['CARC.BA'], start_date='2016-01-01' , end_date='2018-01-01', raw_output=True)
df

The output is raw JSON data.

{'timeseriesData': [{'dataPoints': [['2016-01-04T00:00:00Z',
     2.0916375,
     2.0916375,
     2.0916375,
     2.0916375,
     4876.56202377324],
    ['2016-01-05T00:00:00Z',
     2.0916375,
     2.0916375,
     2.0916375,
     2.0916375,
     768.0585187442853],