gathering data?

  • Thread starter Thread starter ftahbaz
  • Start date Start date
F

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
 
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.
 
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
Click to expand...
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
 
Back
Top