How to get flat price history for Geograin data
I am trying to pull flat price data from any number of Geograin RICS, but the ek.get_timeseries function only seems to pull the commodity basis, the default value. In the Eikon app, I can get the historical flat price using the Chart function by changing the field to "Last Quote", but I cannot find a way to get it using the Eikon API.
Best Answer
-
You can try this code:
#pip install refinitiv.dataplatform
import refinitiv.dataplatform as rdp
rdp.open_desktop_session('xxxA Valid App Keyxxx')
df = rdp.get_historical_price_summaries('WHRWDMCDMS-K', start='2020-05-01', end='2020-05-20')
df.head()0
Answers
-
chavalit.jintamalit Thank you, that at least pulls the data I am looking for, but it appears as if it only pulls 20 items at once? How can I pull more, like all data provided since 2001 as I was originally attempting?
0 -
You can adjust the start and end parameters.
I just use 1st to 20th May 2020 to demonstrate the same data point with your screenshot only.
0 -
Thank you, it seems if you only include the start date (ie rdp.get_historical_price_summaries('WHRWDMCDMS-C1', start='2000-01-01')) then it only pulls the latest 20 items? That is what I did. But if you include the start AND end it pulls all data (ie rdp.get_historical_price_summaries('WHRWDMCDMS-C1', start='2001-01-01',end='2021-03-18'))
Is there documentation for the get_historical_price_summaries function?
0 -
The RDP Lib is still in beta.
So the documentation is limited.
You can use help() to see the parameters list.
You can also launch "CODEBOOK" on Eikon Desktop (Type in CODEBOOK on Eikon Search Bar)
Then browse to the sample notebook for more information and example.
1 -
Premise history, occasional patterns and local interest can likewise be determined by using our information that incorporates lift area, money value, premise and the prospects contract that cost was stuck to.
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 中文论坛