Convert program to loop throug a list of stock symbols from one at a time

[Mustang65]

Well, I have stumbled my way through all kinds of programming roadblocks and managed (with a lot of trial and error and input from you guys) to get all the macros up and running. Now I have the BIGGEST roadblock (challenge... sorry) thus far. The attached script currently runs fine, but I need to convert this code from a single stock symbol manually entered on worksheet "SetUp" (E4) to an automated version that will get the stock symbol from a list worksheet "ActiveStockSymbols" (column "A"). The date range will remain the same as it is now. I believe that I somehow need to loop the code between the "v" and the "^" lines. I found a few macros that I think did this, but they also did a lot of other things, which confused me, so I have no idea as to how I can incorporate a loop into my macro. I really need your assistance on this one. On each download the code copies some output to a ReportSummary worksheet and continues on with the next stock symbol until the list is completed. This macro may not be the best use of code, and I realize that, but I did get it working. I am sure that a lot of other members will be happy to use this macro with their spreadsheets.

I searched the forum, but if I missed a post that has this request up and running, please let me know what it is.

Thanks in advance for any assistance you can offer,

Don

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[AB33]

I have slightly amended your code. If there is an error on the URL due to stock symbol, or date, I put an error trapping, though it is not a good coding practice, it basically makes jump the code in to next loop.
I have separated the delimiter in to separate code.

[Mustang65]

The above code works great! Thank you so very much... I have one issue remaining. I am trying to copy the current run's variable "SYMBOL" into worksheet "BackTest" cell "AQ2", I have tried various ways and locations with no success. The last one is in the code below between the up an down indicators. It has to be something dumb that I am doing or not doing.

AB33 I will be looking at your code as soon as I get this issue resolved, as it will be the same for both.

Thanks again,

Don

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[Mustang65]

Thank you AlphaFrog!!!!!

Another GREAT job!!!!

Don

[AlphaFrog]

You're welcome. Thanks for the feedback.

Do you have a '65 Mustang? I have a 2014 Mustang.

[Mustang65]

Sorry about the slow response..
I just sold my 65 Mustang last year... working on it was a REAL pain in the BACK. It was CandyApple red with White stripes, 320Hp.. loved it

But someone else is enjoying it... would upload pictures ... maybe inside my next spreadsheet

Don