"carl" wrote in message
...
thank you for the reply.

I only want to track the first trade.

The data feed is a DDE Link to Thompson (ILX). Every time a trade occurs,
the value changes. I only want to record the first vallue (the first trade
of
the day).

Will the solution you propose only record in ColC that first change in the
ColB's value or will it record all subsequent change.

Also, I'm trying to track 500 stocks.

Best Regards.


I have found a link that relates to this problem. It does use the
Worksheet_Change event and it enters a timestamp in a cell. In your case,
you first need to check the cell where the change happened, it should be in
column B. If the change happens in say B20, you need to check if C20 is
empty. If it is, insert the timestamp. This means that only the first change
is tracked.

Actually, the very first thing you need to do is yo make sure that the the
event is triggered by the DDE link as something is changed

http://www.mcgimpsey.com/excel/timestamp.html

/Fredrik