Skip to content
Edition NigeriaGlobal
Country: United Arab Emirates

You are in the United Arab Emirates edition. Type your country to switch.

Set up your profile

You are learning in the United Arab Emirates edition, with examples in dirhams and from the United Arab Emirates.

Financial data and spreadsheets · Lesson 4 of 8

Survivorship, missing data, time zones, calendars and currencies

A dataset can be clean line by line and still mislead. Companies that disappeared, gaps for holidays, prices taken at different times in different time zones and mixed currencies all distort results unless you handle them deliberately.

Intermediate9 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 survivorship bias and how it inflates past returns.
  • You can choose and record a method for handling missing values.
  • You can align prices from markets with different holidays and time zones.
  • You can convert a series into one currency without adding false moves.

Key terms in this lesson

Survivorship bias
Distorted results from studying only the survivors, such as companies still listed, and ignoring those that failed.
Look-ahead bias
Using information in a test that would not have been known at the time.
Missing value
A blank in a dataset where a figure should be. It is not the same as zero.
Forward fill
Filling a missing value with the last known value before it.
Illiquid
Describes an asset that is hard to sell quickly at a fair price.
Trading calendar
The list of days and hours on which a market is open, including its holidays.
Correlation
A measure from -1 to +1 of how closely two investments move together.
Exchange rate
The price of one currency in terms of another, such as how many euros or yen one US dollar buys.
Currency risk
The chance that exchange-rate moves reduce the value of an investment in your home currency.

Step 1 of 5

The problem of what is not there

Opening this step…

Step 2 of 5

Survivorship bias

This step opens when you finish the one above.

Step 3 of 5

Missing values: blank is not zero

This step opens when you finish the one above.

Step 4 of 5

Trading calendars and time zones

This step opens when you finish the one above.

Step 5 of 5

Converting currencies consistently

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

Financial data & analyticsReturns, CAGR and volatility in …Read nowReturns, CAGR and volatility in a spreadsheetFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsDrawdowns and correlation in a s…Read nowDrawdowns and correlation in a spreadsheetFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsPivot tables for financial dataRead nowPivot tables for financial dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsCharts done right, and spotting …Read nowCharts done right, and spotting misleading chartsFinancial 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 minRisk & psychologycurrency riskRead nowWhat is currency risk?Risk & psychology · Intermediate · 15 minFinancial data & analyticsCommon financial modelling errorsRead nowCommon financial modelling errorsFinancial data & analytics · Advanced · 15 minFinancial data & analyticsMoving averages and seasonality …Read nowMoving averages and seasonality in financial dataFinancial data & analytics · Advanced · 15 minFinancial data & analyticsLab 1: reading CSV files in Pyth…Read nowLab 1: reading CSV files in Python and SQLFinancial data & analytics · Advanced · 15 minFinancial data & analyticsDashboards and performance repor…Read nowDashboards and performance reports that communicateFinancial data & analytics · Advanced · 15 minFinancial data & analyticsScenarios and sensitivities in a…Read nowScenarios and sensitivities in a modelFinancial data & analytics · Advanced · 15 min
English