Why does get_data show strange behavior with timeseries data?
Hi there,
I noticed some strange behavior when pulling time series data via the get_data function.
To be precise, when sending the following request...
df,err=ek.get_data('1COV.DE',["TR.PriceOpen(SDate='2017-04-13',EDate='2017-04-20').date","TR.PriceOpen(SDate='2017-04-13',EDate='2017-04-20')"])
... I receive 3 times the same price with the same date (i.e.: three times 74.20 as of the 13th of April 2017.
This leads to strange behavior when coupling it with other variables, for instance including Volume...
df,err=ek.get_data('1COV.DE',["TR.PriceOpen(SDate='2017-04-13',EDate='2017-04-20').date","TR.PriceOpen(SDate='2017-04-13',EDate='2017-04-20')","TR.Volume(SDate='2017-04-13',EDate='2017-04-20')"])
... where Volume would be available with 3 different dates (although the value is 0 for two of them), but it gets merged into the same dates, hence leading to two different data information for the same date:
This looks like a bug to me. Can you explain where this comes from?
Best Answer
-
Hi @auth
I think 14th Apr 2017 to 17th Apr 2017 were public holidays.
Anyway, if you have question on the content behavior, you can contact the Refinitiv Content Helpdesk.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/0
Answers
-
Yes, that's perfectly fine. The problem doesnt come from the volume data though, but from the prices. Prices dont give me the 14th and 17th but return the 13th of April 3 times. so the date stamp is wrong...
0 -
Hi @auth, the Price Open field shows the latest Price Open data; on non-trading days, this is the latest trading day's Price Open. you may choose to change Price Open data with logic triggering if Volume is 0 and/or using this library:
0 -
Ah of course. Yes, guess that was a silly question from my side than. Thanks for clarifying.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛