software

I would like to know how to show the high value and low value of a cell that
is showing the trade by trade of a stock.

It depends on how your data is organized. To get the minimum or maximum of a
range, you can use:

=min(a1:a100)
=max(a1:a100)

If your data is organized some other way, let us know.

--
Regards,
Fredquot;Stock Helpquot; lt;Stock gt; wrote in message
...
gt;I would like to know how to show the high value and low value of a cell that
gt; is showing the trade by trade of a stock.
One way:
'The low number is shown in B1, the high in C1. The changing cell is A1.
'Put 1000000 in B1 and quot;0quot; in C1 to begin
Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Target) Then Exit Sub
If Target.Address(0, 0) = quot;A1quot; Then
If Target.Value lt; [B1].Value Then [B1].Value = Target.Value
If Target.Value gt; [C1] Then [C1].Value = Target.Value
End If
End Sub
HTH Otto
quot;Stock Helpquot; lt;Stock gt; wrote in message
...
gt;I would like to know how to show the high value and low value of a cell
gt;that
gt; is showing the trade by trade of a stock.