7,649
edits
Changes
Jump to navigation
Jump to search
no edit summary
My starting list comes from [https://en.wikipedia.org/wiki/List_of_stock_market_crashes_and_bear_markets a list of stock market crashes].
Using the largest decline on the Dow of the period year (except for 1994) as the crash day gives:Result(Copy to clipboard){| class="wikitable sortable"! Event !! Start Year !! Class !! Largest SingleDay !! Date !! Notes|-| Black Monday || 1987 || 3 || -22.60% || 10/19/1987 || A -3.8% in 3 days and an -8% follows a week later. Preceeded by a -4.6% 3 days earlier, and a -3.8% 2 days before that.|-| Early 90s recession || 1990 || 2 || -3.30% || 8/6/1990 || It plummets even more on Nov 15th of 1991, with a 3.8%|-| Part II of the early 90s || 1994 || 2 || -2.40% || 2/4/1994 || Almost the same drop on Nov 22nd (actually slightly larger), later in the year|-| Dot Com Crash || 2000 || 3 || -5.70% || 4/14/2000 || A -3.7% five weeks earlier|-| Financial crisis || 2007 || 2 || -3.30% || 2/27/2007 || Lot of volatility later in the year|-| Financial crisis II || 2008 || 3 || -7.90% || 10/15/2008 || Series of ~4% drops in Sept and then some 5-6% ones in Oct/Nov.|-| 2010 Flash Crash || 2010 || 1 || -3.60% || 5/20/2010 || Were -3.2% on 6th May and on 4th June|-| Aug 2011 Fall || 2011 || 1 || -5.50% || 8/8/2011 || First drop was on 4th Aug (-4.3%), then 8th, then 10th (-4.6%). Other bid declines in Sept and Nov.|-| 2015–16 stock market selloff || 2015 || 1 || -3.60% || 8/24/2015 || Was a -3.1% 3 days earlier and a -2.8% a week later|-| Asian Contagion || 1997 || 1 || -7.2% || 10/27/1997 || Had been a 3.1% decline in Aug|-| 1998 Bear Market || 1998 || 2 || -6.40% || 8/31/1998 || Was a -4.2% 4 days earlier, a a -3.4% on the 4th before that. It was also followed by a -3.2% on the 10th Sept.|-| Friday 13th Mini-crash || 1989 || 1 || -6.90% || 10/13/1989 || Appears isolated|}
===Data driven approach===
*2011: 1 obs
*2020: 6 obs (and counting, including second and third largest)
==Scripts and Analysis==
The SQL script Analysis.sql is in E:\projects\stockmarket, as are the source files.
The dbase is '''stockmarket''', and is loaded on mother. It's source files are in Bulk\stockmarket.
