What Is Capital IQ Used For?

What’s happening here?

Think of it as a giant financial data warehouse. The platform pulls together numbers from over 62,000 public companies and 4.4 million private firms, then organizes everything into neat, comparable formats. (No more wrestling with messy spreadsheets—this thing does the heavy lifting.) Real-time data feeds keep the numbers fresh, while built-in Excel integration means you can build models without jumping between programs. According to S&P Global Market Intelligence, it’s the go-to tool for investment banks, asset managers, and corporate finance teams tackling due diligence or big-picture strategy.

How do you actually use it?

1. Log in and grab the plug-in Head to MyCapitalIQ → Downloads to snag the plug-in. Pick the right version for your Excel setup (64-bit or 32-bit) and install it. Pro tip: Make sure your Excel version plays nice—Excel 2019 (build 16.0.10001+) is the sweet spot as of 2026.
2. Install and log in Fire up Excel after installing. You’ll see a new Capital IQ tab in the ribbon. Click Settings and punch in the same login you use for the web portal. No extra passwords to remember.
3. Load the WACC template Under the Capital IQ tab, drill down to Templates → Valuation → WACC. The template fires up with all the formulas pre-loaded and cells ready for company tickers.
4. Plug in the ticker and let it rip Type in your company’s ticker (say, AAPL for Apple) and hit Ctrl + Alt + C to pull fresh data. The WACC calculation updates automatically with the latest numbers—no manual number-crunching required.

Why isn’t this working?

• You’re offline or can’t connect Live data needs a live connection. If you’re behind a corporate firewall or proxy, poke around Capital IQ Settings → Proxy to fix the connection hiccup.
• Your plug-in is out of date Uninstall the old version and grab the latest from MyCapitalIQ → Downloads. Old plug-ins and outdated Excel builds are the usual suspects here.
• Your account doesn’t have the right access You’ll need at least “Analyst” level permissions to run the WACC template. If you’re locked out, ping your subscription admin to bump up your access.

How can you avoid problems in the first place?

• Update the plug-in every few months via MyCapitalIQ → About → Check for Updates. It keeps Excel and Capital IQ playing nicely together.
• Save your WACC template to OneDrive with version history turned on (File → Info → Version History). If you accidentally nuke the file or it gets corrupted, you can roll back to a clean version.
• Double-check your WACC inputs against the latest earnings call transcripts and management guidance. According to SEC filings, companies sometimes tweak their capital structure or debt rules—details that can throw off your model.