Iterating through a list and copying results

[bellawala]

This is an amazing board! I hope this isn't too basic a question, but here goes:

I have a very long array (about 10,000 rows) and I want to do some complex calculations on each element. This includes querying an outside datasource and manipulating the returned data. The result of this manipulation is a single value.

What I would like to do is take the first row, query the outside datasource and make my calculations, then copy the result to the column to the right of the queried element. When this is complete, I would like to move on to the next item, etc.

Any ideas? Thank you very much.

 

[PaddyD]

Hi - welcome to the board!

Sure some help will come your way, but need more info...whata's the outside data source; how are you accessing it; what calculations are you performing; does your range have gaps; what to do with errors.

Doesn;t sound like the kind of issue that will get solved all at once, but post back with more details & we can try & deal with one issue at a time...

Paddy

 

[bellawala]

Great. Here are the specifics:

I'm writing a portfolio management tool. I'm starting with a list of all symbols traded on the US markets (there are about 10,000) of them. For each symbol, I will be querying a few websites to get some historical information. With that, I will be doing some technical analysis and generating 5 values associated with the symbol. I would like to copy those values to the table alongside the symbol itself, then move on to the next symbol. When I get to the end of the list, I would like to start all over again.

Is this enough information?

 

[PaddyD]

It is more information, but what are you asking - to have the entire application built for you???

On the assumption that you're not, you must want either:

a) general advice on how to approach your project - how to go about setting up web queries, for example,
or
b) help with a specific problem which you have yet to detail.

...or perhaps both!


So...what, specifically, do you need help with?

Paddy