How to return local exchange time in time series?

Question

Question by andy.ej · Aug 05, 2018 at 12:21 AM · eikon python eikon-data-api workspace refinitiv-dataplatform-eikon workspace-data-api time-zone

How to return local exchange time in time series?

I use the following code to get data:

df1=ek.get_timeseries('2330.TW',fields=["Open","High","Low","Close","Volume"], start_date = "2018-08-02T01:00:00" ,end_date='2018-10-27T23:00:00',interval='minute')

but it does not return the local time format , it should be Taiwan timezone, how to fix it ,

Thanks

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 · 2018-08-05T23:26:57Z

REFINITIV

Best Answer

Answer by BrianLeung · Aug 05, 2018 at 11:26 PM

Hi,

Please try to convert the return dataframe to your desired timezone.

import pytz

eastern = pytz.timezone('Asia/Shanghai')

df.index = df.index.tz_localize(pytz.utc).tz_convert(eastern)

Thanks.

1 Show 1 · 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.

andy.ej · Aug 06, 2018 at 10:36 PM 0

Share

thanks , it is very helpful.

How to return local exchange time in time series?

1 Reply

Watch this question

Related Questions