Annual Revenue

Annual Revenue Table Builder

Extract and display annual Total Revenue for $0 covering the past 10 fiscal years by browsing Yahoo Finance in Chrome.

Multi-Ticker Support

The argument $0 may contain multiple tickers separated by commas (e.g., AAPL,MSFT,GOOG).

1. Parse $0 by splitting on commas and trimming whitespace to get a list of tickers.
2. Always use the Task tool to launch one subagent per ticker in parallel (all Task calls in a single message). Each subagent should:

• Receive the full instructions from Step 1 onward, with $0 replaced by its single ticker
• Be of type general-purpose
• Work independently to extract data and build the tables

1. If there is only one ticker, present the subagent's Table 2 (YoY growth rates) directly; skip Table 1 (raw data).
2. If there are multiple tickers, combine all results into a single summary table with fiscal years as rows and paired columns per ticker (value + YoY):

| FY | TICKER1 | YoY | TICKER2 | YoY | |----|---------|-----|---------|-----| | 2025 | $X.XXB | +X.X% | $X.XXB | +X.X% | | 2024 | $X.XXB | -X.X% | $X.XXB | +X.X% | | ... | ... | ... | ... | ... | | 2016 | $X.XXB | – | $X.XXB | – |

Replace TICKER1, TICKER2, etc. with actual ticker symbols. Use – for the earliest year's YoY (no prior year data). Do not present separate tables per ticker.

Step 1: Navigate to Yahoo Finance Financials

1. List pages and select an existing Yahoo Finance page (or any available page).
2. Navigate to https://finance.yahoo.com/quote/$0/financials/
3. Wait for the page to load.

Step 2: Ensure Annual View is Selected

1. Take a snapshot of the page.
2. The default view should be "Annual". Verify by checking the snapshot. If the "Quarterly" tab is currently selected, save the snapshot to a file, use Grep to find the "Annual" tab element, and click it.

Step 3: Extract Column Headers and Total Revenue Data

Use evaluate_script to extract the table headers and Total Revenue row in one call:

() => {
  const rows = document.querySelectorAll('div.tableBody div.row');
  const result = {};

  // Get column headers
  const headerRow = document.querySelector('div.tableHeader div.row');
  const headers = [];
  if (headerRow) {
    headerRow.querySelectorAll('div.column').forEach(col => {
      headers.push(col.textContent.trim());
    });
  }

  // Find Total Revenue row
  rows.forEach(row => {
    const label = row.querySelector('div.column div.rowTitle');
    if (label && label.textContent.trim() === 'Total Revenue') {
      const columns = row.querySelectorAll('div.column');
      const values = [];
      columns.forEach(col => {
        values.push(col.textContent.trim());
      });
      result.label = 'Total Revenue';
      result.values = values;
    }
  });

  result.headers = headers;
  return result;
}

This returns:

• headers: Array starting with ["Breakdown", "TTM", "MM/DD/YYYY", ...] — fiscal year-end dates
• values: Array starting with ["Total Revenue", "", "", ...]

Step 4: Parse and Organize Data

1. Skip the first header ("Breakdown") and first value ("Total Revenue").
2. Skip the TTM column (second header / second value) if present.
3. Pair each remaining header (date string like "12/31/2024") with its corresponding revenue value.
4. Parse each date to extract the fiscal year-end date and the year.
5. Filter to the past 10 fiscal years only. If the current year is incomplete or shows "--", still include it and mark as "N/A".
6. Revenue values of "--" should be treated as missing/N/A.
7. Revenue values from Yahoo Finance are displayed in thousands (e.g., "6,345,000" means $6.345B). Parse by removing commas and converting to numbers. For display, format in millions (divide by 1,000) with one decimal place and an M suffix, or in billions (divide by 1,000,000) with two decimal places and a B suffix — choose whichever is more readable for the company's scale.

Step 5: Build Table 1 — Annual Total Revenue

Present a markdown table with this format:

| Fiscal Year End | Total Revenue | YoY Change |
|-----------------|---------------|------------|
| 12/31/2024      | $X.XXB        |            |
| 12/31/2023      | $X.XXB        |            |
| ...             | ...           |            |

• Show dollar signs on all values.
• Bold the year values.
• Order rows from most recent year at top to oldest at bottom.

Step 6: Build Table 2 — YoY Revenue Growth

Calculate YoY growth as: (Current Year Revenue - Prior Year Revenue) / Prior Year Revenue * 100

Present a markdown table:

| Fiscal Year End | Total Revenue | YoY Growth |
|-----------------|---------------|------------|
| 12/31/2024      | $X.XXB        | +X.X%      |
| 12/31/2023      | $X.XXB        | -X.X%      |
| ...             | ...           | ...        |

• Prefix positive values with +, negative values naturally show -.
• The earliest year in the table will have no prior year to compare, so show "N/A" for that growth cell.
• If either the current or prior year revenue is missing/zero, show "N/A" for that growth cell.

Step 7: Add Notes

Below the tables, include a Notes section mentioning:

• That all revenue values are as reported per Yahoo Finance (in thousands on the source, converted for display).
• The company's fiscal year-end date (e.g., "Fiscal year ends December 31" or "Fiscal year ends March 31").
• Any notable spikes or drops and likely causes if obvious (e.g., acquisitions, divestitures, pandemic impact).
• The data source: Yahoo Finance $0 Financials (Annual Income Statement, Total Revenue).

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: kezsmeister
• Source: kezsmeister/claude-finance-skills
• License: MIT

Install and usage instructions live in the source repository linked above.