Where to Find Data for Models: Terminals, Databases, Screeners & Filings

Where to Find Data for Models: Terminals, Databases, Screeners & Filings

At 8:58 a.m., an analyst is two minutes away from sending a valuation model - and the revenue number from the screener does not match the annual report. One number is convenient; the other is official. In real finance and consulting work, knowing where data comes from is often the difference between a sharp model and a dangerous one.

  • Filings are the truth layer: use annual reports, exchange announcements, RHP/DRHP, shareholding filings and regulator disclosures for final numbers.
  • Terminals are speed plus breadth: Bloomberg, LSEG Workspace, FactSet and S&P Capital IQ are excellent for market data, estimates, ownership and comps - but still verify critical line items.
  • Databases are structured history: CMIE Prowess, Capitaline, Ace Equity, RBI, MOSPI, World Bank and Tracxn help when you need clean time series or sector-level data.
  • Screeners are discovery tools, not final evidence: use Screener.in, Tickertape, TradingView or Yahoo Finance to shortlist companies, spot ratios and form hypotheses.
  • Triangulate before modelling: one official source, one aggregator and one sanity check usually beat blind dependence on any single platform.
  • Cite every important input: source name, date, page/link and formula. A model without citations is not interview-grade.
  • The best answer is source-fit: choose the data source based on the question - audited financials, live price, peer multiples, market size or private-company funding.

The big picture is simple: data sources sit in a trust-speed trade-off. Filings are slower but authoritative; screeners are fast but derivative. Strong analysts do not ask, β€œWhich website has the number?” They ask, β€œWhat level of proof does this decision need?”

Data source trust pyramid A layered pyramid showing which data sources are fastest and which are most authoritative. News & Web Fast signals Screeners Shortlist and compare Terminals & Databases Structured, broad, quick Official Filings Audited or regulator-backed proof Fastest Most defensible
Move down the pyramid when the number will directly drive valuation, recommendation or credit judgment.

Core Explanation: The Four Places Analysts Actually Find Data

Data sourcing is not about memorising websites. It is a decision rule: match the source to the job. The same company can require four different sources in the same model - filings for revenue, terminals for beta, databases for industry growth and screeners for peer discovery.

Definitions You Can Say in One Breath

  • Filing: An official company disclosure submitted to a regulator, stock exchange or statutory repository.
  • Terminal: A professional platform combining real-time market data, company data, analytics, news and workflow tools.
  • Database: A structured collection of records designed for search, comparison, download and repeat analysis.
  • Screener: A tool that filters companies or securities using financial, valuation, technical or ownership criteria.
  • Triangulation: Checking a data point across independent sources before treating it as model-ready.

The Source Selection Ladder

When time is short, follow this ladder. Start from the business question, not from the website you like. A comps task, DCF task, credit note and market-sizing task all need different evidence.

Five-step data sourcing workflow A process flow showing how to convert a data requirement into a verified model input. Define What number? Choose Right source Extract Clean value Reconcile Check variance Cite in the model Source, date, page, formula Model-ready input Traceable and defensible Shortcut rule: extract fast, but verify anything that changes the conclusion.
The workflow turns raw data into an input you can defend under questioning.

When to Use Which Source

Here is the practical mapping interviewers expect. Notice the pattern: official source for facts, professional platform for speed, database for history, screener for discovery.

The Trust-Speed Matrix

This is the mental shortcut professionals use. If you need a number in 30 seconds, a screener may be fine. If the number drives a buy/sell recommendation, move to filings or a terminal-backed official dataset.

Trust-speed matrix for data sources A two by two matrix comparing speed and auditability of filings, terminals, databases and screeners. Speed Auditability Filings Highest proof Terminals Fast and broad Raw Web Use carefully Screeners Great first pass Slow Fast High Low
Speed is useful, but auditability decides whether a number belongs in the final model.

How to Judge Whether a Data Source Is Good

Do not say β€œBloomberg is reliable” or β€œScreener is easy.” Say how you would test the source. These six checks make your answer sound like an analyst, not a browser user.

A Simple Data-Sourcing Playbook for Common Placement Tasks

Case Study: Trent and the Zudio Growth Story

Trent, the Tata Group retail company behind Westside and Zudio, shows why analysts must combine filings, investor disclosures, databases and screeners instead of relying on a single headline growth story.

A retail growth story becomes investable only when store expansion, margins and cash flows are traced to defensible data
A retail growth story becomes investable only when store expansion, margins and cash flows are traced to defensible data.

Situation: Trent became a frequent discussion point among Indian equity analysts because Zudio expanded rapidly in value fashion while Westside remained the more established lifestyle format. The story sounded attractive, but a serious model could not stop at β€œZudio is growing fast.” The analyst had to verify revenue growth, store expansion, margins, capital intensity and peer positioning.

The move: A disciplined analyst would build the dataset in layers. The annual report and stock exchange filings provide the official financial statements and management discussion. Investor presentations help understand store count, format strategy and segment commentary where disclosed. A terminal or database helps compare valuation and historical ratios against retailers such as Avenue Supermarts, V-Mart Retail or Aditya Birla Fashion and Retail. A screener helps identify initial peers, but the peer set must be checked manually because grocery retail, value fashion and premium fashion have different economics.

Outcome and lesson: The primary driver of a strong Trent analysis is not just β€œretail growth”; it is the disciplined separation of official reported performance from market narrative. Supporting drivers include correct peer selection, format-level understanding, store expansion context, margin interpretation and valuation consistency. The case proves the core rule: use screeners to discover the story, but use filings and structured data to defend the model.

How AI Changes Where to Find Data

AI does not remove the need for source judgment. It makes source judgment more important because answers can look polished even when the underlying citation is weak.

  1. Filing extraction becomes faster: LLMs can summarise annual reports, extract risk factors, compare management commentary across years and find relevant notes faster than manual PDF search. The analyst must still verify the extracted number against the original page.
  2. Search shifts from keywords to cited answers: Tools like Perplexity can surface filings, exchange announcements and credible articles with citations. This is useful for discovery, but the final input should still come from the primary source.
  3. Data cleaning becomes semi-automated: AI can map messy line items, standardise company names and flag outliers in a peer set. The risk is false matching - for example, confusing consolidated and standalone numbers or different fiscal year-ends.

Load the company annual report, latest quarterly filing and investor presentation into NotebookLM. Ask: β€œList the financial and operating data points needed for a DCF, cite the page for each, and flag anything that must be cross-checked against NSE/BSE filings.” Then verify every critical number manually before using it.

Interview Relevance

β€œSuppose you have 45 minutes to build a quick valuation view for an Indian listed company. Where will you get the data, and how will you make sure it is reliable?”

In interviews, say one sentence that signals maturity: β€œFor discovery I am comfortable using screeners, but any line item that drives valuation must be tied back to a filing or a clearly defined terminal/database field.”

Common Mistake

The biggest mistake is treating a convenient screener number as final evidence. It costs candidates because interviewers immediately worry about stale data, formula mismatch and weak modelling discipline. Fix: use screeners to find the number, then reconcile valuation-critical inputs to filings or a professional database before citing them.

What to Revise Next

Now that you know where reliable data comes from, revise Case Study: A Timed Modelling Test Like the Ones Firms Set. That is where source judgment turns into execution - downloading the right inputs, making clean assumptions and building a defensible model under time pressure.

Mark Lesson Complete (Where to Find Data for Models: Terminals, Databases, Screeners & Filings)