Testing multiple values of two independant variables and charting results

[sgcannon]

I have a very large set of stock market data. I have a formula that I'd like to use to execute buys and sells. Within the formula are two independent variables, one for buys and one for sells. I'd like to see which combination of buy/sell variables will produce the greatest profit when used retrospectively on my data set.



I can plug the numbers into the formula manually ie. test the formula with the buy variable at 0.0 and then run through sell variables from 0.0 to 5.0 in increments of 0.1. Then repeat the formula using all values of buy variables up to 5.0, again in 0.1 increments. But that would be 2500 iterations. I'd like to have a grid where the buy variables are in the horizontal axis and the sell variables are in the vertical axis and Excel fills out the profit values using my formula for each combination of buy/sell variables. Is this possible?

Thanks,

Steve