Country: United Arab Emirates
You are in the United Arab Emirates edition. Type your country to switch.
Nigeria
Middle East
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the United Arab Emirates edition, with examples in dirhams and from the United Arab Emirates.
Your learning profile
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.
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: The problem of what is not there, not started
- Step 2: Survivorship bias, not started
- Step 3: Missing values: blank is not zero, not started
- Step 4: Trading calendars and time zones, not started
- Step 5: Converting currencies consistently, not started
About 9 min of reading
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.
Popular this week: Basics: BeginnerUAE markets: Beginner