For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
yu.yang avatar image
1 ●0 ●0 ●1

Cannot access CBA.AX minute data

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)

eikon-data-apiequitiespython apiprice-history
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
raksina.samasiri avatar image
1.7k ●2 ●4 ●7

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)

1635511183564.png

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)

1635511621114.png


1635511183564.png (69.5 KiB)
1635511621114.png (24.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea