i'm trying to do batch queries for a lost of list tickers in non-interative non-callback mode. i care about performance very much and have to work within vba.
i have not found any example on how to do this. all documentation and samples are showing callback interactive mode.
Please help me asap.
I don't believe I offered to produce an example of synchronous behavior. I can of course do it, however my job is to advocate best practices in the use of Thomson Reuters APIs. It is best practice to use the APIs as designed. If the API is asynchronous, it is best practice to use it asynchronously. Tricking an asynchronous API into producing synchronous behavior is a back door, which is only to be considered when the front door doesn't work. The use case you specified is trivial and can be easily implemented asynchronously. See attached example, which retrieves closing prices for 2,549 stocks (current constituents of Nasdaq Composite index). On my end it takes 5-6 seconds to retrieve the entire list, though the actual retrieval times will vary depending on a number of factors. Still the retrieval time on your end should be in the same order of magnitude as it is for me.
I suppose by "batch queries" you mean synchronous data retrieval, right? All Eikon COM APIs are asynchronous, which means that your data handling must be in the callback procedure for the event notifying the application that data has been retrieved. It is possible to trick some of Eikon COM APIs into producing seemingly synchronous behavior by sitting in the loop and checking data status until data status indicated that the data is ready. But I would not recommend this, especially since you're concerned about performance. The API is designed to produce asynchronous data retrieval and this is how it should be used. There's absolutely nothing you can do with synchronous retrieval that you cannot do with asynchronous. If you have a specific use case that you're struggling to implement using asynchronous retrieval, feel free to specify it here, and I'll be happy to produce an example of how whatever you need to do can be achieved. Or if you meant something else by "batch queries", then please elaborate on what you meant.