Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by megha.pandit · Sep 12, 2019 at 12:52 PM · eikon apipython apitimeseriesbidask

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

8 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by James.Perkins · Sep 12, 2019 at 10:16 PM

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)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by James.Perkins · Sep 12, 2019 at 01:46 PM
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)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by megha.pandit · Sep 12, 2019 at 02:35 PM

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?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Wiki
Answer by marcin.bunkowski · Sep 13, 2019 at 01:21 PM

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)
Comment
James.Perkins

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by megha.pandit · Sep 16, 2019 at 01:12 PM

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

Comment

People who like this

0 Show 2 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
James.Perkins ♦♦ · Sep 16, 2019 at 01:14 PM 0
Share

TAS = Time and Sales

avatar image
REFINITIV
marcin.bunkowski · Sep 16, 2019 at 01:15 PM 0
Share

Hi @megha.pandit

It's "time and sales".

avatar image
Answer by megha.pandit · Sep 19, 2019 at 02:39 PM

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

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
marcin.bunkowski · Sep 20, 2019 at 10:11 AM 0
Share

@megha.pandit

It's GMT time zone

avatar image
Answer by meghapandit86 · Sep 20, 2019 at 07:21 AM

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

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
marcin.bunkowski · Sep 20, 2019 at 10:04 AM 0
Share

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.

avatar image
Answer by megha.pandit · Sep 23, 2019 at 09:14 AM

@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")

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
marcin.bunkowski · Sep 23, 2019 at 12:45 PM 0
Share

@megha.pandit

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Does get_timeseries provides adjusted close prices (splits and dividends) when using corax="adjusted" ?

get Multiple fields with AdxRtList

RHistory tick python replication

Include current price in hourly prices time series, python API

How do I add additional criteria when retrieving RIC codes to a ‘screener_exp’ statement?

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges