Why does eikon.get_timeseries not return a timestamp?

Hi,

Here is a snippet of my code.

df = eikon.get_timeseries(['AUD='],start_date='2000-12-31',end_date='2020-4-18',interval='daily',fields=['TIMESTAMP', 'VALUE', 'VOLUME', 'HIGH', 'LOW', 'OPEN', 'CLOSE'])

df.to_csv (r'D:\Data Science\export_dataframe.csv', index = False, header=True)

print(df['TIMESTAMP'])

print(df)

I am not able to retrieve a TIMESTAMP column.

File "C:/Users/Alex/.spyder-py3/sqllitedbtable.py", line 21, in <module>

print(df['TIMESTAMP'])

Could you kindly assist?

Alex

Find more posts tagged with

python

eikon

time-series

workspace

time-stamp

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

jason.ramchandani01

@alexkohhj Hi thanks for your question. The reason for this is that the timestamp field (or datetime) is automatically returned as the index - not a regular column per se. Why don't you try:

print(df.index)

print(df.index.values)

Also I note in your export to csv file you have a parameter index=false - I think this should be true. I hope this can help.

All comments

jason.ramchandani01

@alexkohhj Hi thanks for your question. The reason for this is that the timestamp field (or datetime) is automatically returned as the index - not a regular column per se. Why don't you try:

print(df.index)

print(df.index.values)

Also I note in your export to csv file you have a parameter index=false - I think this should be true. I hope this can help.

EXPLORE OUR SITES