How can I get previous price data for NULL values in EIKON DATA API?
Good morning?
We want to receive price data through the Eikon Data API, and we are currently testing for that. I have something to inquire about it.
When receiving price data using the ‘Refinitiv Eikon’ tab in Excel, I can adjust for null values using the ‘Parameters & Quick Functions’ section of ‘Build Formula’. For example, in the United States, January 18 was a closed Monday. In 'Build Formula', I can set whether to import price data for January 15th versus January 18th in options.
Please ask if this optional feature is also available in the Eikon Data API. When I receive timeseries data from Eikon Data API, I don't get price data on January 18, is it possible to fill it with previous price data? We want to be able to receive pricing data for all days of the week (including holidays) except Saturday and Sunday.
Thank you very much for your hard work
Best Answer
-
@jijija I am not aware of such functionality natively in the eikon data api. However it is pretty standard in pandas dataframe functionality. Please see the following reference in pandas guide on fillna functionality. Basically once you have your dataframe filled with data that may contain some NA values you can simply:
df.fillna(method='ffill')
and that will propagate the previous value before NA - into the NA. I hope this can help.
0
Answers
-
Thank you for answer.
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 6 Bot Platform
- 17 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
- 370 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 中文论坛