Changes

Jump to navigation Jump to search
no edit summary
This page details my exploration of data concerning the [[2020 Stock Market Crash]]. This work spawned a short-form academic paper, [[Empirical Regularities in Stock Market Crashes]], as well as a number of Op. Ed. submissions. I ultimately put [https://www.edegan.com/blog/the-pandemic-stock-market-crash-of-2020/ a lay-version of the historical crash analysis up on my blog].
==Summary==
I could also employ a pure chartist approach, perhaps to give the counterfactual.
==Historical Crash Analysis== ===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. It loads the DJIA, the GSPC, and the crashes file. It will also load the COMPUSTAT pull. ===Op Ed Submissions=== I submitted the following:*Wall Street Journal, Aug 8th. Rejection by silence: Egan (2020) - Category 3 Stock Market Crash (WSJ Op Ed V2-1).docx*New York Times, Aug 13th. Rejection by silence: Egan (2020) - Category 3 Stock Market Crash (WSJ Op Ed V2-2).docx*Finacial Times, Aug 28th, Rejection by silence: Egan (2020) - What to Learn from Past Stock Market Crashes (FT V3).docx*Washington Post, Sept 1st, Rejected by email: Egan (2020) - What to Learn from Past Stock Market Crashes (WP V2).docx ====References the Op Eds==== *Forbes: https://www.forbes.com/sites/sergeiklebnikov/2020/07/23/historical-stock-market-returns-under-every-us-president/#e5c3268faaf4*WSJ: https://www.wsj.com/articles/stock-scenarios-for-a-madcap-year-11597607961*Business insider: https://www.businessinsider.com/stock-market-coronavirus-crash-not-over-how-to-invest-bofa-2020-3 ====Checking results==== I wrote an Op-Ed and submitted it to the WSJ on August 8th. It is in the project folder: E:\projects\stockmarketanalysis\Egan (2020) - Category 3 Stock Market Crash (WSJ Op Ed V2-2).docx (and .pdf) In that article, I included a table of durations, multiples lost, and max declines. I want to check the durations... *First check: Did I double load the index file? Probably not as some durations are odd. DJIAFull.txt has 31127 lines. Table djia has 31126 record, all distinct. *Second check: Durations are calculated by counting records WHERE WHERE reltrading >ppreltrading AND reltrading < refindreltradingfirst in DJIACrashFirst, etc. These queries come from DJIACrashWMarkers, which is blown out by Event (and has 85,732 records). I checked the Asian Contagion and Black Monday. They were fine.*Third check: I manually checked the index file for and calculated the duration of the dot com crash:**I found a -6% on April 14th,2000. The index was a 10305. I worked back.**The prior peak was on Jan 17th, 2000. It was 11722. I worked forward. **The next time the index hit that level was Mar 10th, 2006. There were 1,699 trading days in the interim, which is what I have in the report.**It then stayed above that level until June 26th, 2008... So one crash blends into the next. To Do:*Calculate average annual growth rate and compare it to max decline*Calculate tdays before and after max decline per crash to measure asymmetry. For some reason, the price is missing for 10/26/1940. This causes a #DIV/0! error in excel. I removed it. The average daily return is then 0.0275% and the average annual return (using 252 trading days) is 6.94%. From 1/2/1985 forward, this average is 0.0411% per day or 10.35% per year. It seems that, on average, a third (actually 31%) of a crash occurs before the maximum decline and 2/3rds (actually 69%) occurs afterwards, however, the location of the maximum decline looks pretty random. ===Data=== ====Index Data====
As much as I love the Dow, it accounts for about 25% of the economy, whereas the S&P500 accounts for around 80%. I'll download both from Yahoo:
S&P500 identifiers have apparently become proprietary - WRDS no longer carries them. Also the S&P500 started in 1957, which is long after the Wall Street Crash (I'd like to include this crash!), and historical data is now hard to find. Overall, I think I'll go back the Dow!
==COMPUSTAT ==Interest Rate Spread==== The St. Louis Fed has dataon Aaa and Baa Corporate Bonds:*https://fred.stlouisfed.org/series/AAA*https://fred.stlouisfed.org/series/BAA ===Lit Review=== It seems that there's a non-econ based literature that tries to predict crashes using various statistical techniques. A bunch of these papers appear in the journal "Physica A: Statistical Mechanics and its Applications" (WX Zhou abd D Sornette authored 3 of them, and Sornette wrote a book called "Why stock markets crash: critical events in complex financial systems" [https://pdfs.semanticscholar.org/1e66/1c86a5207d0a8b3a900e4fa333c1b8b3c09d.pdf]). See, for example:*Can one make any crash prediction in finance using the local Hurst exponent idea? [https://arxiv.org/pdf/cond-mat/0311627] *Antibubble and prediction of China's stock market and real-estate [https://arxiv.org/pdf/cond-mat/0312149]*Can we predict crashes? The case of the Brazilian stock market [https://www.sciencedirect.com/science/article/abs/pii/S0378437108009898]*Predicting critical crashes? A new restriction for the free variables [https://arxiv.org/pdf/cond-mat/0204295]*Renormalization group analysis of the 2000–2002 anti-bubble in the US S&P500 index: explanation of the hierarchy of five crashes and prediction [https://arxiv.org/pdf/physics/0301023]*Autoregressive conditional duration as a model for financial market crashes prediction*The use of the Hurst exponent to predict changes in trends on the Warsaw Stock Exchange*Stock market dynamics: Before and after stock market crashes
COMPUSTAT updates its fundamentals quarterly Others in non-finance/econ journals include:*The Nasdaq crash of April 2000: Yet another example of log-periodicity in a speculative bubble ending in a crash [https://arxiv.org/pdf/cond-mat/0004263]*Use of machine learning algorithms and twitter sentiment analysis for stock market prediction [https://acadpubl.eu/jsi/2017-115-6-7/articles/6/69.pdf]*[PDF] Application of neural networks to stock market prediction, AS Kulkarni - Technical Report, 1996 - machine-learning.martinsewell.com [http://www.machine-learning.martinsewell.com/ann/Kulk96.pdf]*Forecasting stock market crisis events using deep and statistical machine learning techniques, SP Chatzis, V Siakoulis, A Petropoulos… - Expert systems with …, 2018 - Elsevier *[BOOK] Stock Market Crashes: Predictable and Unpredictable and What to Do About Them [https://books.google.com/books?hl=en&lr=&id=bJA4DwAAQBAJ&oi=fnd&pg=PR5&dq=stock+market+crashes&ots=mSPcOUqTyO&sig=FsETOYuBRK-OAflUuqN39R13i4Y] In finance, econ, and business journals:*The “CAPS” prediction system and monthly security files dailystock market returns, CN Avery, JA Chevalier, RJ Zeckhauser - Review of Finance, 2016 [https://pdfs.semanticscholar. I did org/8a3d/8baca863c3799eac2db55e9e7abb4853725b.pdf]*Testing for financial crashes using the log periodic power law model DS Brée, NL Joseph - International review of financial analysis, 2013 - Elsevier*Naive trading rules in financial markets and wiener-kolmogorov prediction theory: a pull study of" technical analysis" SN Neftci - Journal of Business, 1991 - JSTOR [http://technicalanalysis.org.uk/chart-patterns/Neft91.pdf]*Stock market bubbles in the laboratory, DP Porter, VL Smith - Applied mathematical finance, 1994 - Taylor & Francis*Investor behavior in the October 1987 stock market crash: Survey evidence, RJ Shiller - 1987 - nber.org [https://www.nber.org/papers/w2446.pdf]*Bubble diagnosis and prediction of the 2005–2007 and 2008–2009 Chinese stock market bubbles, ZQ Jiang, WX Zhou, D Sornette, R Woodard… - Journal of economic …, 2010 - Elsevier [https://arxiv.org/pdf/0909.1007]*Stock market crashes in 2007–2009: were we able to predict them?, S Lleo, WT Ziemba - Quantitative Finance, 2012 - Taylor & Francis*Market volatility prediction and the efficiency of the entire fundamentals quarterly database S & P 100 index option market, CR Harvey, RE Whaley - Journal of Financial Economics, 1992 - Elsevier [http://www.academia.edu/download/7523791/marvol.pdf]*Does trading volume contain information to predict stock returns? Evidence from 2015China's stock markets, CF Lee, OM Rui - Review of Quantitative Finance and Accounting, 2000 - Springer [https://www.researchgate.net/profile/Oliver_Rui/publication/5157464_Does_Trading_Volume_Contain_Information_to_Predict_Stock_Returns_Evidence_from_China%27s_Stock_Markets/links/0912f50d09024af4bc000000/Does-Trading-Volume-Contain-Information-01 to 2020-07Predict-Stock-Returns-Evidence-from-Chinas-Stock-Markets. It pdf]*US stock market crash risk, 1926–2010, DS Bates - Journal of Financial Economics, 2012 - Elsevier*Triggering the 1987 stock market crash: Antitakeover provisions in the proposed house ways and means tax bill? ML Mitchell, JM Netter - Journal of Financial Economics, 1989 - Elsevier [http://schwert.ssb.rochester.edu/f423/JFE87_MN.pdf]*To what extent did stock index futures contribute to the October 1987 stock market crash, A Antoniou, I Garrett - The Economic Journal, 1993 - academic.oup.com*[PDF] A mean-reversion theory of stock-market crashes, E Hillebrand - Journal of Finance, 2003 - cofar.uni-mainz.de [https://www.cofar.uni-mainz.de/dgf2003/paper/paper75.pdf]*Explaining what leads up to stock market crashes: A phase transition model and scalability dynamics, R Yalamova, B McKelvey - Journal of Behavioral Finance, 2011 - Taylor & Francis*Speculative bubbles, crashes and rational expectations, OJ Blanchard - Economics letters, 1979 - Elsevier Particularly useful papers might include:*US stock market crashes and their aftermath: implications for monetary policy, FS Mishkin, EN White - 2002 - nber.org [https://www.nber.org/papers/w8992.pdf]**This paper examines fifteen historical episodes of stock market crashes and their aftermath in the United States over the last one hundred years. *Stock-market crashes and depressions, RJ Barro, JF Ursúa - 2009 - nber.org [https://www.nber.org/papers/w14760.pdf]**Long-term data for 30 countries up to 2006 reveal 232 stock-market crashes (multi-year real returns of–25% or less) and 100 depressions (multi-year macroeconomic declines of 10% or more), with 71 of the cases matched by timing. The United States has close two of the matched …*[BOOK] Stock market crashes and speculative manias, EN White - 1996 - econpapers.repec.org [https://econpapers.repec.org/bookchap/elgeebook/610.htm]**This volume offers an authoritiative selection of the best published articles on the great speculative manias and stock market crashes, which highlights their important similarities. These phenomena disrupt the normal activities of investors who use financial markets to …*The predictability of stock market regime: evidence from the Toronto Stock Exchange,S Van Norden, H Schaller - The Review of Economics and Statistics, 1993 - JSTOR**Thus the existence of bubbles would not only account for occasional asset price crashes but also rapid run-ups in asset pricesbefore a crash. The question we address is whether or not stock market crashes and the booms that precede them are related to apparent deviations …*Stock market crashes and dynamics of aftershocks, P Kapopoulos, F Siokis - Economics Letters, 2005 - Elsevier [https://www.researchgate.net/profile/Panayotis_Kapopoulos2/publication/236983927_Stock_market_crashes_and_dynamics_of_aftershocks/links/5f0c602e299bf1074452e322/Stock-market-crashes-and-dynamics-of-aftershocks.pdf]**We begin with the intuitive observation that short-term business-as -usual process and bubble rising looks like an accelerated energy before an earthquake. In such a framework, the aftershocks resemble the correction process of the stock market. We investigate the statistical properties of stock returns in the financial markets just after a major market crash. It is found that the aftershocks obey the well -known Gutenberg–Richter simple rule in geophysics. Our empirical observations show that the statistical properties of aftershocks sequences in the crashes of late '90s and early '00s are essentially different from the ones observed a decade earlier. ====Questions and Answers==== *Is there an objective definition of a crash?**Barro and Ursua 2009: multi-year real returns of –25% or less. They also define a depression as multi-year macroeconomic declines of 10% or more. Crashes and correlated with minor depressions 31% of the time, and major depressions 10% of the time. In reverse, minor depressions are associated with crashes 71% of the time and major ones 92% of the time.... Part of this analysis entails splitting the sample into different “bins” or categories, defined by the magnitudes of the stock market crashes or by the type of environment that characterized those events; for example, wars, currency or banking crises, and periods of global economic distress.**Mishkin and White 2002: On the face of it, defining a stock market crash or collapse is simple. When you see it, you know it. However, attempting a more precise definition and measurement over the course of a century is more difficult. ... As both fell slightly over 20 percent, a 20 percent drop in the market is used to define a stock market crash. The fall in the market, the depth is, however, only one characteristic of a crash. Speed is another feature. Therefore, we look at declines over windows of one day, five days, one month, three months, and one year...  *Is there a taxonomy of stock market crashes?**Mishkin and White 2002: The description of the fifteen episodes of twentieth-century stock market crashes suggests that we can place them into four categories. 1. Episodes in which the crashes did not appear to put stress on the financial system because interest-rate spreads did not widen appreciably. These include the crashes of 1903, 1940, 1946, 1962 and 2000. 2. Episodes in which the crashes were extremely sharp and which put stress on the 31 financial system, but where there was little widening of spreads subsequently because of intervention by the Federal Reserve to keep the financial system functioning in the wake of these crashes. These include the crashes of 1929 and 1987. 3. Episodes in which the crashes were associated with large increases in spreads suggesting severe financial distress. These include the crashes of 1907, 1930-33, 1937, 1973-74. 4. Episodes in which the crashes were associated with increases in spreads that were not as highs large as in the third category, suggesting some financial distress. These include the crashes of 1917, 1920, 1969-70 and lows1990. *Are there standard measures of a crash?**First drop from peak**Largest drop from peak**Time to first recovery to peak**Time to sustained recovery to peak**Off-performance area (i. e., days x difference from the peak?) Should I pulled closefactor in expected growth?**Number of drops? Precursory volatility? Total volatility? Scripts to build:*Identify a slump:**Automated: could calculate all 1 day, as averaging highs 1 week, 1 month, 3 month, or 1-year cumulative drops and lows seems like look for those of more than 20% a la Mishkin vs. 25% a la using Barro.*Find the previous peak.*Find any transitive returns to the peak.*Find the 'permanent' return to peak (it turns out that you can go from crash to crash).*Calculate area lost in point-days and percent-days. ===Other Notes=== ====Exploring Complexity==== [https://en.wikipedia.org/wiki/Self-organized_criticality Self-Organizing Criticality], which gives rise to [https://en.wikipedia.org/wiki/Scale_invariance Scale Invariance], might be skewed given provide a model. See the context (especially over short time periods)[https://en.wikipedia.org/wiki/Abelian_sandpile_model Abelian sandpile model] as a place to start====Playing with Crashes====
==Historic Crashes==This is a legacy subsection. It was superseded by the approach embodied in the scripts. I've left it here because it provides some useful base data for readers interested in the problem.
Data before the 1980s probably isn't useful. It was a different world back then, both in terms of globalization and in terms of how stock markets worked. So, I'll start with the 1987 crash and go forward from there. I originally tried to suggest three classes of crash, like hurricanes:
|}
=====Data driven approach=====
Identify crashes as using the largest single-day declines on the DJIA:
*2020: 6 obs (and counting, including second and third largest)
I revamped this approach to find 12 crashes (14 including the current one and the 1929 Wall Street Crash) and the data naturally groups itself into 4 categories. See the next sectionsscripts.
==Scripts and PE Analysis==
The SQL script Analysis.sql is in E:\projects\stockmarket, as are the source files.===COMPUSTAT data===
The dbase is '''stockmarket''', and is loaded on mother. It's source files are in Bulk\stockmarket. It loads the DJIA, the GSPC, and the crashes file. It will also load the COMPUSTAT pull. ==Lit Review== It seems that there's a non-econ based literature that tries to predict crashes using various statistical techniques. A bunch of these papers appear in the journal "Physica A: Statistical Mechanics and updates its Applications" (WX Zhou abd D Sornette authored 3 of them, fundamentals quarterly and Sornette wrote a book called "Why stock markets crash: critical events in complex financial systems" [https://pdfsmonthly security files daily.semanticscholar.org/1e66/1c86a5207d0a8b3a900e4fa333c1b8b3c09d.pdf]). See, for example:*Can one make any crash prediction in finance using the local Hurst exponent idea? [https://arxiv.org/pdf/cond-mat/0311627] *Antibubble and prediction of China's stock market and real-estate [https://arxiv.org/pdf/cond-mat/0312149]*Can we predict crashes? The case of the Brazilian stock market [https://www.sciencedirect.com/science/article/abs/pii/S0378437108009898]*Predicting critical crashes? A new restriction for the free variables [https://arxiv.org/pdf/cond-mat/0204295]*Renormalization group analysis of the 2000–2002 anti-bubble in the US S&P500 index: explanation of the hierarchy of five crashes and prediction [https://arxiv.org/pdf/physics/0301023]*Autoregressive conditional duration as I did a model for financial market crashes prediction*The use pull of the Hurst exponent to predict changes in trends on the Warsaw Stock Exchange*Stock market dynamics: Before and after stock market crashes Others in non-finance/econ journals include:*The Nasdaq crash of April 2000: Yet another example of log-periodicity in a speculative bubble ending in a crash [https://arxiv.org/pdf/cond-mat/0004263]*Use of machine learning algorithms and twitter sentiment analysis for stock market prediction [https://acadpubl.eu/jsi/2017-115-6-7/articles/6/69.pdf]*[PDF] Application of neural networks to stock market prediction, AS Kulkarni - Technical Report, 1996 - machine-learning.martinsewell.com [http://www.machine-learning.martinsewell.com/ann/Kulk96.pdf]*Forecasting stock market crisis events using deep and statistical machine learning techniques, SP Chatzis, V Siakoulis, A Petropoulos… - Expert systems with …, 2018 - Elsevier *[BOOK] Stock Market Crashes: Predictable and Unpredictable and What to Do About Them [https://books.google.com/books?hl=en&lr=&id=bJA4DwAAQBAJ&oi=fnd&pg=PR5&dq=stock+market+crashes&ots=mSPcOUqTyO&sig=FsETOYuBRK-OAflUuqN39R13i4Y] In finance, econ, and business journals:*The “CAPS” prediction system and stock market returns, CN Avery, JA Chevalier, RJ Zeckhauser - Review of Finance, 2016 [https://pdfs.semanticscholar.org/8a3d/8baca863c3799eac2db55e9e7abb4853725b.pdf]*Testing for financial crashes using the log periodic power law model DS Brée, NL Joseph - International review of financial analysis, 2013 - Elsevier*Naive trading rules in financial markets and wiener-kolmogorov prediction theory: a study of" technical analysis" SN Neftci - Journal of Business, 1991 - JSTOR [http://technicalanalysis.org.uk/chart-patterns/Neft91.pdf]*Stock market bubbles in the laboratory, DP Porter, VL Smith - Applied mathematical finance, 1994 - Taylor & Francis*Investor behavior in the October 1987 stock market crash: Survey evidence, RJ Shiller - 1987 - nber.org [https://www.nber.org/papers/w2446.pdf]*Bubble diagnosis and prediction of the 2005–2007 and 2008–2009 Chinese stock market bubbles, ZQ Jiang, WX Zhou, D Sornette, R Woodard… - Journal of economic …, 2010 - Elsevier [https://arxiv.org/pdf/0909.1007]*Stock market crashes in 2007–2009: were we able to predict them?, S Lleo, WT Ziemba - Quantitative Finance, 2012 - Taylor & Francis*Market volatility prediction and the efficiency of the S & P 100 index option market, CR Harvey, RE Whaley - Journal of Financial Economics, 1992 - Elsevier [http://www.academia.edu/download/7523791/marvol.pdf]*Does trading volume contain information to predict stock returns? Evidence entire fundamentals quarterly database from China's stock markets, CF Lee, OM Rui - Review of Quantitative Finance and Accounting, 2000 - Springer [https://www.researchgate.net/profile/Oliver_Rui/publication/5157464_Does_Trading_Volume_Contain_Information_to_Predict_Stock_Returns_Evidence_from_China%27s_Stock_Markets/links/0912f50d09024af4bc000000/Does-Trading-Volume-Contain-Information2015-01 to2020-Predict-Stock-Returns-Evidence-from-Chinas-Stock-Markets07.pdf]*US stock market crash risk, 1926–2010, DS Bates - Journal of Financial Economics, 2012 - Elsevier*Triggering the 1987 stock market crash: Antitakeover provisions in the proposed house ways and means tax bill? ML Mitchell, JM Netter - Journal of Financial Economics, 1989 - Elsevier [http://schwert.ssb.rochester.edu/f423/JFE87_MN.pdf]*To what extent did stock index futures contribute to the October 1987 stock market crash, A Antoniou, I Garrett - The Economic Journal, 1993 - academic.oup.com*[PDF] A mean-reversion theory of stock-market crashes, E Hillebrand - Journal of Finance, 2003 - cofar.uni-mainz.de [https://www.cofar.uni-mainz.de/dgf2003/paper/paper75.pdf]*Explaining what leads up to stock market crashes: A phase transition model and scalability dynamics, R Yalamova, B McKelvey - Journal of Behavioral Finance, 2011 - Taylor & Francis*Speculative bubbles, crashes and rational expectations, OJ Blanchard - Economics letters, 1979 - Elsevier Particularly useful papers might include:*US stock market crashes and their aftermath: implications for monetary policy, FS Mishkin, EN White - 2002 - nber.org [https://www.nber.org/papers/w8992.pdf]**This paper examines fifteen historical episodes of stock market crashes and their aftermath in the United States over the last one hundred years. *Stock-market crashes and depressions, RJ Barro, JF Ursúa - 2009 - nber.org [https://www.nber.org/papers/w14760.pdf]**Long-term data for 30 countries up to 2006 reveal 232 stock-market crashes (multi-year real returns of–25% or less) and 100 depressions (multi-year macroeconomic declines of 10% or more), with 71 of the cases matched by timing. The United States It has two of the matched …*[BOOK] Stock market crashes and speculative manias, EN White - 1996 - econpapers.repec.org [https://econpapers.repec.org/bookchap/elgeebook/610.htm]**This volume offers an authoritiative selection of the best published articles on the great speculative manias and stock market crashes, which highlights their important similarities. These phenomena disrupt the normal activities of investors who use financial markets to …*The predictability of stock market regime: evidence from the Toronto Stock Exchange,S Van Norden, H Schaller - The Review of Economics and Statistics, 1993 - JSTOR**Thus the existence of bubbles would not only account for occasional asset price crashes but also rapid run-ups in asset close prices before a crash. The question we address is whether or not stock market crashes and the booms that precede them are related to apparent deviations …*Stock market crashes and dynamics of aftershocks, P Kapopoulos, F Siokis - Economics Letters, 2005 - Elsevier [https://www.researchgate.net/profile/Panayotis_Kapopoulos2/publication/236983927_Stock_market_crashes_and_dynamics_of_aftershocks/links/5f0c602e299bf1074452e322/Stock-market-crashes-and-dynamics-of-aftershocks.pdf]**We begin with the intuitive observation that short-term business-as-usual process and bubble rising looks like an accelerated energy before an earthquake. In such a framework, the aftershocks resemble the correction process of the stock market. We investigate the statistical properties of stock returns in the financial markets just after a major market crash. It is found that the aftershocks obey the well-known Gutenberg–Richter simple rule in geophysics. Our empirical observations show that the statistical properties of aftershocks sequences in the crashes of late '90s and early '00s are essentially different from the ones observed a decade earlier. ==Questions== *Is there an objective definition of a crash?**Barro and Ursua 2009: multi-year real returns of –25% or less. They also define a depression as multi-year macroeconomic declines of 10% or more. Crashes highs and correlated with minor depressions 31% of the time, and major depressions 10% of the timelows. In reverse, minor depressions are associated with crashes 71% of the time and major ones 92% of the time.... Part of this analysis entails splitting the sample into different “bins” or categories, defined by the magnitudes of the stockmarket crashes or by the type of environment that characterized those events; for example, wars, currency or banking crises, and periods of global economic distress.**Mishkin and White 2002: On the face of it, defining a stock market crash or collapse is simple. When you see it, you know it. HoweverI pulled close, attempting a more precise definition and measurement over the course of a century is more difficult. ... As both fell slightly over 20 percent, a 20 percent drop in the market is used to define a stock market crash. The fall in the market, the depth is, however, only one characteristic of a crash. Speed is another feature. Therefore, we look at declines over windows of one day, five days, one month, three months, and one year....  *Is there a taxonomy of stock market crashes?**Mishkin and White 2002: The description of the fifteen episodes of twentieth century stock market crashes suggests that we can place them into four categories. 1. Episodes in which the crashes did not appear to put stress on the financial system because interest-rate spreads did not widen appreciably. These include the crashes of 1903, 1940, 1946, 1962 and 2000. 2. Episodes in which the crashes were extremely sharp and which put stress on the 31 financial system, but where there was little widening of spreads subsequently because of intervention by the Federal Reserve to keep the financial system functioning in the wake of these crashes. These include the crashes of 1929 and 1987. 3. Episodes in which the crashes were associated with large increases in spreads suggesting severe financial distress. These include the crashes of 1907, 1930-33, 1937, 1973-74. 4. Episodes in which the crashes were associated with increases in spreads that were not as large as in the third category, suggesting some financial distress. These include the crashes of 1917, 1920, 1969-70 averaging highs and 1990. *Are there standard measures of a crash?**First drop from peak**Largest drop from peak**Time to first recovery to peak**Time to sustained recovery to peak**Off-performance area (i.e., days x difference from peak?) Factoring expected growth?**Number of drops? Precursory volatility? Total volatility? Scripts to build:*Identify a slump:**Automated: could calculate all 1 day, 1 week, 1 month, 3 month or 1 year cumulative drops and look for those of more than 20% a la Mishkin vs. 25% a la using Barro.*Find the previous peak.*Find any transitive returns to peak.*Find the 'permanent' return to peak (lows seems like it turns out that you can go from crash to crash).*Calculate area lost in point-days and percent-days. ==Exploring Complexity== [https://en.wikipedia.org/wiki/Self-organized_criticality Self-Organizing Criticality], which gives rise to [https://en.wikipedia.org/wiki/Scale_invariance Scale Invariance], might provide a model. See the [https://en.wikipedia.org/wiki/Abelian_sandpile_model Abelian sandpile model] as a place to start. ==Checking results== I wrote an Op-Ed and submitted it to be skewed given the WSJ on August 8th. It is in the project folder: E:\projects\stockmarketanalysis\Egan context (2020) - Category 3 Stock Market Crash (WSJ Op Ed V2-2).docx (and .pdf) In that article, I included a table of durations, multiples lost, and max declines. I want to check the durations... *First check: Did I double load the index file? Probably not as some durations are odd. DJIAFull.txt has 31127 lines. Table djia has 31126 record, all distinct. *Second check: Durations are calculated by counting records WHERE WHERE reltrading >ppreltrading AND reltrading < refindreltradingfirst in DJIACrashFirst, etc. These queries come from DJIACrashWMarkers, which is blown out by Event (and has 85,732 records). I checked the Asian Contagion and Black Monday. They were fine.*Third check: I manually checked the index file for and calculated the duration of the dot com crash:**I found a -6% on April 14th,2000. The index was a 10305. I worked back.**The prior peak was on Jan 17th, 2000. It was 11722. I worked forward. **The next especially over short time the index hit that level was Mar 10th, 2006. There were 1,699 trading days in the interim, which is what I have in the report.**It then stayed above that level until June 26th, 2008... So one crash blends into the next. To Do:*Calculate average annual growth rate and compare it to max decline*Calculate tdays before and after max decline per crash to measure asymmetry. For some reason, the price is missing for 10/26/1940. This causes a #DIV/0! error in excel. I removed it. The average daily return is then 0.0275% and the average annual return (using 252 trading days) is 6.94%. From 1/2/1985 forward, this average is 0.0411% per day or 10.35% per year. It seems that, on average, a third (actually 31%) of a crash occurs before the maximum decline and 2/3rds (actually 69%) occurs afterwards, however, the location of the maximum decline looks pretty random. ==Other sources for the Op Ed== *Forbes: https://www.forbes.com/sites/sergeiklebnikov/2020/07/23/historical-stock-market-returns-under-every-us-president/#e5c3268faaf4*WSJ: https://www.wsj.com/articles/stock-scenarios-for-a-madcap-year-11597607961*Business insider: https://www.businessinsider.com/stock-market-coronavirus-crash-not-over-how-to-invest-bofa-2020-3 ==Interest Rate Spread== The St. Louis Fed has data on Aaa and Baa Corporate Bonds:*https://fred.stlouisfed.org/series/AAA*https://fred.stlouisfed.org/series/BAA ==Op Ed Submissions== I submitted the following:*Wall Street Journal, Aug 8th. Rejection by silence: Egan (2020) - Category 3 Stock Market Crash (WSJ Op Ed V2-1).docx*New York Times, Aug 13th. Rejection by silence: Egan (2020) - Category 3 Stock Market Crash (WSJ Op Ed V2-2).docx*Finacial Times, Aug 28th, Rejection by silence: Egan (2020) - What to Learn from Past Stock Market Crashes (FT V3).docx*Washington Post, Sept 1st, Rejected by email: Egan (2020) - What to Learn from Past Stock Market Crashes (WP V2periods).docx

Navigation menu