What I am going to show here is the distributions for the time at which highs and lows are put in during the intraday trading session. I am using FXCM data here and they are set to NY time zone. I feel this data is more suitable to this audience for this article rather than my aggregate feed with over 20 liquidity providers. As you will not be able to reproduce it easily without paying for pro data. Also the difference in results are going to be negligible. I also calibrated the charts to roll over at midnight, not any sessions opening. There is a note below.
There is a few things I want to address with this test. This is the first part of a multi part series on the anatomy of a day and possible usage of this information. So be patient. Also I want to address the adage that highs and lows are put in during London and New York. Which is why they are the best times to trade, or so some gurus say. So part my own exploration, part research, and part trading myth busters. Which is exactly the combination of stuff I like to put out.
Testing Procedure:
This test was conducted using 5 minute bars (OHLC) from 6-28-2005 until 1-3-2014. Data was derived from the FXCM feed (not from their platform but from institutional stand alone client). I then use a script to record the times of the highs and lows and then plot in a histogram in excel. its really straight forward.
High Low Distribution over Time (NY)
NOTE: why is there a big spike at midnight? well this comes from the roll over of the script. It is rolling over on 2400 rather than any “session start”. Why did i pick it that way? Because that’s how time is told universally. I read the spike as the start of a unidirectional day, so yesterdays low ends up being today’s high, or vice versa. Although it looks large, its only happened less than 60 times in over 9 years. Don’t let the scale fool you.
Now to the main bit, when and where are the most highs and lows put in? Well if you notice the chart, high and low distribution are basically identical. There are no really large spikes of once without the other, or areas void of any one type.
Lets examine the big chunk between 0000 and 0300. Why is that there? I thought the highs and lows are put in during the London Session? Well it turns out that is false. London session (approx. 0300-0700) really is a lull time of extremes. it seems that the highs and lows are put in during the late Tokyo session. I know this was not expected but hey. its why we do research.
What about that big spike? Turns out that happens at 0700-1000 NY time. Which correlates well to US based news releases like, NFP, Fed report, and the opening of the US markets. So that is actually verified as a extreme time. It also makes highly logical sense, as we all have seen the volatility created by those reports themselves.
Cumulative Distribution of Highs and Lows (NY time)
This chart is much simpler but actually shows more instantly useable information. I am using the 60 % line. Which this graph comes to at around 0925 NY time.
What does it mean? it means that by this time 0925 there is more than 60 % chance that the high or low has been put in for the day. I think everyone can figure out how that is extremely useful. Being able to determine that a high or low will be “set” increases as time goes on. So if your looking for a new high to be put in after say 1600, then your only going to get that < 20 % of the time.
Summary:
Given the first graph. We can see that actually late Tokyo and possibly Tokyo- London cross over are the 1st phase of the markets movements that are going to set an extreme for the day. This is rather different than what I hear floating around the internet about when its going to be placed, in the London session itself. New York Open is actually the absolute best time for an extreme to come into play, and it seems highly correlated to the times of US based news announcements.
The 2nd graph is highly straight forward and easy to understand. After 0925 the chance for a new high or low for the day is less than 40 %, or 60 % that it has already been put in. Its easy to gauge our selves if we are looking for that new high, or new low after that time. We can at least be wary of “asking too much from the market”