If, like me, you follow the S2000 auctions on BringATrailer, you might appreciate the summary results chart they provide, but still wish for an easier way to slice and dice the results for analysis. Well, with a little extra "quarantine time" on my hands, I went ahead and started building a spreadsheet of the 200 or so results (now 220+ and counting). Here's a snapshot of the raw data I built:



Now, Excel's plotting tools are fine as far as they go, but they're not really conducive to "playing around with". Enter Tableau, a fairly powerful tool which accepts your raw data (spreadsheet, csv, database, etc) as input and allows you to build just such interactive visualizations. The public version is free to use, with two principal restrictions: your viz's can only be saved online, and the color-palette is restricted to somewhat less-than-bold (i.e. "less-contrasty") choices. However, once saved, anyone can access them and "play around" as much as they wish.

So far I've created two viz's: one with the auction results plotted vs date (as on BaT's site), and one vs vehicle mileage. Here's the "by mileage" viz:


Large circles are successful sales, small ones are "Reserve Not Met" (RNM). Note that the legends on the right all act as filters/highlights: this allows you, for example, to show only CRs, or only Sebring Silvers, or (with the mileage slider) only those cars with between 30K and 50K miles. One filter that might not be self-explanatory is "Repeat": this captures the 9 or 10 cases where the same car was auctioned twice on BaT; like "repeat home sales", these items are often considered the best indicator of how the market is moving. A "Repeat" value of 1 is the first time the car auctioned, and 2 is the second time. (There've been no three-peats yet!) In the Repeat filter, just un-select the "Null" value and you'll see only these examples.

Finally, one of the best things about Tableau: hovering your cursor over any data point produces a pop-up Tooltip of metadata about that auction, including the final price with auction fees, the car's VIN, and my own "Notes" field which captures unusual and/or significant points (e.g. a couple cars had LS swaps, one was a charity auction, etc.). This is invaluable once you've filtered on some criteria and, say, want to see more info on the outliers. Here's what the tooltip looks like on the "by Date" viz:


Pro tips:
- For easiest viewing, scroll down and select the "full screen" view (circled below).
- To switch between Mileage and Date views (or open them in different tabs), scroll down and click on the appropriate "metadata" title (circled below).
- If you filter on something and it gets "stuck" (won't let you un-filter), just refresh the browser page.
- While the viz's work on my Android phone, they're best viewed on PC/Mac.



Here are the links to the viz's:
S2000sonBaTbyDate
S2000sonBaTbyMileage


That's about all! Hope you enjoy it, and please let me know if you have any suggestions. I'll be updating the viz's as new auctions occur, and I also plan to add a few more "Notes" to some of the older auctions.

P.S. You'll see that the pop-up Tooltip for each point includes the link address of the auction page; unfortunately I don't know how to make it clickable. (There's an indirect way that works in Chrome for PC, but I haven't figured out a general way.)

 

well done! I see we're both fairly frequent posters on BaT regarding s2000's.
thanks for the information.
darcy

 

So cool!

Thanks for putting this together.

 

Very interesting - thanks for pulling this together. I purchased an AP1 a few weeks ago as a crutch until my mid engine corvette arrives end of this year - the data supports my thought that the values are at minimum stable and more realistically going up in value.

 

Wow. Talk about hardcore.

Thanks for doing this. This is a lot better than the black dot plot BAT provides.

 

I finally got a chance to do some digging around in the results you've compiled. This is awesome. Far more interesting that the things I'm used to looking at in Tableau, lol. Thank you for the effort to make this happen @twohoos !

 

I'd agree. There are actually so many near-mint low-miles examples on BaT that the data is very noisy; but here's what it looks like if you filter on cars with between 50K and 65K miles -- in other words, a "good clean used S2000":


Note that the '06 RYP outlier in Jan '17 benefitted from 2 determined bidders; the seller posted that reserve had been met when bidding reached about 18.5K.

 

I really appreciate the time and effort that you put into the S2000 community! THANKS

 

Great Job,appreciate the effort will sub..Pete

 

Great info! Thanks for putting the time into this!