Python API get_timeseries use multiple RICs

Tried to call get_timeseries to get historical tick data over multiple RICs, and saw the error - Shape of passed values is (4, 106), indices imply (4, 16). However, it works when I used only one single RIC.
try:
symbolList = list()
list.append("AMXL.MX")
list.append("CMXCPO.MX")
ret = ek.get_timeseries(symbolList, start_date="2018-09-06T20:00:00", end_date="2018-09-06T20:10:00",interval="tick")
print(ret)
except Exception as err:
print(err)
Best Answer
-
I suggest to request raw data then extract each serie from result as below:
try:
symbolList = ["AMXL.MX", "CMXCPO.MX"]
ret = ek.get_timeseries(symbolList, start_date="2018-09-06T20:00:00", end_date="2018-09-06T20:10:00", interval="tick", raw_output=True)
for data in ret['timeseriesData']:
df = pd.DataFrame(data['dataPoints'], columns=[f['name'] for f in data['fields']]).set_index('TIMESTAMP', drop=True)
print("Serie[{}]".format(data["ric"]))
print(df)
except Exception as err:
print(err)0
Answers
-
Eikon Python library cannot combine tick data for multiple instruments into a single dataframe because the dataframe is indexed on the timestamp and the timestamps for tick data for multiple instruments don't match. I suppose we should handle this use case in the library: before submitting the request for data check if more than one instrument is passed and whether interval="tick" and raise an exception right away saying "Tick data can only be retrieved for a single instrument". I will raise this to the development team.
If you tell me what your end goal is, I may suggest a workaround.0 -
Ok. I am trying to collect the tick data of an small time interval for multiple RICs. In this case, we can request the data for one RIC at a time. However, I am looking for more than 200 RICs here. I am thusly looking for a possible way to request data for multiple RICs all together, or any other more efficient way.
0 -
I see two options here. One is obvious: iterate over your list of RICs in a loop. The other is to use send_json_request method. The advantage is that you can retrieve timeseries for multiple RICs in a single request. The disadvantage is that the data is delivered as JSON and you need to write code to parse it into whatever format is useable for your purposes. If you'd like to explore this option I suggest you take a look at the method's signature in Eikon Data APIs for Python Reference Guide available from the Documentation tab on Eikon Data APIs page on this portal.
0 -
Then I suggest you use Fiddler to see the HTTP request sent when you execute get_timeseries method for multiple RICs, which will help you figure out the values of the arguments you need to pass to send_json_request method.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 630 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛