Upgrade from Eikon -> Workspace. Learn about programming differences.

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 ●1 ●2 ●8

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-apipython apiequitiesprice-history
icon clock
10 |1500

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

raksina.samasiri avatar image   raksina.samasiri

hi @yu.yang ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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