|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Testing multiple values of two independant variables and charting results
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 Last edited by sgcannon; 10-20-2015 at 10:19 AM. Reason: clarification |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
Same values of variables in word add-in are being shared across multiple document | naq.abbas@gmail.com | Word | 0 | 01-13-2014 10:41 AM |
independant columns | cbrooks103 | Word | 1 | 02-24-2013 11:54 AM |
Assigning Values to content control checkboxes and calculating results | creative cathy | Word Tables | 13 | 10-07-2012 08:52 PM |
add values from different variables with pivot table | andrei | Excel | 2 | 01-19-2012 08:45 AM |