gathering data?

[ftahbaz]

I am a day trader and I look at live market data in Excel. Basically I
input a stock symbol and the price is updated each time a trade goes
through. What I am trying to do is this:

Is there any way to capture what the highest or lowest number that came
through the "price" cell? I mean I can watch it all day and record it
manually, but is there any way to have another cell that will
automatically update what the highest number that has come through that
cell was?

Thanks for the help

 

[ftahbaz]

Also... I know some may say that I can easily get HIGH/LOW stock price
info with my trading platofrm...but I am trying to do it all through
Excel.

 

[Bill Sharpe]

I am a day trader and I look at live market data in Excel. Basically I
input a stock symbol and the price is updated each time a trade goes
through. What I am trying to do is this:

Is there any way to capture what the highest or lowest number that came
through the "price" cell? I mean I can watch it all day and record it
manually, but is there any way to have another cell that will
automatically update what the highest number that has come through that
cell was?

Thanks for the help

If you use the MSN Money Central Stock Quote add-in, two properties of
the MSNStockQuote function -- High and Low -- will give you the numbers
you want in Excel.

Bill