Im trying to sort through tons and tons of data for stock trading. I'm testing different indicators on different settings and then exporting the results to excel. A test could have as several hundred to several thousand different settings tested and then try it on anywhere from 6 to 30 stocks. I need a way to filter all of this data so that that it is usable. What i would like to do, is to toss out the outlying data and then average the other results and then create some kind of graph from the remaining data. I need to not only be able narrow down the area of the tests that had the best settings, but i also need to be able to compare that area to all the other indicators.


the original spreadsheet might look something like this:


Indicator #243

stock1 stock2 stock3 stock4 stock5 stock6
test1
test2 $-400 $16 $-12 $680 -$22 $3 = throw away -400 and 680, remaining average = $3.75
test3
test4
test5
test6
test7
test8
test9
test10