Stock Symbols Minimum & Maximum

I want to automate some procedure I have been doing manually for a while. Base on Up-to-date historical prices, I calculate the flotation band, and other things. This is what I do: 1. Whatever Stock Symbol I want to check, I go to Yahoo Finance and I go to the "Historical Data" section. See Picture [login to view URL] 2. Then I download the historical data for that particular Stock Symbol. See Picture [login to view URL] 3. The file I get is a CSV file with 255 or more rows of information. See Picture [login to view URL] 4. I have created an Excel Template to paste the values and all be done automatically. See Picture [login to view URL] 5. Once the data valueas are pasted, I calculate the following: (See Picture [login to view URL]) * Band = High - Low. * B @ 80% = 80% of Band * Buy = Low + 10% of Band * Sell = High - 10% of Band * Profit $ = Sell - Buy * Profit % = Profit $ / Buy The data is sorted OLD to NEW. as shown in Picture [login to view URL] The Average $ is the average of the BOTTOM 30 rows of Profit $. Same for 60, 90 and 180 The Average % is the average of the BOTTOM 30 rows of Profit %. Same for 60, 90 and 180 6. Then, I save the file and name it with the Average % Last 30 and the Stock Symbol The historical STock Symbol proces is public information and can be grabed from multiple websites. It's your choice which one to use. Also, instead of generating one file per Stock Symbol, you can came out with a list with 2 columns, first the Stock Symbol, and second, the Average % Last 30. SORTED DESCENDING by Average I want to be able to do the full process for: a) Some Stock Symbol b) Multiple Stock Simbols c) ALL Stock Symbols (NYSE and NASDAQ) The day when the process is run, have to contain Up-to-today's-date information. Also, if needed, a table like the one in Picture [login to view URL] have to be generated as requested.