How do we extract quotes from EIkon via python?
Hello, all,
Are we able to extract the time-series of this data as below from EIkon API? Is there a way to extract the historical data as well?
I need to extract every rows and column of it.
Please advise. Appreciate it.
Thanks.
Best Answer
-
@stan.85 So to populate the list you could also try using RDP Search API - for example:
rdp.search('RECYR01*')
So you could try it that way for each year and for the spot - probably you still need some processing.
Regarding the field names you can use the Data Item Browser (type DIB into eikon search bar) or Code Creator App (type CodeCR into eikon search bar) which can help find any field you want and also you can check the relevant parameters. DIB is great because if you put an instrument in, it also returns values for each field - so its easier to zero in on what you want. Code Creator goes one step further and can actually create the python code for you once you have selected the fields and parameters you want. I tend to use DIB as i want to check values most of the time. I hope this can help.
1
Answers
-
Hi @yeel.85
0 -
@yeel.85 Please try the following:
df3,err = ek.get_data(['RECSPOT=HVBS','RECYR01=HVBS','RECYR02=HVBS','RECYR03=HVBS','RECYR04=HVBS','RECYR05=HVBS','STCSPOT=HVBS','STCM1=HVBS','STCM2=HVBS','STCM3=HVBS','STCM4=HVBS','STCM5=HVBS','STCM6=HVBS','STCM7=HVBS','STCM8=HVBS','STCM9=HVBS','STCM10=HVBS','STCM11=HVBS','STCM12=HVBS','VEECSPOT=HVBS','VEECM1=HVBS','VEECM2=HVBS','VEECM2=HVBS','VEECM4=HVBS','VEECM5=HVBS','VEECM6=HVBS','VEECM7=HVBS','VEECM8=HVBS','VEECM9=HVBS','VEECM10=HVBS','VEECM11=HVBS','VEECM12=HVBS','NSWESCSPOT=HVBS','NSWESCM1=HVBS','NSWESCM2=HVBS','NSWESCM3=HVBS','NSWESCM4=HVBS','NSWESCM5=HVBS','NSWESCM6=HVBS','NSWESCM7=HVBS','NSWESCM8=HVBS','NSWESCM9=HVBS','NSWESCM10=HVBS','NSWESCM11=HVBS','NSWESCM12=HVBS'],
['DEALT_VL1','PRIMACT_1','SEC_ACT_1','SEC_VOL1','VALUE_TS1','VALUE_DT1'])
df3For the history I would try either the Historical Pricing service from our RDP APIs or our timeseries- which you can access using an eikon app key. I hope this can help.
0 -
Thanks chavalit, appreciate it. If i can the historical pricing, that would be awesome.0
-
Thanks for the help. Just a few questions:
- Where can I find what parameters to use when we call the ek.get_data() as I will need to do the same for other brokers as well.
- As you have suggested using the Historical pricing service from the RDP API, would you be able to share the code for that? What should I fill for the parameter universe? Please advise.
- I am wondering if there is any documentation on the API that i can refer for future reference?
StartDate = '2021.06.20'
EndDate = str(datetime.date.today())
data = rdp.get_historical_price_summaries(universe = ?, fields = fields, interval = rdp.Intervals.DAILY, start=StartDate, end= EndDate)Thanks.
0 -
@stan.85 So when you say parameters you actually mean ric construction so - for these RICs the easiest way is type in the first part of the RIC into search and then it will provide with a list of broker codes to add after the = sign.
Unfortunately we do not carry timeseries history for these RICs as I cannot chart them - so there is no history being collected. For a valid RIC the code below returns a dataframe.
ric = 'VOD.L'
data = rdp.get_historical_price_summaries(universe = ric,
interval = rdp.Intervals.DAILY,
start=StartDate,
end= EndDate)
dataFor more information on the RDP Historical Pricing endpoint please go to the API Playground which has sample and references as well as swagger documentation.
You can find the API Playground from the developer community portal Tools section. I hope this can help.
0 -
Thanks for the info. Hmm, guess there is no other way to get that historical pricing. Yeap, I was referring to those ric, would have thought we might have an easier way to populate the list.
Probably a last question (might be a silly one), was wondering where do we find the respective variable: 'DEALT_VL1','PRIMACT_1','SEC_ACT_1','SEC_VOL1','VALUE_TS1','VALUE_DT1' ?
Thanks.
0 -
Thanks
@jason.ramchandani. Appreciate it1
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 中文论坛