Fetching intraday tick data with eikon in Python

Question

question

cty

1 ●1 ●0 ●1

Hi, good day

In Excel the formula writes:

=RHistory("CNYQM7R3Y=TPSC","MID_PRICE.Timestamp;MID_PRICE.Value","START:24-Sep-2019:09:00 END:24-Sep-2019:17:00 INTERVAL:TICK",,"CH:Fd",B2)

It works just fine and I can get the ticks for the mid price of CNYQM7R3Y=TPSC.

But how can I translate this into Python with the eikon api? I've tried both get_data and get_timeseries as below and they dont work.

eikon.get_data('CNYQM7R1Y=TPSC','TR.MIDPRICE(SDate=2019-09-24,EDate=2019-09-24,Frq=NA)')

eikon.get_timeseries(['CNYQM7R1Y=TPSC'],fields = 'TR.MIDPRICE',interval="tick")

Your help means a lot! Thanks！

Sep 24, 2019 at 03:23 AM

10 |1500

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

Jirapongse Oct 01, 2019 at 06:30 AM

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Answer 1 · 2019-09-24T07:49:08Z

marcin.bunkowski

3.8k ●4 ●4 ●6

The tick interval is not yet officially supported however you can fetch some data already.

Here is an example that gives you tick data but only for BID:

ek.get_timeseries('CNYQM7R3Y=TPSC','Value', start_date = "2019-09-24T06:00:00", end_date = "2019-09-24T09:30:00",interval="tick")

ahs.jpg (34.2 KiB)

Sep 24, 2019 at 07:49 AM

10 |1500

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

cty Sep 25, 2019 at 01:52 AM

Thanks! It seems impossible to replicate what I got in Excel.