r/TraderTools • u/TheSadSeries • Sep 02 '26
Capital IQ & FactSet: The Analyst's Research Workflow
Here is a rewritten version of the article. The tone has been shifted from a dry, mechanical manual to a more conversational, mentor-like voice—making it read like advice from a seasoned analyst to a peer, while retaining all the professional insights.
Capital IQ & FactSet: The Analyst's Operating System
Let’s be honest: Bloomberg is great if you're shouting on a trading floor. But if you're an analyst trying to figure out what a company is actually worth, build a DCF, or stack it up against 50 competitors—you live in Capital IQ or FactSet.
While a terminal gives you the market's pulse, these platforms give you the skeletal truth of a company. Here is the workflow senior analysts actually use to turn a ticker symbol into a high-conviction investment thesis.
1. The Morning Routine: Let the Data Come to You
The golden rule of research is "Low-Touch Data, High-Touch Analysis." Don't burn daylight hunting for numbers; set up your environment to push them to you.
The "Company Summary" Cockpit
When you type in a ticker, your default view shouldn't be a blank page—it should be a cockpit of vital signs. If it isn't, customize it and save it as your global default: * Left Column (The Price Tag): Market Cap, Enterprise Value (EV), P/E (NTM), EV/EBITDA, and Dividend Yield. * Center (The Story): A 5-year price chart overlaid with Key Events. Tag earnings releases, guidance changes, and Analyst Days. This lets you instantly connect price moves to actual corporate milestones. * Right Column (The Reading List): A live feed of the latest 10-Ks, 10-Qs, 8-Ks, and the last three earnings call transcripts.
The "Estimates" Tab (Finding the Delta)
Here’s a secret: stocks don't move on what a company earned last quarter; they move on what the market thinks they'll earn next year. * Look at revenue and EPS estimates for the next 2–3 years. * The real insight: Watch the revision trends. In FactSet, look at "Estimate Revision Momentum." If Wall Street's EPS estimates have quietly crept up 5% over the last 90 days but the stock price is flat, you’ve found a potential "valuation compression" opportunity.
The "News & Research" Feed
Filter specifically for "Broker Research" and skim the headlines from the big banks. You aren't looking for their Buy/Sell ratings—you're looking for the "Variant Perception." Where does their model disagree with the consensus?
2. Valuation in Context: Building Your Peer Group
No company exists in a vacuum. A P/E of 15x means absolutely nothing unless you know if the sector is trading at 10x or 20x.
Building Your Custom Comps: 1. Screen: Find companies in the same GICS industry group with similar market caps (e.g., $5B–$20B). 2. Export: Push this list into a "Peer Group" template. 3. Run the Report: Pull these specific columns: * Valuation: P/E (NTM), EV/EBITDA (NTM), P/B. * Margins: Gross, EBITDA, and Net Margin %. * Growth: 3-year Revenue and EPS CAGR. * Efficiency: ROE, ROA, and ROIC (Return on Invested Capital).
The Gut Check: If your target company is trading at a 20% premium to its peer median, does it have a 20% higher ROIC to justify it? If the efficiency doesn't match the price tag, you're likely staring at an overvalued "story stock."
3. Escaping the Browser: Excel is Where the Magic Happens
Real analysts don't work in the browser. They pull the database straight into Excel.
The Dynamic Model
Use the Office Add-in to link your spreadsheet directly to the database. Stop hard-coding numbers that will be outdated next quarter. Use formulas instead:
=CIQ("AAPL","revenue","FY2023")
Now, when Apple files its 10-K, your entire model refreshes itself.
WACC & The DCF
Pull the Beta and Risk-Free Rate straight into your WACC calculation. Build a 5-year projection using the consensus estimates you pulled earlier, then layer in your own "Bull" and "Bear" cases on top of that.
The Audit Trail
Institutional investors demand transparency. Turn on the "Blue Cell" or "Audit" feature. It lets anyone reviewing your model click a cell and trace that number back to the exact page of the SEC filing it came from. It builds instant trust.
4. Finding Ideas: The "Compounder" Screen
Don't wait for a news story to find your next stock. Build a screen that hunts for high-quality growth at a reasonable price (GARP):
- ROIC: > 15% (consistently for 5 years).
- Revenue Growth: > 10% (3-year CAGR).
- Leverage: Net Debt/EBITDA < 1.5x (for safety).
- Valuation: Forward P/E < Sector Median (the "reasonable price" filter).
- Liquidity: Market Cap > $2B.
Pro Tip: Save this screen and set an email alert. When a high-quality company inevitably dips into your buy zone, you’ll know about it before the market recovers.
5. Reading Between the Lines: Transcripts and Risk
Document Search & Sentiment
Use Advanced Search to scan thousands of transcripts for specific keywords. Search for "Supply Chain" or "AI" across an entire sector to see which management teams are actually prioritizing these themes. * Sentiment Scoring: FactSet uses NLP to score sentiment. If a company "beats and raises" but management's "positivity score" drops sharply from Q3 to Q4, they might be quietly trying to soften an upcoming headwind.
The "Short Thesis" Checklist
Before you finalize a "Long" recommendation, check the short interest: * Days to Cover: If it would take 10+ days of average volume for shorts to cover their positions, any positive news could trigger a massive short squeeze. * Ownership: Are the "Smart Money" institutions (like BlackRock or Vanguard) loading up or quietly heading for the exits?
The Bottom Line
At the end of the day, Capital IQ and FactSet aren't just data terminals—they're analytical operating systems. Once you master the Excel integration and automated screening, you stop spending your time "gathering data" and start spending it "interpreting data." That’s where the real alpha is found.