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.

"carl" wrote:


I have a spread sheet that looks like so before the start
of the trading day:

ColA ColB ColC
ABC 4/7/2005

ColB tracks the trade time of stock ABC - it comes from a live data feed.

When ABC does it's first trade, the spreadsheet looks
like so - and continues to change as subsequent trades occur.

ColA ColB ColC
ABC 9:32:28AM

Is there a macro that will record the time of the first trade and place it in ColC ??


Thank you in advance.