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
victor.w avatar image
16 ●1 ●1 ●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-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-api
1628577678666.png (26.5 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.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.7k ●257 ●52 ●74

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

victor.w avatar image victor.w
@jirapongse.phuriphanvichai , Jiraponagse, Thanks so much.

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.