The “targets” worksheet in lognormdelta.xls at the models link now completely
implements a gamma waiting time for the mean reversion target to switch to a
new value.
The key to that page (and now a few cells on other pages)
is the EXCEL function OFFSET(cell0, rows, columns).
It puts into the current cell the value it finds by starting at the
cell referenced by cell0 and then shifting by the number of
rows and columns indicated. I.e. it looks up the (rows, columns)
entry in an open-ended matrix extending down and to the right
from cell0. Note carefully, cell0 is NOT the (1,1) entry of
the matrix. That entry is one over and one down from cell0.
If you don’t know that function, finding it out will be worth your
price of admission to the whole computing course.
MC with Logarithm Indices.xlsm
Monte Carlo 2013 05 16xlsm.xlsm
Ig & Igh v7.2 + Mu08032011.xlsm
Ig Igh v7 4 + Mu (2)08092011.xlsm
------