A.I.M. Users Bulletin Board

[Conrad]

Anybody: Excel Question.

Not being as skilled as Gummy is(was)with Excel, I want to know if it is possible to "fix" a number in any cell in which a formula calculates the value.
Other than obviously typing the number into that cell manual I thought there might be a formal way to "fix" the value of the cell as a number so that it can no longer be changed by the formula.

I would call it "Freezing" the formula. For any future calculation with for example different parameters the "fixed" cells would not be affected.

An obvious application in regards to AIMing is that if a trade has been made in an actual investment this trade can not be undone or altered and should remain fixed in the spread sheet. The trades of he past must remain as the are. I also like to use it for changing the parameters at some date in an historical data set that I use for parameter optimisation. After having added new dates and process I have to "freeze" the old data sets as they are part of a Test Run that includes the data from before the Big Freeze.

Regards,