Is the price cell updated via manual entry, or a formula, or a data feed?
--
Gary''s Student - gsnu200857


"dan" wrote:

I made a spreadsheet that tracks my stocks by regularly updating cells with
the current price of the stock, etc. So my profit or loss of a given stock
is displayed in a cell, and then when I tell Excel to update, that value
chagnes. I have been trying to make a column that shows the historical
all-time high and low for this value unsuccessfully. My problem seems to be
when the value in the cell goes from positive to neagative or vice versa.
How can I write a function to show the historical maximum and/or minimum of a
cell that is periodically updated.