Guide: analyze financials in Python

import os
import requests
import pandas as pd

BASE = "https://www.prometheus.services/api/v1"
HEADERS = {"X-API-KEY": os.environ["PROMETHEUS_API_KEY"]}


def statement(company: str, name: str = "income_statement",
              period_type: str = "quarterly", limit: int = 12) -> pd.DataFrame:
    """One statement as a DataFrame: rows = standardized lines, columns = period end dates."""
    r = requests.get(
        f"{BASE}/companies/{company}/financials",
        params={"period_type": period_type, "limit": limit},
        headers=HEADERS,
        timeout=30,
    )
    r.raise_for_status()
    fin = r.json()["financials"]
    rows = fin[name]["data"]
    meta = fin["period_meta"]                       # {"Q3 2025": {"end_date": "2024-10-27", ...}, ...}

    lines = {key: row["values"] for key, row in rows.items() if key.startswith("std:")}
    df = pd.DataFrame(lines).T                      # index = std:* keys, columns = period labels
    df.columns = [meta.get(c, {}).get("end_date", c) for c in df.columns]   # "TTM" has no meta
    return df.sort_index(axis=1)


nvda = statement("NVDA")
amd = statement("AMD")

# Revenue growth, quarter over quarter (fiscal calendars differ, so align on your own terms)
growth = pd.DataFrame({
    "NVDA": nvda.loc["std:revenue"].pct_change(),
    "AMD": amd.loc["std:revenue"].pct_change(),
})
print(growth.tail(6))

import time

def get(url, **kwargs):
    while True:
        r = requests.get(url, headers=HEADERS, timeout=30, **kwargs)
        if r.status_code == 429:
            wait = int(r.headers.get("Retry-After", "5"))
            time.sleep(wait)
            continue
        r.raise_for_status()
        return r.json()

r = requests.get(
    f"{BASE}/companies/NVDA/financials/as-filed",
    params={"statement": "income_statement", "period_type": "quarterly", "vintage": "original"},
    headers=HEADERS, timeout=30,
)
grid = r.json()          # rows = printed captions, cells carry value, docRef and own/comparative