I'm creating an option trading workbook with approximately 70 option trading strategy worksheets. Each worksheet uses functions that dynamically pull live market data into a series cells. To evaluate profit or loss, opening and closing prices must be compared. I'm trying to find a way to save the opening value in a second cell for later reference. Tried using the =VALUE() function, but of course the value changes as the value changes in the referenced cell. Searched Help for static and freeze functions, but these do not exist for dynamically changing values. Any ideas on how to "freeze" the opening value other than having the worksheet users type the opening market value into a cell?
Thanks,
Russ
Thanks,
Russ