« 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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Marketing analytics and data visualization expert. Author and Speaker. Currently at Columbia. See my full bio.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Good Books

Keep in Touch

follow me on Twitter