Retrieve last quotes from PRK-NGS-PIC

Using the Eikon API, how to retrieve the history (say 3 months) of last quotes from a RIC (for example PRK-NGS-PIC) when last quote is NOT the default field. In the snapshot you see that 'total market volume' is the default. So when i perform a get_timeseries call it gives me only that. get_date also doesnt work because the DIM (data item browser) doesnt have any fields related to timeseries. However, it must be possible, because in the snapshot you see that I can retrieve the prices in the eikon user interface when going to the chart. I have already tried 50+ different api calls with get_timeseries and get_data. Please get it working before posting an answer.
Best Answer
-
Hi @valstar
Using the Eikon DATA API get_timeseries only returns daily Volume.
However, if I use the RDP library I can get a daily price as well (the following code snippet in Codebook)
import refinitiv.dataplatform as rdp
rdp.open_desktop_session('DEFAULT_CODE_BOOK_APP_KEY')
rdp.get_historical_price_summaries('PRK-NGS-PIC')returns:
As mentioned previously, if this is not the price points you require, please raise a content type ticket - to speak to a content specialist.
0
Answers
-
Hi @valstar
Looking at the Qoute object for PRK-NGS-PIC, I can see that the last price 151.280 maps to the real-time feed field PRIMACT_1.
Also, looking at the DIB, the Eikon field CF_LAST corresponds to the last value on the chart.
and with get_data():
df, err = ek.get_data(['PRK-NGS-PIC'], [ 'PRIMACT_1','CF_LAST'])
df
.....
Instrument PRIMACT_1 CF_LAST
0PRK-NGS-PIC 151.28 151.28If neither of the above is the field you are looking for then I recommend you create a Content Ticket on My.Refinitiv - the moderators on this forum are not content experts.
0 -
Both fields would be fine, but I want to get some history. even if I add {'SDate':'0D', 'EDate':'-3AM'} I only get that single value.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛