Quant Memo
Foundational

Evaluating a New Dataset: The Full Checklist

Before a dataset earns a signal-research slot, it has to survive a checklist that has nothing to do with whether it predicts returns — coverage, timeliness, survivorship, and cost all fail datasets long before the alpha question gets asked.

Prerequisites: Point-in-Time Data

A vendor pitches a dataset with a slide showing a back-tested Sharpe ratio of 2.1. That number is the last thing worth checking, not the first. Most datasets that fail, fail on structural grounds that have nothing to do with predictive power — grounds that, once discovered, make the vendor's Sharpe ratio irrelevant regardless of how it was computed. A researcher who checks those grounds first saves weeks spent building a signal on data that was never usable to begin with.

The checklist, in the order that kills the most candidates fastest

Timestamp integrity. Is the field stamped with the date it was actually knowable, or the date it describes? A dataset stamped to a fiscal quarter-end, when the actual data wasn't available until six weeks later, will produce a back-test riddled with look-ahead the moment you use it naively. This single check kills more candidate datasets than any other, and it should be verified against the vendor's own delivery logs, not assumed from documentation.

Coverage. What fraction of your actual tradeable universe does this dataset touch, and how does that fraction change over time? A dataset covering 90% of large caps but 20% of the small-cap names your strategy actually trades is not a 90%-useful dataset for you — it is closer to unusable for anything outside large caps, and the 20% that is covered may not be a random, unbiased 20%.

History and survivorship. How far back does the data go, and does it include companies that later delisted, went bankrupt, or were acquired? A dataset that only contains currently-listed companies is survivorship-biased by construction — any back-test built on it will look better than a live version of the same strategy ever could, because the losers have been silently removed from the sample.

Revision behaviour. Does the underlying data get restated after initial release (common for financial and economic data)? If so, a naive back-test using final, revised values instead of the values available in real time is another form of look-ahead, distinct from the timestamp issue but just as damaging.

Redundancy against what you already own. Does this dataset add information beyond what's already in the research library, or is it a repackaged version of a factor already covered? This is a cost-benefit question, but it belongs on the checklist before serious research time is spent, not after.

A dataset earns a research slot by surviving structural checks — timestamp integrity, coverage, survivorship, revisions — before anyone asks whether it predicts returns. A dataset that fails any of these produces a back-test that looks good and means nothing, regardless of the underlying signal's quality.

A worked scorecard

A vendor offers a supply-chain relationship dataset — which companies are customers/suppliers of which others, updated quarterly.

CheckFindingVerdict
Timestamp integrityRelationships stamped to quarter-end, but sourced from filings that lag by up to 10 weeksNeeds an as-available lag correction before use
Coverage78% of Russell 1000, 12% of Russell 2000Usable for large-cap strategies only
HistoryBack to 2015 onlyLimits back-test length; no pre-2015 crisis period to test against
SurvivorshipIncludes delisted/acquired companies as of each historical datePasses
Revision behaviourRelationships occasionally revised retroactively when filings are correctedMinor risk; use point-in-time snapshots, not the latest table
RedundancyDistinct from existing factor library — no close substituteAdds new information

This dataset is not disqualified, but the verdict is far more specific than "good" or "bad": usable for a large-cap strategy, with a mandatory timestamp correction, over a limited nine-year history, using point-in-time snapshots rather than the live table. That is the level of specificity a checklist produces and a Sharpe-ratio slide never will.

The most common failure mode is running the alpha test first because it's the exciting part, then only checking the structural items if the alpha test looks promising. This inverts the correct order and wastes the most research time on exactly the datasets least likely to survive scrutiny — a dataset with a fatal timestamp problem will often look like it has alpha, because the look-ahead itself is generating the apparent signal.

Related concepts

Practice in interviews

Further reading

  • Isichenko, Quantitative Portfolio Management (ch. 3, data)
  • Kakushadze & Serur, 151 Trading Strategies (ch. 2, data)
ShareTwitterLinkedIn