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 valerio.gemmetto · Nov 13, 2018 at 08:58 AM · python apiminute prices

Minute prices

Hi,

we noticed some differences in minute prices between the Eikon workspace and the Python API, starting from last November 5. Some tickers seem correct and matching, while others have different prices and seem to have wrong time-stamps. Could you please check? Thanks

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.

7 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Nov 15, 2018 at 12:19 PM

@valerio.gemmetto
I think you might be confused about daylight savings time, as I don't see any discrepancies. The market open for US stocks is always 9:30 am New York time. On 25 Oct 2018 9:30 am New York time is 13:30 GMT, as 25 Oct 2018 falls within daylight savings time period, which in the US ran from 11 Mar 2018 till 4 Nov 2018, and during which period New York time = GMT - 4, as opposed to standard New York time = GMT - 5, which runs from 4 Nov 2018 till 10 Mar 2019.
On 25 Oct 2018 US market open was at 13:30 GMT. Today it is at 14:30 GMT.
The example of get_timeseries method you included returns an error because start_date and end_date parameters that define the boundaries of the time range requested cannot have exact same value.
Intraday timeseries for composite RICs such as IBM, TRI, AAPL.O etc include pre and post market trades. When you request minute bars for AAPL.O, which is one of the most liquid stocks, the first bar for the day will most likely have the timestamp of 12 am GMT. During daylight savings time this corresponds to the end of the previous day post market session that terminates at 8 pm New York time, and you won't see the next bar until 8 am GMT (4 am New York time when the pre-market trading starts). Outside of daylight savings time the bar at 12 am GMT corresponds to post trading at 7 pm New York time and the bars will continue until 1 am GMT and then stop until 9 am GMT.
The timeseries for NYSE RICs such as IBM.N, TRI.N etc include only regular market session trades, therefore the first bar for the day for these RICs will be timestamped 13:31 GMT or 14:31 GMT.
With regard to the discrepancies in minute bars you mentioned in your original post, if you still see them, would you mind providing a very specific example including the RIC, the timestamp on the bar and the values? A screenshot might be even better.

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 jason.ramchandani · Nov 13, 2018 at 09:46 AM

@valerio.gemmetto Hi -sorry to hear about your issue - do you have a RIC that is displaying this behaviour so we can check it. thx

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 valerio.gemmetto · Nov 13, 2018 at 09:53 AM

Hi Jason,

there are a few, for example ALB.N, AKS.N, DWDP.N and many more. Please let me know

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 valerio.gemmetto · Nov 15, 2018 at 03:38 AM

@jason.ramchandani Hi Jason, any news about the aforementioned issues? Thanks

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 marcin.bunkowski · Nov 15, 2018 at 04:27 AM

@valerio.gemmetto

I believe it may be connected to DST which ended for US (your examples are from NYSE) on November 4th.

Python API displays that by default in GMT, can you compare that in Eikon using the same timezone?

Thanks

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 valerio.gemmetto · Nov 15, 2018 at 08:20 AM

Hi @marcin.bunkowski I am not sure that the error is related to DLS. If you check for instance AAPL.O on 25 Oct 2018, it seems that the actual Open Price is reported at 13:30 GMT, instead of 14:30 GMT as I would expect (5 hours difference w.r.t. New York). I use the following function:

tmp = eik.get_timeseries('AAPL.O', 'CLOSE', start_date='2018-10-25', end_date='2018-10-25', interval='minute', corax='unadjusted', raw_output=True)

df = tmp['timeseriesData'][0]['dataPoints']

This is actually before the DLS in both Europe and US.

Moreover, are you aware of any change in the way the API is reporting pre-market (pre-opening) prices? Do you think the coverage of pre-market minute prices has changed recently?

Thanks

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 valerio.gemmetto · Nov 16, 2018 at 05:28 AM

Hi @Alex Putkov. thanks for the reply.

1) the confusion was between UTC and GMT. Do you confirm that you guys have always provided data in UTC, as you still do now?

2) I now understand the pre-market price data, they depend whether you consider the primary or the consolidated exchange

3) the discrepancies were due to the UTC/GMT mismatch, so never mind

Thanks, Valerio

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
Alex Putkov. ♦♦ · Nov 16, 2018 at 11:26 AM 0
Share

UTC and GMT are synonymous terms that are used interchangeably to refer to the same thing. What I think must have happened is that you confused GMT with UK time, which is not the same thing. UK time is the same as GMT in winter, but it is GMT+1 in summer because of daylight savings.

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

Issue with get_data returning multiple rows for one single investor

How to get list of leaver companies of the ASX 100 using the Python API?

Timeseries query returns NaN for High, Low, Open

What other parameters can be used with the statement pertaining to Corporate Actions data such as Stock Splits?

get data not returning full date range, is there a data limit?

  • 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