how do I get historical ticks using Python eikon package

FrankZUser: "FrankZ"
FrankZ
Newcomer

Hello, how do I get historical ticks using Python eikon package?

For example, the Excel way to get real-time ticks is =TR(E3:E1001,"TR.InstrumentDescription;PRIMACT_1;SEC_ACT_1;CF_TIME;GV6_TEXT;CF_BID;CF_ASK","UPDFRQ=STREAM CH=Fd RH=IN")

What about getting historical ticks in Python? I tried the following but with no luck.

import eikon as ek

ek.set_app_key('{my app key here}')

list_rics = ['775109BB6=', ]

list_fields = ['TR.InstrumentDescription', 'PRIMACT_1', 'SEC_ACT_1', 'CF_TIME', 'GV6_TEXT', 'CF_BID', 'CF_ASK']

sd = '2019-09-06T06:00:00'

ed = '2019-09-06T21:00:00'

df = ek.get_timeseries(list_rics, list_fields, start_date=sd, end_date=ed, interval='tick')

print(df)

Find more posts tagged with

python
eikon
historical
workspace
tick-history-rest-api
eikon-data-api
refinitiv-dataplatform-eikon
workspace-data-api
Sort by:
1 - 1 of 11
    James.PerkinsUser: "James.Perkins"
    James.Perkins
    LSEG
    Accepted Answer

    currently the fields supported by ek.get_timeseries() are; 'TIMESTAMP', 'VALUE', 'VOLUME', 'HIGH', 'LOW', 'OPEN', 'CLOSE', 'COUNT' , which for most instrument types is fine; but for bonds there need to be additional fields added. You can retrieve historical yield data for bonds on a tick basis. (via Eikon Excel you would reference BID.Close and ASK.Close for historical bid/ask levels - these have yet to be added to Eikon DAPI).

    ts = ek.get_timeseries(['775109BB6='], fields = ['VALUE'], start_date = "2019-09-06T06:00:00",
    end_date = "'2019-09-06T21:00:00", interval="tick")

    image

    View in context
Quick Links