« Inspired by Tetris | Main | Animal racetrack »


Gavin Andresen

That IS a sobering chart, but it leaves me with a question:

What is "Dow Adjusted Closing Price" ? Adjusted for what?


I'd be interested to see the graph of "how many days since it was last this low? (or this high?)"

At any time the price will be either rising or falling, so the answer to one of those two questions is always zero, but they can alternate frequently. the "days since low" can be plotted below the baseline while the "days since high" could be plotted above the baseline. Every so often the number of days increases discontinuously, as a recent record is breached, so the history reaches suddenly much further back. .


Derek: in order to execute your idea, we would need to agree on the definition of "high" and "low". The problem is one needs a long view to establish a real low as opposed to a transient low. Take a look at the absolute low in the chart above; not many months later, another "low" was reached; it would seem odd to reset the count at that point.


Sorry, I wasn't clear: I didn't mean "days since last peak/trough", which would require a definition of peak or trough. I meant "days since the curve was last this high, or low," which is unambiguous: you simply draw a horizontal line backwards in time until it stops floating in air and hits a previous portion of the curve.

If the curve is exactly flat locally, the value is zero. If it's rising locally, the "next" (backwards in time) time a horizontal line hits the curve will be the "days since last this high" value. If it's falling locally, the "next" time a horizontal line hits the curve will be the "days since last this low" value.

It's definable without disagreement or need for definitions, and it is describable in a plain English sentence, "the last time the stock market was this low was ten years ago!" That doesn't mean there was a trough ten years ago; in fact the market was probably rising at the time.

A time series of such values will be characterised by slow increases in value, punctuated by discontinuous increases (as old peaks and troughs are surpassed) and sudden falls to zero (as the curve changes direction and "days since" starts again from zero.

The high or low distinction can be encoded by colour, or by which side of the axis it's plotted.

The comments to this entry are closed.

Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter