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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
victor.w avatar image
16 ●0 ●0 ●1

How to implement the below Eikon Excel RHistory function in Eikon Data API ?

A client would like to know how to implement the below Eikon Excel RHistory function in Eikon Data API :

=@RHistory("0005.HK","TRDPRC_1.Timestamp;TRDPRC_1.Value;TRDPRC_1.Volume","START:09-Aug-2021:09:00 END:09-Aug-2021:09:30 INTERVAL:TICK",,"SORT:ASC CH:Fd",B2)

1628577678666.png


eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
1628577678666.png (26.5 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.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@victor.w

You can use the get_timeseries method to get tick historical data. The code is:

ek.get_timeseries("0005.HK", interval="tick", start_date="2021-08-09T01:00:00", end_date="2021-08-09T01:30:00")

The time is in GMT. The output is:


1628578746815.png


1628578746815.png (17.1 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.

victor.w avatar image victor.w
@jirapongse.phuriphanvichai , Jiraponagse, Thanks so much.
Click below to post an Idea Post Idea