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.