Eikon API usage from Python: Getting a DF with both dates and values?
i start with this
formula = 'TR.ACCRUEDINTEREST(SDate=0,EDate=-19,Frq=C).date'
df, e = ek.get_data(instruments='XS1572326145', fields=formula)
print(df)
and it gives the dates; to get values, we would change:
formula = 'TR.ACCRUEDINTEREST(SDate=0,EDate=-19,Frq=C).value'
however, i don't understand how to get a DF containing both dates and values?
Thanks!
Best Answer
-
Hello,
To get a DF containing both dates and values, you just need to change your formula variable to be a list of the 2 fields you would like.
For your example, try this:
formula = ['TR.ACCRUEDINTEREST(SDate=0,EDate=-19,Frq=C).date','TR.ACCRUEDINTEREST(SDate=0,EDate=-19,Frq=C).value'] .
1
Answers
-
Great! Many thanks, just tested it and it does exactly what I wanted. Do you know by any chance how this usage reflects on the data download limits -- i.e. is it downloading the same data twice only to discard most of it later on and project it on a specific column?
0 -
Hi Mika,
Because you requested the data once seperately and then once together, I believe this usage will reflect as downloading the same data twice. Our usage limits are outlined below and more in depth here:
You are limited to 5 requests per second. Whenever you use an eikon.get_data,timeseries, etc. function, that counts as 1 request even though you are requesting 2 datapoints.
You are also limited to 50 MB/minute. The volume (size) of data retrieved from the platform via the Eikon Data APIs cannot exceed this limit, or you will encounter an error.
Finally, you are limited to the datapoints returned per request. In this situation, if you are trying to get the value of these 2 columns with one request for 5000 stocks, you may be limited in what you can get with one request.
- get_data: The current limit value (10-Oct-2019) is around 10,000 data points.
- get_timeseries: The current limit value (10-Oct-2019) is 3,000 data points (rows) for interday intervals and 50,000 data points for intraday intervals. This limit applies to the whole request, whatever the number of requested instrument.
- get_news_headlines: The current limit value (10-Oct-2019) is 100 headlines per request. The depth of history is 15 month.
- get_news_story: The current limit value (10-Oct-2019) is 1 story per request.
- get_symbology: No enforced limit (10-Oct-2019).
The daily volume limit is 5 GB per day.
1
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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛