Hi,
how can I "freeze" a given value of a cell which is updated on a realtime
basis, e.g., stock options prices imported from a sort of Bloomberg data
diffusion service? I have a worksheet that evaluates options strategies for
10 options series calculating implied volatility on a realtime basis. What I
need is, once the trader decides to enter a strategy, beginning prices must
be secured (values must be "frozen", de-activating the underlying updating
formulas), but all the same these very formulas should be restored once the
strategy is closed and options positions are zeroed, which happens maybe in
the very same day, or next week. I have 20 of such cells spread throughout
the workbook with 10 worksheets in Excel 2007. Any thoughts?
Thanks very much for any help.
--
Dan GSB
Asset Management - Rio