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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

How can I get bid and ask prices in a 1-min intervale from Python API for LCOc1 and LCOTc1?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontime-seriesfields
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.

Upvotes
Accepted
629 2 4 7

If you adjust interval to "tick" you will get each tick... at this point you can't select individual second.

lco = ek.get_timeseries(['LCOc1'],start_date='2019-09-10T12:00:00',end_date='2019-09-10T15:00:00',interval='tick') 

Currently get_timeseries() supports

Available fields: 'TIMESTAMP', 'VALUE', 'VOLUME', 'HIGH', 'LOW', 'OPEN', 'CLOSE', 'COUNT'

this is being reviewed for the roadmap. It should be noted that 'VALUE' as a tick value is both Bid and Ask values ... it is whatever traded; some trades hit at the bid, others at the ask.



bidask.png (40.2 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.

Upvotes
629 2 4 7
lco = ek.get_timeseries(['LCOc1'],start_date='2019-09-10T12:00:00',end_date='2019-09-10T15:00:00',interval='minute')


lco.png (26.0 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.

Upvotes
1 0 0 0

there is no bid and ask prices in this. I received the bid - ask prices from another team - TREMO. It's the prices per second. Is that possible to retrieve from python api?

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.

Upvote
3.8k 4 4 6

Hi @megha.pandit

You can also try using a tas (time and sales) interval:

ek.get_timeseries('LCOc1',['Bid','Ask'], start_date = "2019-09-06T06:00:00", end_date = "'2019-09-06T21:00:00", interval="tas")


ahs.jpg (50.7 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.

Upvotes
1 0 0 0

@marcin.bunkowski is 'tas' the time and sales or trade at settlement?

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.

TAS = Time and Sales

Hi @megha.pandit

It's "time and sales".

Upvotes
1 0 0 0

@James.Perkins @marcin.bunkowski thanks and what is the time zone in the timeseries? London time or user defined?

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.

@megha.pandit

It's GMT time zone

Upvotes
1 0 0 0

@James.Perkins @marcin.bunkowski is there any more data in the tas interval format? like Ask size or bid size?

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.

Hi @megha.pandit

Yes, it looks that you can get those fields as well

ek.get_timeseries('LCOc1',['Bid','Ask','Bidsize','Asksize'],start_date = "2019-09-06T06:00:00",end_date = "'2019-09-06T06:01:00", interval="tas")

I have tried using the same fields that are available when retrieving that in Excel without a prefix. It looks that not all of them are yet supported.

Upvotes
1 0 0 0

@James.Perkins @marcin.bunkowski

This only gives me one day of data irrespective of the start and end time. Although for the LCOTc1 Ric I can find three months of history. Any work around this?

ts = ek.get_timeseries('LCOc1', ['Bid', 'Ask','Bidsize', 'Asksize'], start_date = "2019-06-10T18:28:00", end_date = "2019-09-20T18:30:00", interval = "tas")

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.

@megha.pandit

The max output is 50000 rows. A workaround is to split your request.

Click below to post an Idea Post Idea