Definition of Request in Excel

hay

According to the Eikon Data API documentation there is a daily limit of 10,000 requests - is the definition of request a single =tr(security,field,,) formula or something broader? The use case is analysing a portfolio of ~500 securities with ~20 fields. That multiplies to 10,000 individual cells which makes the daily limit somewhat restrictive. How can I aggregate the requests so I can download all the fields for one security in a single request or conversely download single/multiple field data for all the securities in a single request?

Alex Putkov.1

@hay

The limits described in the documentation for Eikon Data APIs only apply to data retrieval through Eikon Data APIs. Data retrieval using GUI tools such as Excel worksheet functions like =TR and others provided by Eikon Excel add-in are not subject to these limits. There's no defined limit on the number of =TR functions you can use simultaneously or in any given period of time. No defined limit does not mean there are no limits at all. If you keep adding functions to the spreadsheets, sooner or later you'll reach some bottleneck and the data retrieval or Excel application won't work as expected. The absolute vast majority of users never come anywhere close to this point. But it's not completely impossible. No defined limits means we cannot say where exactly that point may lie, as there are too many interrelated variables. Nor can we say what exact symptoms you may experience if you ever reach that point. Finally, it's worth noting that there's strong efficiency gain in combining =TR functions, i.e. using a single =TR function to retrieve multiple instruments and/or fields as opposed to a separate instance of =TR function for each instrument/field combination.

jason.ramchandani01

@hay that 10,000 datapoint limit is per single formula in excel (which is equivalent to one API call). So in cell 1 you could have a formula which returns 10,000 datapoints. Then in another cell another formula that returns another 10,000 datapoints. That would be two out 10,000 calls per day you could make. If you did things one cell at a time yes that would use up your daily limit. Thankfully we can request multiple instruments and fields in one API call (upto the limit of 10,000 datapoints per call or single forrmula). It appears 20 fields for 500 instruments can be done in one of your 10,000 daily calls. In excel this is easily achieved using the Request Builder - you just select a list of RICs and then the fields you want and it pastes this into your excel sheet. I hope this can help.