Why does eikon.get_timeseries not return a timestamp?

Question

Question by alexkohhj · Apr 12 at 04:13 AM · timeseries timestamps

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

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-04-12T12:25:38Z

REFINITIV

Best Answer

Answer by jason.ramchandani · Apr 12 at 12:25 PM

@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)

or

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.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Why does eikon.get_timeseries not return a timestamp?

1 Reply

Watch this question

Related Questions