I am trying to download data to study it with Pandas. I want to store the data in csv format.
THe problem is I see that sometimes the cells do not contain the decimal separator which means the number is 1000 higher than it should. For example:
And this happens in all columns, High, Close etc.
Any ideas to solve this issue?
I think I could write a program in Python that divides by 1000 if the number is an outlier but I prefer to get the data properly in the first place.
This is the code I used to generate the csv file:
import eikon as ek ek.set_app_key('key') result = ek.get_timeseries(["AAPL.O"], start_date = "2020-01-01T15:00:00", end_date = "2020-04-06T16:00:00", interval="minute",fields= "*" ) result.to_csv (r'C:\path\result.csv', index = True, header=True)
Thanks for your help.