using VLOOKUP to find if a value is between two columns of values...

[yertleturtle]

I have a table of trading information (Date, Open, High. Low, Close). If the range of prices for today open above yesterday's closing price and never touch this price - this forms a gap. What I would like to do is compare the gap value to two columns of highs and lows to see if this gap has been closed. Ideally I would like to print either "closed" or the gap value in the column adjacent to it.

I've included a sample workbook. Please let me know if I can provide any additional detail.

[David A Coop]

I don't have enough understanding of the market to understand what you are trying to achieve.

Please re-post your Sample with some examples of what you want to achieve with a little more explanation.

Regards,

David

[yertleturtle]

I don't have enough understanding of the market to understand what you are trying to achieve.

Please re-post your Sample with some examples of what you want to achieve with a little more explanation.

Regards,

David

Thanks for taking the time David. In the column labeled "Gap" I would like to see if that value falls between the high and low value of any following days. If it falls between the high-low of any following day I would indicate this with the word "closed" otherwise the gap remains open. I have included a bar chart. The high and low are represented by the high to low of the bar. The open is the tick on the left side and the close is the tick on the right. The gap is considered to be the closing price of a day that hasn't been touched by price of any future day. On the included chart not all gaps have been indicated for clarity. I hope this makes sense.

[vlady]

Good day Yertleturtle.

Just a tip.
Don't post pictures other members can't open them and pictures doesn't really help.

Regards,
Vladimir

[David A Coop]

Hi yertleturtle,

The trading bar-chart really doesn't help. Sorry!

I would like to see your original excel worksheet with the additional columns you wanted added together with the result you want for, say, the first half dozen rows.

Just type in the result - I should then be able to work out the formula.

DAC

[JR DHONA]

good day,

please check attached file,
hopefully can be used.

Regards,
JRD

[yertleturtle]

This looks perfect - thank you JRD!