Capital IQ / BBG Daily Dashboard Set Up for 30-50 names (Financials)

To set up an effective Capital IQ or Bloomberg (BBG) daily dashboard for monitoring 30-50 financial sector names, here’s a structured approach based on the most helpful WSO content:

1. Core Dashboard Setup

• Key Metrics to Track:
  • Last Price
  • Net Change ($ and %)
  • Volume (actual)
  • Newswire (filtered by ticker)
• Additional Metrics:
  • Relative Performance (vs. sector ETFs or indices)
  • P/E, P/B, Dividend Yield (for valuation context)
  • Analyst Ratings/Target Price Changes
  • Short Interest (especially for shorts)
  • Credit Default Swap (CDS) spreads for banks/insurance (if available)

2. Incorporate Bonds/Credit Monitoring

• Adding bond yields, spreads, or CDS data can provide insight into credit risk and market sentiment, especially for banks and insurance companies. Focus on:
  • Corporate bond spreads for asset managers and insurers.
  • CDS spreads for banks (to gauge perceived credit risk).

3. Sub-Sector Based ETFs

• Use ETFs to track broader sub-sector movements and isolate idiosyncratic stock moves. Examples:
  • Asset Management: $XLF (Financial Select Sector SPDR), $KCE (Capital Markets ETF)
  • Insurance: $KIE (Insurance ETF)
  • Banks: $KBE (Banking ETF), $KRE (Regional Banking ETF)
  • Credit Payments: $IPAY (Mobile Payments ETF)

4. Global vs. US Names

• Global Chart: Use a broader chart with 200-300 global names to monitor macro trends and sector-wide movements.
• Focused Chart: Create a separate, more detailed chart for 20-30 US names you’re honing in on. This allows for deeper analysis without being overwhelmed by noise.

5. Fundamentals and Broader Market

• While tracking fundamentals and broader S&P movements can be helpful, avoid overloading your dashboard with unrelated sectors. Instead:
  • Focus on sector-specific drivers (e.g., interest rates, regulatory changes).
  • Use broader indices (e.g., S&P 500, Russell 2000) as benchmarks for relative performance.

6. Alternative Data

• Budget-friendly options:
  • Google Alerts: Set up alerts for specific tickers or sector keywords.
  • BamSEC: For SEC filings and company disclosures.
  • CapIQ: Use its built-in tools for tracking earnings transcripts, filings, and investor presentations.

7. Newswire Optimization

• Separate news sources into categories for better clarity:
  • SEC Filings: Use BamSEC or CapIQ to track filings like 10-Ks, 10-Qs, and 8-Ks.
  • Company IR/Press Announcements: Focus on earnings releases, guidance updates, and strategic announcements.
  • General News Coverage: Filter for major headlines or analyst commentary mentioning the ticker.

8. Additional Tips

• Screening Tools: Use CapIQ to build a screening tool for valuation metrics, profitability, and growth rates. Rank names weekly and focus on the top 20-30.
• Deep Dive: For your 3 longs/3 shorts, spend 2-3 hours per name to understand the story, valuation, and catalysts. Use sell-side research and investor presentations for context.
• Macro Monitoring: Track interest rates, inflation data, and central bank announcements, as these heavily influence financials.

This setup should give you a robust framework to monitor and analyze financial sector names effectively while staying focused on actionable insights.

Sources: What would you do with $300k, Citadel (Surveyor) Case Study/Modeling Test, Tricks of the Trade, Q&A: Equity Analyst at a Sovereign Wealth/Pension Fund, Q&A: Research Analyst at $1 Billion Hedge Fund