I need to use solver for multiple rows of data. The solver has to be reset for every row, and the solver reference rows have to be changed as well.
For example, I'd like to solve for cell j2, by changing K2, and setting the value to e2.
And I'd have to repeat the process for each row.
Can anyone help?
data.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | |||
1 | OptPx | OptStrikePx | OptUndlPx | Dividend | DividendDays | BlackSchoes | ImpliedVolatility | ||
2 | 15.1 | 35 | 50.15 | 0 | 0 | 15.1 | -10.5209 | ||
3 | 12.6 | 37.5 | 50.15 | 0 | 0 | 12.6 | -10.5236 | ||
4 | 10.3 | 40 | 50.15 | 0 | 0 | 10.3 | 15.80097 | ||
5 | 7.8 | 42.5 | 50.15 | 0 | 0 | 7.800001 | 15.54214 | ||
6 | 5.1 | 45 | 50.15 | 0 | 0 | 5.099999 | -10.5317 | ||
7 | 2.7 | 47.5 | 50.15 | 0 | 0 | 2.7 | 10.66513 | ||
Citi-C |
For example, I'd like to solve for cell j2, by changing K2, and setting the value to e2.
And I'd have to repeat the process for each row.
Can anyone help?