Skip to content
Edition NigeriaGlobal
Country: Canada

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

The Americas

Set up your profile

You are learning in the Canada edition, with examples in dollars and from Canada.

Writing a research note · Lesson 5 of 8

Research data management: reproducible models and an audit trail

A research conclusion is only as good as the model behind it, and spreadsheets break quietly. This lesson shows how analysts keep research reproducible: separate inputs, workings and outputs, a sources tab, an assumptions log, version control, checks that flag errors, and an audit trail that lets someone else rebuild every number.

Advanced9 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 lay out a research model so that inputs, workings and outputs are separate and easy to check.
  • You can keep a sources record and an assumptions log that let someone else rebuild every number.
  • You can version a model and explain what changed between two published notes.
  • You can build checks and a review step that catch common spreadsheet errors before publication.

Key terms in this lesson

Data provenance
Where a piece of data came from and how it has been handled since, so that its reliability can be judged.
Assumptions log
A record of each assumption in a model with its value, reason or source, date and author, so the model can be reviewed and updated.
Version control
Keeping each saved version of a file or model, with a note of what changed and why, so that any published version can be found and compared.
Audit trail
A record that lets someone trace a published figure back through every calculation to its source, and see when and why it changed.

Step 1 of 5

Step 1: Why research needs data management

Opening this step…

Step 2 of 5

Step 2: Lay the model out to be checked

This step opens when you finish the one above.

Step 3 of 5

Step 3: Sources and the assumptions log

This step opens when you finish the one above.

Step 4 of 5

Step 4: Versions and the audit trail

This step opens when you finish the one above.

Step 5 of 5

Step 5: Checks and review

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

Investment researchPresenting research: the executi…Read nowPresenting research: the executive summary, charts and clear writingInvestment research · Advanced · 15 minInvestment researchEthics and regulation of investm…Read nowEthics and regulation of investment researchInvestment research · Advanced · 15 minInvestment researchFrom analysis to a conclusion: t…Read nowFrom analysis to a conclusion: the research note caseInvestment research · Advanced · 15 minFinancial data & analyticsBuilding a simple valuation mode…Read nowBuilding a simple valuation model from dataFinancial data & analytics · Intermediate · 15 minFinancial data & analyticsFree against paid data, licensin…Read nowFree against paid data, licensing and terms of useFinancial data & analytics · Intermediate · 15 minAI & securityModel risk management and explai…Read nowModel risk management and explainabilityAI & security · Advanced · 15 minInvestment researchReading and critiquing a researc…Read nowReading and critiquing a research reportInvestment research · Intermediate · 15 minInvestment researchSell-side, buy-side and independ…Read nowSell-side, buy-side and independent researchInvestment research · Intermediate · 15 minFinancial data & analyticsChecking a financial modelRead nowChecking a financial modelFinancial data & analytics · Advanced · 15 minInvestment researchCountry fact sheets as a researc…Read nowCountry fact sheets as a research starting pointInvestment research · Intermediate · 15 minInvestment researchMacro and country researchRead nowMacro and country researchInvestment research · Intermediate · 15 minInvestment researchPrimary research and the rules o…Read nowPrimary research and the rules on inside informationInvestment research · Intermediate · 15 min
English