Flash Crash: Follow the Money
In reviewing the Report of the of the staffs of the CFTC and SEC to the Joint Advisory Committee on Emerging Regulatory Issues, and the prepared testimony of SEC Chairman before the Subcommittee on Securities, Insurance and Investment of the United States Senate Committee on Banking, Housing, and Urban Affairs, I was enthralled by the thoroughness of the investigation into the market mechanisms and structure that caused the precipitous drop and sudden loss of liquidity in United States Markets.
The complexity of this problem is highlighted in the Next Steps section of the report near the end, and it concludes that a detailed reconstruction of the markets involving hundreds of millions or records comprising an estimated five to ten terabytes of information must be analyzed so that cross-market patterns can be detected and then the behavior of stocks and traders can be analyzed in detail in order to solve the problem of “what caused the drop?”.
While I unquestioningly agree with the complexity involved in answering the question “what caused the drop?” I also wonder if focusing solely on that question is a bit myopic.
I find that when I am faced with a very complex problem, that if I work through a number of restatements of the problem, I will often identify other worthwhile problems to solve that will allow me to see the data differently. Often, the restatements are less complicated than the original problem.
“Who profited from the drop?” seems to me like a very good question to ask and could bring different answers and solutions into focus.
First, since the possibility of a very large sell order precipitating the “flash crash” cannot be discounted, it is possible that following the money could lead to the origination of said sell order(s).
Second, and far more important in my opinion, is the issue raised by the SEC chairman in her prepared testimony regarding whether market professionals fully met their best execution obligations during the “flash crash”. I believe that the answer to this question and more can be more accurately discovered by following the money.
If the markets during normal volatility can be compared to a game of musical chairs with market participants following a somewhat orderly procession until an economic factor occurs (the music stops) and there is a rush for the chairs (exits), then by comparison the afternoon of May 6th was a game of musical chairs where the music stopped and the lights went out at the same time. While it is important to understand why the lights went out, it is also important to thoroughly investigate the conduct of professional market participants while it was dark.
Below are tables 1&2 combined, taken from the Joint Report on page 20. The tables show the # trades, volume, and dollar volume for gains and losses between 2:40 pm and 3:00 pm in percentage terms. I added the columns percent of trades and percent of dollars.
|
|
Total Trades |
Total Vol |
Total $ Vol |
% trades |
% dollars |
|
|
|
|
|
|
|
|
All trades |
7,135,104 |
1,995,000,637 |
56,651,582,692 |
|
|
|
|
|
|
|
|
|
|
Gains |
2,121,380 |
636,291,411 |
18,603,965,183 |
30% |
33% |
|
|
|
|
|
|
|
|
0% to 10% |
2,108,076 |
632,378,310 |
18,079,956,948 |
99% |
97% |
|
10%-20% |
10,075 |
3,039,456 |
53,123,704 |
0% |
0% |
|
20%-30% |
927 |
281,383 |
8,589,789 |
0% |
0% |
|
30%-40% |
517 |
167,439 |
1,827,449 |
0% |
0% |
|
40%-50% |
106 |
32,866 |
536,641 |
0% |
0% |
|
50%-60% |
45 |
19,188 |
358,048 |
0% |
0% |
|
60%-70% |
67 |
14,466 |
387,321 |
0% |
0% |
|
70%-80% |
184 |
46,456 |
1,147,215 |
0% |
0% |
|
80%-90% |
178 |
44,075 |
1,143,775 |
0% |
0% |
|
>90% |
1,205 |
267,772 |
456,894,313 |
0% |
2% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Losses |
5,013,724 |
1,358,709,226 |
38,047,617,508 |
70% |
67% |
|
|
|
|
|
|
|
|
0% to 10% |
4,912,125 |
1,324,448,213 |
37,383,122,363 |
98% |
98% |
|
10%-20% |
63,860 |
22,171,745 |
522,444,343 |
1% |
1% |
|
20%-30% |
12,923 |
4,077,881 |
85,328,519 |
0% |
0% |
|
30%-40% |
6,112 |
2,317,245 |
30,461,333 |
0% |
0% |
|
40%-50% |
2,519 |
767,393 |
9,641,261 |
0% |
0% |
|
50%-60% |
1,682 |
472,624 |
8,334,944 |
0% |
0% |
|
60%-70% |
1,056 |
370,920 |
4,328,898 |
0% |
0% |
|
70%-80% |
798 |
292,061 |
2,245,851 |
0% |
0% |
|
80%-90% |
1,109 |
237,259 |
1,152,480 |
0% |
0% |
|
>90% |
11,510 |
3,553,885 |
557,516 |
0% |
0% |
70% of all trades during this period were losses and 30% of trades were gains. Interestingly though, the dollar losses were 67% versus 33% gains. Furthermore, what stands out as a red flag is that the majority of the extra dollar gains were trade profits >90% away from the 2:40pm price. This is a very good place to focus the lens.
Here I show only the trades between 2:40 and 3:00pm on May 6th with gains or losses greater than 10%. Again, I added the percent of trades that were gains and percent of trades that were losses.
|
Btwn 2:40:3:00 |
Gains>10% |
Losses > 10% |
Totl trades>10% |
%gains trades |
%losses trades |
|
10%-20% |
10075 |
63,860 |
73,935 |
14% |
86% |
|
20%-30% |
927 |
12,923 |
13,850 |
7% |
93% |
|
30%-40% |
517 |
6,112 |
6,629 |
8% |
92% |
|
40%-50% |
106 |
2,519 |
2,625 |
4% |
96% |
|
50%-60% |
45 |
1,682 |
1,727 |
3% |
97% |
|
60%-70% |
67 |
1,056 |
1,123 |
6% |
94% |
|
70%-80% |
184 |
798 |
982 |
19% |
81% |
|
80%-90% |
178 |
1,109 |
1,287 |
14% |
86% |
|
>90% |
1,205 |
11,510 |
12,715 |
9% |
91% |
|
Total |
13,304 |
101,569 |
114,873 |
12% |
88% |
The trade data of gains and losses greater than 10% between 2:40pm and 3:00pm on May 6th is decidedly skewed toward losses with 88% of the trades being losers verses 70% for all trades during this period.
It would be very interesting to see this subset of data (and the dollar volume data below) broken out by accounts categorized into retail and professional for comparison. I think that could provide additional insight into how the professionals conducted themselves while the lights were out.
Here is a breakdown of the red flag data from above. Notice the marked difference in dollar gains starting around 70%-80% through > than 90%. I don’t think it is too much of a stretch to surmise that this was the buy-to-close zone for sophisticated short sellers. In a free falling market this data leaps off the page as a pretty tight grouping.
Of particular note is the detail of the > than 90% red flag data where only 9% of the trades reaped greater than 99% of dollars gained. By examining these buy-to-close trades, and matching them with their sell-to-open counterparts, the CFTC / SEC might discover interesting information regarding market participant involvement on May 6, 2010.
|
Btwn 2:40:3:00 |
Gains |
Losses |
Tot $ Vol |
%gain $ |
%loss $ |
|
10%-20% |
53,123,704 |
522,444,343 |
575,568,047 |
9% |
91% |
|
20%-30% |
8,589,789 |
85,328,519 |
93,918,308 |
9% |
91% |
|
30%-40% |
1,827,449 |
30,461,333 |
32,288,782 |
6% |
94% |
|
40%-50% |
536,641 |
9,641,261 |
10,177,902 |
5% |
95% |
|
50%-60% |
358,048 |
8,334,944 |
8,692,992 |
4% |
96% |
|
60%-70% |
387,321 |
4,328,898 |
4,716,219 |
8% |
92% |
|
70%-80% |
1,147,215 |
2,245,851 |
3,393,066 |
34% |
66% |
|
80%-90% |
1,143,775 |
1,152,480 |
2,296,255 |
50% |
50% |
|
>90% |
456,894,313 |
557,516 |
457,451,829 |
100% |
0% |
|
Total |
524,008,255 |
664,495,145 |
1,188,503,400 |
44% |
56% |
Examining the events of the “flash crash” through the lens of market mechanism and structure will very likely provide additional clues about specific catalysts that contributed to the exaggerated price swings and liquidity vacuum as measured by broken trades, bid/offer spreads, self-help declarations, and outsized ETF factors. However, in order to identify whether or not market participants conducted themselves professionally, ethically, and even legally is better viewed through a money lens.
By focusing the money lens on a very small sampling of the market data that I was able to glean from the report, I believe I uncovered helpful information about market participants on May 6th, 2010.









Comments