Skip to content
Edition NigeriaGlobal
Country: Mexico

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

The Americas

Set up your profile

You are learning in the Mexico edition, with examples in pesos and from Mexico.

Intermediate path · Free course

Financial data and spreadsheets

Where financial data comes from, what you may republish, cleaning it for corporate actions, survivorship and calendars, returns, volatility, drawdowns and correlation in a spreadsheet, pivot tables, and honest charts.

  • Intermediate level
  • 8 lessons
  • 1 hour of study
  • 1 final test
  • $5 certificate
  • Mexico edition

Recommended first: Maths for markets.

Education, not advice: this course explains how products and rules work. It does not recommend any product, trade or provider.

Start the free courseSign in with your free Stockertim account to enrol.

What you will learn

  • By the end you can name the five main families of financial data and what each is used for.
  • By the end you can explain the difference between being able to see data and being allowed to reuse it.
  • By the end you can spot a false price move caused by a split, bonus issue or consolidation.
  • By the end you can explain survivorship bias and how it inflates past returns.
  • By the end you can turn a column of prices into a column of period returns.
  • By the end you can build a running peak and a drawdown column in a spreadsheet.
  • By the end you can lay out financial records as tidy data ready for a pivot table.
  • By the end you can spot a truncated axis, a cherry-picked date range and a misleading dual-axis chart.

Skills you will practise

Syllabus

8 lessons · about 1 hour · a short test after every step, a quiz after every lesson and one final test.

  1. Financial data sourcesFinancial data comes in families: market prices, company fundamentals, macroeconomic statistics, regulatory filings and alternative data. Each has a … 11 min · 6 steps
    1. Why the source comes first
    2. Market data: prices, volumes and quotes
    3. Fundamentals and filings: what companies report
    4. Macroeconomic data: whole-economy statistics
    5. Alternative data: useful, patchy and hard to check
    6. Keeping a source log
    7. Lesson quiz
  2. Free against paid data, licensing and terms of useFree to view is not free to reuse. Market data, index values and many datasets come with licences that limit copying, publishing and commercial use. … 9 min · 5 steps
    1. Free to see is not free to reuse
    2. The layers of a market data licence
    3. Reading a terms-of-use page
    4. Open data and attribution
    5. Publishing a chart or table safely
    6. Lesson quiz
  3. Cleaning data for splits, dividends and ticker changesRaw prices jump on the day of a split, a bonus issue or a large dividend, even though no investor gained or lost. Adjusting history with a factor rem… 9 min · 5 steps
    1. The crash that never happened
    2. Splits, consolidations and bonus issues
    3. Adjusting a series in a spreadsheet
    4. Dividends and total return
    5. Ticker changes, mergers and keeping history together
    6. Lesson quiz
  4. Survivorship, missing data, time zones, calendars and currenciesA dataset can be clean line by line and still mislead. Companies that disappeared, gaps for holidays, prices taken at different times in different ti… 9 min · 5 steps
    1. The problem of what is not there
    2. Survivorship bias
    3. Missing values: blank is not zero
    4. Trading calendars and time zones
    5. Converting currencies consistently
    6. Lesson quiz
  5. Returns, CAGR and volatility in a spreadsheetWith a column of prices you can calculate daily or monthly returns, the compound growth rate and volatility in a few formulas. Building them yourself… 9 min · 5 steps
    1. Setting up the sheet
    2. From prices to period returns
    3. Total return and CAGR
    4. Volatility with STDEV.S
    5. Return against risk, and checking your work
    6. Lesson quiz
  6. Drawdowns and correlation in a spreadsheetA drawdown measures how far a value has fallen from its last peak, and correlation measures how closely two sets of returns move together. Both take … 9 min · 5 steps
    1. What volatility does not tell you
    2. The running peak and the drawdown column
    3. Maximum drawdown and recovery time
    4. Correlation with CORREL
    5. Why correlations change
    6. Lesson quiz
  7. Pivot tables for financial dataA pivot table turns a long list of rows, such as trades, dividends or daily returns, into a summary by category and period in a few clicks. It works … 8 min · 5 steps
    1. From 240 rows to five lines
    2. Tidy data comes first
    3. Building the first pivot: dividends by year and sector
    4. Summarising a portfolio by asset class
    5. Averages, totals and other traps
    6. Lesson quiz
  8. Charts done right, and spotting misleading chartsA chart can be accurate in every number and still mislead through a cut axis, a chosen start date, two different axes or a missing adjustment. Knowin… 10 min · 5 steps
    1. True numbers, misleading pictures
    2. Axes: where to start and what scale to use
    3. Dates: the most powerful trick
    4. Two axes and invented links
    5. Labels, adjustments and a checklist
    6. Lesson quiz

Final test

A fresh set of questions drawn from every lesson of this course, timed, with the options in a new order every time. You need 85% to pass, and passing earns your certificate.

Enrol to unlock the final test.

English