I have a time seriers (stock prices)
It's intraday data, 10 mins bars, so this mean each row of data that has open,high,low,close, time data is for 10mins (not a full day).
I want to be able to identify starting from 9:30AM, does price move up 30 pips (points) before it moves down 50 points.
So for example, for forex data EURUSD instrument.
At 9:30AM the price can be 1.06840, then by the close of the day the price can be 1.06940, so price went up, but between the start and end of the day there could be a million possibilities on how it got there.
So i need to know if my stop got hit first or if my target got hit first.
It could have gone up 30 pips, and then down 50 pips, and then back up 100pips.
In a timetable, where we have time, open, high, low, close.
how can I know which if the close first hit a level of 1.06870 first, or did it hit 1.06810.
How do i know number showed up first within a table?