Company Financial Comparison

import sys
import requests

API_KEY = "your_api_key_here"
BASE_URL = "https://api.stockdata.dev/v1"
HEADERS = {"X-API-Key": API_KEY}


def format_billions(n):
    """Format a number as billions with one decimal place."""
    if n is None:
        return "N/A"
    return f"${n / 1e9:.1f}B"


def format_pct(n):
    """Format a number as a percentage with one decimal place."""
    if n is None:
        return "N/A"
    return f"{n * 100:.1f}%"


def fetch_financials(ticker):
    """Fetch the latest financials for a ticker."""
    resp = requests.get(
        f"{BASE_URL}/company/{ticker}/financials",
        headers=HEADERS,
    )
    if resp.status_code != 200:
        print(f"Error fetching {ticker}: {resp.json().get('error', resp.text)}")
        return None
    return resp.json()


def fetch_company(ticker):
    """Fetch company profile for the name."""
    resp = requests.get(
        f"{BASE_URL}/company/{ticker}",
        headers=HEADERS,
    )
    if resp.status_code != 200:
        return {"name": ticker}
    return resp.json()


def safe_get(data, key):
    """Safely get a numeric value from financials."""
    val = data.get(key)
    if val is None or val == 0:
        return None
    return val


def calculate_ratios(fin):
    """Calculate derived financial ratios from raw data."""
    revenue = safe_get(fin, "revenue")
    net_income = safe_get(fin, "net_income")
    operating_income = safe_get(fin, "operating_income")
    total_assets = safe_get(fin, "total_assets")
    total_debt = safe_get(fin, "total_debt")
    stockholders_equity = safe_get(fin, "stockholders_equity")
    operating_cash_flow = safe_get(fin, "operating_cash_flow")
    capex = safe_get(fin, "capital_expenditures")

    # Calculate ratios
    profit_margin = net_income / revenue if revenue and net_income else None
    operating_margin = operating_income / revenue if revenue and operating_income else None
    de_ratio = total_debt / stockholders_equity if stockholders_equity and total_debt else None
    roa = net_income / total_assets if total_assets and net_income else None

    # Free cash flow = operating cash flow - capital expenditures
    if operating_cash_flow and capex:
        free_cash_flow = operating_cash_flow - abs(capex)
    else:
        free_cash_flow = None

    return {
        "revenue": revenue,
        "net_income": net_income,
        "profit_margin": profit_margin,
        "operating_margin": operating_margin,
        "total_assets": total_assets,
        "total_debt": total_debt,
        "de_ratio": de_ratio,
        "free_cash_flow": free_cash_flow,
        "roa": roa,
    }


def print_comparison(tickers, all_ratios, fiscal_year):
    """Print a formatted side-by-side comparison table."""
    col_width = 14
    label_width = 22
    total_width = label_width + col_width * len(tickers) + 1

    print(f"\nFinancial Comparison (FY {fiscal_year})")
    print("=" * total_width)

    # Header row
    header = " " * label_width
    for t in tickers:
        header += f"{t:>{col_width}}"
    print(header)
    print("-" * total_width)

    # Rows: (label, key, formatter)
    rows = [
        ("Revenue", "revenue", format_billions),
        ("Net Income", "net_income", format_billions),
        ("Profit Margin", "profit_margin", format_pct),
        ("Operating Margin", "operating_margin", format_pct),
        ("Total Assets", "total_assets", format_billions),
        ("Total Debt", "total_debt", format_billions),
        ("D/E Ratio", "de_ratio", lambda x: f"{x:.2f}" if x else "N/A"),
        ("Free Cash Flow", "free_cash_flow", format_billions),
        ("ROA", "roa", format_pct),
    ]

    for label, key, fmt in rows:
        row = f"{label:<{label_width}}"
        for t in tickers:
            val = all_ratios[t].get(key)
            row += f"{fmt(val):>{col_width}}"
        print(row)

    print("-" * total_width)


if __name__ == "__main__":
    if len(sys.argv) < 3:
        print("Usage: python compare.py AAPL MSFT GOOGL")
        print("       (provide 2-5 tickers)")
        sys.exit(1)

    tickers = [t.upper() for t in sys.argv[1:6]]  # Max 5 tickers
    print(f"Fetching financials for: {', '.join(tickers)}...")

    all_ratios = {}
    fiscal_year = None

    for ticker in tickers:
        company = fetch_company(ticker)
        fin = fetch_financials(ticker)
        if fin is None:
            print(f"Skipping {ticker} - could not fetch financials.")
            continue

        # Use the fiscal year from the first company
        if fiscal_year is None and fin.get("fiscal_year"):
            fiscal_year = fin["fiscal_year"]

        all_ratios[ticker] = calculate_ratios(fin)

    if not all_ratios:
        print("No data retrieved. Check your API key and tickers.")
        sys.exit(1)

    valid_tickers = [t for t in tickers if t in all_ratios]
    print_comparison(valid_tickers, all_ratios, fiscal_year or "Latest")

GET https://api.stockdata.dev/v1/company/AAPL/financials
X-API-Key: your_api_key_here

pip install requests

$ python compare.py AAPL MSFT GOOGL
Fetching financials for: AAPL, MSFT, GOOGL...

Financial Comparison (FY 2025)
═══════════════════════════════════════════════════════════════
                        AAPL          MSFT         GOOGL
───────────────────────────────────────────────────────────────
Revenue              $383.3B       $245.1B       $350.0B
Net Income            $97.0B        $88.1B        $99.2B
Profit Margin          25.3%         35.9%         28.3%
Operating Margin       30.7%         44.6%         32.1%
Total Assets         $365.0B       $512.2B       $432.5B
Total Debt           $108.0B        $47.0B        $28.5B
D/E Ratio              1.38          0.42          0.11
Free Cash Flow        $93.0B        $70.2B        $69.5B
ROA                    26.6%         17.2%         23.0%
───────────────────────────────────────────────────────────────

# Compare automakers
$ python compare.py TSLA F GM

# Compare banks
$ python compare.py JPM BAC GS WFC