Optimise Repeat External Queries

[sivlin]

Hello everyone,

I'm looking to see if anyone has any ideas on how I could perform this task faster.

It is as follows:

I have a list of somewhere around 2600 different Ebay titles (my inventory which is always growing) and I made a program that would grab each title separately and query ebay for the results of a search on that title (Checking for competitors). Essentially, what this comes down to is, for each title - my program has to re-query Ebay and this takes forever!

This is the only way I've come up with for doing this, but I'm definitely no guru at excel.

Any ideas floating about? Something I could do that would speed things along? Alternatively, I am not dead set on using Excel as the end all for this program. If you guys think another language might perform this better feel free to make the suggestion and I'll check it out.


Thanks for any responses in advance!