Skip to content
Edition NigeriaGlobal
Country

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

Set up your profile

Financial data and spreadsheets · Lesson 1 of 8

Financial data sources

Financial data comes in families: market prices, company fundamentals, macroeconomic statistics, regulatory filings and alternative data. Each has a primary source, a typical delay and typical errors, and good analysis starts by knowing which is which.

Intermediate11 min read6 steps

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

What you will learn

  • By the end you can name the five main families of financial data and what each is used for.
  • You can say where each family comes from first, and how it reaches the websites and files you use.
  • You can explain why the same figure can differ between two sources.
  • You can keep a simple source log so every number in your work can be traced.

Key terms in this lesson

Market data
Prices, volumes, quotes and trades produced by exchanges and trading venues.
Fundamental data
Figures taken from company reports, such as revenue, profit, assets and cash flow.
Macroeconomic data
Statistics about a whole economy, such as inflation, growth, unemployment and trade, published by statistics offices and central banks.
Alternative data
Data beyond prices, filings and official statistics, such as web traffic, spending summaries or satellite images.
Bid
The highest price a buyer is currently willing to pay for a security.
Ask
The lowest price a seller is currently willing to accept. Also called the offer.
Volume
The number of shares traded in a given period.
OHLC
Open, high, low, close: the four prices that describe trading in a period.
Primary source
The original record of a fact or figure, such as a company filing or annual report, an exchange announcement, official statistics, a court record or the person who said it, rather than a summary of…
Delayed data
Prices shown some minutes after they happen, often the free version of a live feed.

Step 1 of 6

Why the source comes first

Opening this step…

Step 2 of 6

Market data: prices, volumes and quotes

This step opens when you finish the one above.

Step 3 of 6

Fundamentals and filings: what companies report

This step opens when you finish the one above.

Step 4 of 6

Macroeconomic data: whole-economy statistics

This step opens when you finish the one above.

Step 5 of 6

Alternative data: useful, patchy and hard to check

This step opens when you finish the one above.

Step 6 of 6

Keeping a source log

This step opens when you finish the one above.

Key takeaways

The key takeaways open when you finish every step.

Lesson quiz

6 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 & analyticsFree against paid data, licensin…Read nowFree against paid data, licensing and terms of useFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsCleaning data for splits, divide…Read nowCleaning data for splits, dividends and ticker changesFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsSurvivorship, missing data, time…Read nowSurvivorship, missing data, time zones, calendars and currenciesFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsReturns, CAGR and volatility in …Read nowReturns, CAGR and volatility in a spreadsheetFinancial data & analytics · Intermediate · 15 minMacro & global marketsReading economic data releases l…Read nowReading economic data releases like an investorMacro & global markets · Intermediate · 15 minInvesting strategiesresearch a company before invest…Read nowHow to research a company before investingInvesting strategies · Beginner · 15 minFinancial data & analyticsLab 4: SQL on a price tableRead nowLab 4: SQL on a price tableFinancial 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 & analyticsLab 3: plotting prices and returnsRead nowLab 3: plotting prices and returnsFinancial data & analytics · Advanced · 15 minFinancial data & analyticsMoving averages and seasonality …Read nowMoving averages and seasonality in financial dataFinancial data & analytics · Advanced · 15 minFinancial data & analyticsScenarios and sensitivities in a…Read nowScenarios and sensitivities in a modelFinancial data & analytics · Advanced · 15 min
English