gathering data?

[ftahbaz@gmail.com]

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@gmail.com]

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.


ftahbaz@gmail.com wrote:
> 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

[Bill Sharpe]

ftahbaz@gmail.com wrote:
> 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