Hi, I need some help!

I'm looking at tick data of stock prices

I have, date, open, high/low, high/low, close

3rd (C) and 4th (D) column (high or low) are either high or low. Meaning since this is tick, in column C and D there is a value for either a high or low. If the low came first then column C will have that value.. And the high will be in column D.

Then I have profit targets and stop loss target. I'm trying to come up with a logic that will tell me if my profit target was hit first or if my profit target was hit first.

Let's say if column C had the high first and my profit target was less than the high. Then that means my profit target was hit. Or if the low came first in column C and my stop loss was larger than the low.. That means my stop loss was hit (since the price kept on going down.. Below my stoploss)

Any thoughts?? Thx!