Cannot access CBA.AX minute data

yu.yang

Hi team,

tmp = ek.get_timeseries(["MSFT.O"], fields = 'CLOSE', start_date="2021-10-28 09:00:00", end_date="2021-10-28 10:00:00", interval='minute')

# This code work for me

tmp2 = ek.get_timeseries(["CBA.AX"], fields = 'CLOSE', start_date="2021-10-28 09:00:00", end_date="2021-10-28 09:05:00", interval='minute')

# CBA.AX will report "No data available error", not sure why, can you let me know? Thank you!

FYI In excel, I can get 30min level CBA.AX data

=@RHistory($A$2,".Timestamp;.Close;.Close","INTERVAL:30M",,"TSREPEAT:NO CH:Fd",I18)

raksina.samasiri

Hi @yu.yang ,

As checked, there're no CLOSE data of CBA.AX available at the start-end date range in your code (and there's no start-end date range specified in your Excel formula so the data is returned there)

I tried adjust the date parameters to be wider and the data are returned properly (without the data between start_date="2021-10-28 09:00:00", end_date="2021-10-28 09:05:00)

regarding this thread, get_timeseries method of Eikon Data APIs library always returns timestamps in GMT.

I checked in Eikon Excel and no data is returned during this date time range too (I did compare the result between the API and Excel so I belive that Eikon Excel timezone is the local timezone, which is GMT+7 for me)