Skip to main content

Quant Analytics: from scratch to pro · Quant foundations: returns, risk and clean data · Intermediate

Clean data: timestamps, time zones, DST and survivorship

Most errors in market analysis come from the data, not the maths. This lesson covers storing time in UTC, daylight saving rules in the US and Europe, bar labels, survivorship and delisting bias, point-in-time data and corporate actions.

4 min read Reviewed Revision 1

In this lesson

  • Store and compare timestamps in UTC and convert them with a time-zone database
  • State the US and European daylight saving rules and find the weeks when the two differ
  • Explain how survivorship and delisting bias inflate historical results
  • Describe point-in-time data and adjust prices for splits

Read first: Returns: simple, log and compounded

Worked numbers

Each result is recomputed from the formula shown.

WhatFormulaResult
days between US and EU spring changes in 2026 (8 March to 29 March)29 - 821 days
days between EU and US autumn changes in 2026 (25 October to 1 November)(31 - 25) + 17 days
days a year when the offset differsspring_gap + autumn_gap28 days
share of the yeardiff_days / 3657.67%
average return including the delisted stock(9 * 10 - 60) / 103.0%
average return of survivors only(9 * 10) / 910.0%
overstatement in percentage pointswithout_loser - with_loser7.0 points
unadjusted return across the split51 / 100 - 1-49%
adjusted return across the split51 * 2 / 100 - 1+2%

Check yourself

What is the New York to London time difference normally, and when does it differ?

Normally 5 hours. It is 4 hours for about four weeks a year, when the US is on daylight time and Europe is not: from the second Sunday of March to the last Sunday of March, and from the last Sunday of October to the first Sunday of November. In 2026: 8 to 29 March and 25 October to 1 November, 21 + 7 = 28 days.

A feed stamps bars in New York local time. What goes wrong on the day the clocks go back?

The hour from 01:00 to 02:00 happens twice, so two different bars carry the same stamp. The day has 25 hours. On the spring day the hour from 02:00 to 03:00 never happens and the day has 23.

Ten stocks were held. Nine returned +10%. One was delisted after losing 60%. What is the average with and without the delisted one?

With it: (9 x 10% - 60%) / 10 = 3.0%. Without it: 10.0%. Dropping the loser overstates the result by 7.0 points.

A 2-for-1 split takes a price from 100 to 51 the next day, and the holding really gained 2%. What are the unadjusted and the correct returns?

Unadjusted: 51 / 100 - 1 = -49%. Adjusted: 51 x 2 / 100 - 1 = +2%. Unadjusted prices turn splits into false crashes.

What is point-in-time data?

Data as it was known on each date, including later-restated values, index membership and listings as they were then. Today's version of history uses facts that were not available.

Key terms

Daylight saving timeSurvivorship biasPoint-in-time data

Checked facts

Every figure below carries how it was checked: Primary checked (read in the cited primary, official, academic or data source), Two sources agree, or Approximate (an order of magnitude only).

Sources

Informational content. Not investment advice.