Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by mika.kastenholz · Nov 04, 2019 at 03:27 PM · get_datadatestimestampsvalues

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!

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Replies

  • Sort: 
avatar image
Best Answer
Answer by r.patel · Nov 04, 2019 at 04:45 PM

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'] .



Comment
mika.kastenholz

People who like this

1 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
mika.kastenholz · Nov 04, 2019 at 04:51 PM 0
Share

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?

avatar image
Answer by r.patel · Nov 05, 2019 at 03:45 PM

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:


https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs?content=49692&type=documentation_item


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.

Comment
umer.nalla

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

'get_data' returns different results when 'end date' is not specified

get_data returning only 1 row even after adding start date and end date

get_data does not seem to handle columns with NULL/empty values properly

get_news_headlines date range not returning results

Retrieving information about EPS forecasts

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges