The Scenario
You are a VC analyst. The investment team just finished sourcing sprint and has 60 public company tickers in an Excel workbook, the Companies tab. The lead partner wants a competitive landscape report by Friday at 5 PM with full company profiles: CEO name, market cap, sector, exchange, and the latest EPS actual versus estimated for each.
You have the tickers in column A. Nothing else. Five days, sixty rows, six data points per row.
The bad version of this week:
- You open a financial data site, look up the first ticker, copy the CEO name into column B
- You find the sector on a different page, market cap on yet another
- By Wednesday afternoon you have eleven companies done
- You hand the remaining 49 rows to a junior analyst and ask them to finish by Thursday
- Friday morning they send you a workbook where "sector" is filled with whatever showed up first in a browser search.
The precise version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your ticker list and calls the API Ninjas company profile and earnings endpoints for each row, writing a complete dataset without you touching a browser.
Open the SheetXAI sidebar and type:
For each ticker in column A of the Companies tab, fetch the full company profile from API Ninjas — including CEO, sector, market cap, and exchange — and fill columns B through E. Then look up the latest earnings report data (EPS actual vs estimated, revenue actual vs estimated) for every ticker and add it in columns F through I.
SheetXAI calls the profile endpoint, then the earnings endpoint, and writes seven columns of structured data per row.
What You Get
A complete competitive landscape dataset in the Companies tab:
- Column B: CEO name
- Column C: Sector
- Column D: Market cap (USD)
- Column E: Exchange
- Column F: EPS actual
- Column G: EPS estimated
- Column H: Revenue actual
- Column I: Revenue estimated
Sixty rows, six fields each, one prompt. No browser tabs, no copy-paste, no junior analyst guessing at sector labels.
What If the Data Is Not Quite Ready
Competitive landscape workbooks have nuance. SheetXAI handles it inline.
When you want to rank by market cap and flag top performers
The lead partner wants the top 10 highlighted before the report goes out.
After filling all profile data in the Companies tab, sort by market cap in column D descending. Highlight the top 10 rows green. Add a "Rank" column at the start numbered 1 through 60.
When the EPS beat/miss picture matters more than raw numbers
You want a simple flag instead of four separate number columns.
For each ticker, compare EPS actual (column F) to EPS estimated (column G). Write "BEAT" in column J if actual exceeds estimated, "MISS" if it falls short, and "IN LINE" if within 2%. Do the same for revenue in column K.
When some tickers are international
Your sourcing sprint included London-listed and Tokyo-listed companies with different ticker formats.
For tickers in column A ending in ".L" or ".T," use the appropriate exchange format when calling API Ninjas. Fetch profile and earnings data as normal and note the exchange in column E.
When the full landscape build is one prompt
Sixty tickers, full profile, earnings data, beat/miss flags, sorted by market cap, ready for Friday.
For each ticker in column A of the Companies tab, fetch full company profile from API Ninjas (CEO, sector, market cap, exchange) and fill columns B–E. Fetch latest EPS actual, EPS estimated, revenue actual, and revenue estimated and fill columns F–I. Compare EPS actual vs estimated: write "BEAT," "MISS," or "IN LINE" into column J. Sort by market cap descending. Highlight the top 10 rows green. Write "Top 10" in column K for those rows.
The pattern: profile data, earnings data, derived flags, and sorting all in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open any ticker list workbook, then ask SheetXAI to enrich it with company profiles and earnings data using API Ninjas. The API Ninjas integration is included in every SheetXAI plan. See also how to bulk-enrich a ticker list with live price in Excel or the API Ninjas in Excel overview.