On Apr 2, 3:50 pm, "merjet" wrote:
What only matters is the profit and loss (p/l) level,
which changing constantly. Can the code above be
used when there is only one cell involved?

Maybe 'yes' for the $25000 gain. You haven't said
how the p/l cell changes. 'No' for the 1/3rd loss,
since more info than simply the p/l is needed.

Merjet

The P/L (which can also be any price of a stock for example) is
derived from an application that is connected directly to Excel (from
Reuters database). Maybe if we think of it as a price of a stock that
is changing throughout the day (and has no code or formula), it will
be easier. So, I am looking for excel to capture the highest price of
the day and save it on a different cell. If the stock started the day
at 50, went to 60, dropped to 40 and went back to 59, excel will show
60 has the highest price until the price exceeds it.

Amir