Excel Help

I'm importing data to Excel and I'm trying to save the high and low price for the day. Any help would be appreciated.

JD Conner

 

MAX and MIN.

 

I tried that but I,m getting data from just one cell.

 

place all data in column A then in cell B1 type the following formula:

=Max(A:A)

within B2 type in the following formula

=Min(A:A)

 

I tried the =max(a:a) it didn't work.
I'm importing the last trade price of a stock in one cell, I like to know the high and low price of that one cell.

 

?

I think we're going to need a bit more info.

 

what feed are you importing from?

 

You'll need to use VBA to compare the cell value to another cell everytime the worksheet updates. I assume you're using a DDE feed or something to get the data in? At any rate, it's not hard to do, the basic logic is this.

Assuming the value is in A1 and you want the high in B1

if A1 > B1 then

B1 = A1

end if

The only thing to remember is that if B1 is blank, it will be treated as 0.

Hope that helps,

- The New Guy

 

It's the high price and low price for the day, just like you see on a quote board.

Last Trade Pr High Low
45.58 45.60 45.40

 

i ask which feed because using IB i can get H/L with the following syntax:

={account}|tik!id0?low
={account}|tik!id0?high