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 Tulkkas · Oct 16, 2019 at 11:35 AM · eikon apitimeseriesprices

Different in price value depending on date range

i have noticed that running those 2 requests to get prices for a stock over different range return different data:

Version1:

data,err    = ek.get_data(['000001.SZ'], ['TR.PriceCloseDate(SDate="2018-10-02", EDate="2018-12-31"),TR.ClosePrice(SDate="2018-10-02", EDate="2018-12-31")'])

This returns:

2018-10-08 - NaN

2018-10-09 - NaN

2018-10-10 - NaN

2018-10-11 - NaN

2018-10-12 - 10.45


Version2:

data,err    = ek.get_data(['000001.SZ'], ['TR.PriceCloseDate(SDate="2018-06-02", EDate="2018-12-31"),TR.ClosePrice(SDate="2018-06-02", EDate="2018-12-31")'])

This returns:

2018-10-08 - 10.45

2018-10-09 - 10.56

2018-10-10 - 10.45

2018-10-11 - 9.86

2018-10-12 - 10.3


Can anyone explain what is going on? Why do I get different prices for the same date? and all those NaN? Is there something wrong in request?

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by marcin.bunkowski · Oct 16, 2019 at 12:29 PM

Hi @Tulkkas

You are using fields that are not aligned in a one time series.

TR.PriceCloseDate, TR.PriceClose, TR.PriceClose.date

and

TR.ClosePrice, TR.ClosePrice.date

Please have a look at the example below

ek.get_data('000001.SZ', ['TR.PriceCloseDate,TR.PriceClose,TR.PriceClose.date,TR.ClosePrice,TR.ClosePrice.date'],{"SDate": "2018-10-01", "EDate":"2018-12-31"})

I hope it clarifies


ahs.jpg (167.8 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 Tulkkas · Oct 16, 2019 at 02:07 PM

Thx for the explanation. I indeed did not notice those series were not aligned. So what is the difference between PriceClose and ClosePrice and what is recommended to use?

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 · Oct 16, 2019 at 02:15 PM 0
Share

Hi @Tulkkas

You may check a similar question here

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 >
8 People are following this question.

Related Questions

Eikon Scripting API: issues with timeseries

Eikon Desktop Data API stopped working after changing to a new user on Eikon terminal

Need VWAP historically in Eikon API. Cannot translate Excel Rhistory to Python get_timeseries().

get more data field on tick data of ek.get_timeseries()?

get_timeseries returns date that does not exist in Eikon and with NA for close price

  • 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