Skip to content
Edition NigeriaGlobal
Country

You are in the Nigeria edition. Type your country to switch.

Set up your profile

Algorithmic trading · Lesson 3 of 8

Data hygiene for backtests: point-in-time data, survivorship, look-ahead and corporate actions

A backtest is only as honest as its data. Prices that were adjusted later, companies that vanished from the list, figures that were published weeks after the date they describe: each one quietly flatters a strategy. This lesson shows how each bias creeps in and how to keep it out.

Advanced11 min read5 steps

This lesson is complete in writing. A video for it is on its way.

What you will learn

  • By the end you can explain point-in-time data and why revised figures flatter a backtest.
  • You can spot look-ahead bias in a rule, including the trap of trading at a price used to make the signal.
  • You can explain survivorship bias and why delisted companies must stay in the test.
  • You can check that splits, dividends, ticker changes and other corporate actions are handled consistently.

Key terms in this lesson

Backtest
A test of how a strategy would have performed on past data.
Point-in-time data
Data that records each figure with the date it became public and keeps the original value even after restatements, so historical tests use only what was known at the time.
Look-ahead bias
Using information in a test that would not have been known at the time.
Survivorship bias
Distorted results from studying only the survivors, such as companies still listed, and ignoring those that failed.
Corporate action
An event decided by a company that affects its shares, such as a dividend, bonus, rights issue or split.

Step 1 of 5

A backtest is only as honest as its data

Opening this step…

Step 2 of 5

Point-in-time data and look-ahead bias

This step opens when you finish the one above.

Step 3 of 5

Survivorship: testing only the winners

This step opens when you finish the one above.

Step 4 of 5

Corporate actions

This step opens when you finish the one above.

Step 5 of 5

A data checklist before any test

This step opens when you finish the one above.

Key takeaways

The key takeaways open when you finish every step.

Lesson quiz

5 questions. You need 85% to pass.

The quiz opens when you finish every step.

Read first

Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.

Up next

Trading: risk, costs and processBacktesting properly: out-of-sam…Read nowBacktesting properly: out-of-sample tests, walk-forward, multiple testing and overfittingTrading: risk, costs and process · Advanced · 15 minTrading: risk, costs and processCosts and capacity: slippage, ma…Read nowCosts and capacity: slippage, market impact and why paper results shrinkTrading: risk, costs and process · Advanced · 15 minTrading: risk, costs and processExecution and microstructure for…Read nowExecution and microstructure for algorithms: the order book, queues and latencyTrading: risk, costs and process · Advanced · 15 minTrading: risk, costs and processRisk controls for algorithms: ki…Read nowRisk controls for algorithms: kill switches and limits, Knight Capital (2012) and the Flash Crash (2010)Trading: risk, costs and process · Advanced · 15 minFinancial data & analyticsSurvivorship, missing data, time…Read nowSurvivorship, missing data, time zones, calendars and currenciesFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsCleaning data for splits, divide…Read nowCleaning data for splits, dividends and ticker changesFinancial data & analytics · Intermediate · 15 minAdvanced strategies & derivativesBacktesting pitfalls: why past r…Read nowBacktesting pitfalls: why past results misleadAdvanced strategies & derivatives · Advanced · 15 minTrading: risk, costs and processorder books workRead nowHow order books workTrading: risk, costs and process · Advanced · 15 minTrading: risk, costs and processWhat the evidence says about ret…Read nowWhat the evidence says about retail tradersTrading: risk, costs and process · Intermediate · 15 minTrading: risk, costs and processFrom idea to rules: a hypothesis…Read nowFrom idea to rules: a hypothesis, data and a test that could prove you wrongTrading: risk, costs and process · Advanced · 15 minTrading: risk, costs and processLiquidation: how positions are c…Read nowLiquidation: how positions are closed for youTrading: risk, costs and process · Advanced · 15 minTrading: risk, costs and processReviewing a trading journalRead nowReviewing a trading journalTrading: risk, costs and process · Advanced · 15 min
English