四半期の累計と TTM（直近 12 か月）

Python: 累計から単独四半期と TTM の売上高を作る

import requests

BASE = "https://api.zenithcode.net/stable"
HEADERS = {"x-api-key": "YOUR_API_KEY"}

rows = requests.get(f"{BASE}/income-statement",
                    params={"symbol": "7203", "limit": "20"},
                    headers=HEADERS, timeout=30).json()

ORDER = {"Q1": 1, "Q2": 2, "Q3": 3, "FY": 4}

def months(fp):  # "2026-06" -> 2026 * 12 + 6
    y, m = map(int, fp.split("-"))
    return y * 12 + m

def shift_year(fp, years):
    v = months(fp) + 12 * years - 1
    return f"{v // 12}-{v % 12 + 1:02d}"

rows = sorted((r for r in rows if r["period"] in ORDER),
              key=lambda r: months(r["fiscalPeriod"]))
by_key = {(r["fiscalPeriod"], r["period"]): r for r in rows}

for i, r in enumerate(rows):
    cum = r["revenue"]
    prev = rows[i - 1] if i > 0 else None

    # Single quarter: difference from the previous cumulative figure
    # (skip years with a fiscal year-end change: check fiscalPeriodDays)
    single = None
    if r["period"] == "Q1":
        single = cum
    elif (prev and ORDER[prev["period"]] == ORDER[r["period"]] - 1
          and months(r["fiscalPeriod"]) - months(prev["fiscalPeriod"]) == 3
          and None not in (cum, prev["revenue"])):
        single = cum - prev["revenue"]

    # TTM = current cumulative + prior full year - prior-year same-quarter cumulative
    ttm = cum if r["period"] == "FY" else None
    if r["period"] != "FY":
        last_fy = next((p for p in reversed(rows[:i]) if p["period"] == "FY"), None)
        same_q = by_key.get((shift_year(r["fiscalPeriod"], -1), r["period"]))
        if last_fy and same_q and None not in (cum, last_fy["revenue"], same_q["revenue"]):
            ttm = cum + last_fy["revenue"] - same_q["revenue"]

    print(r["fiscalPeriod"], r["period"], cum, single, ttm)

どちらも 2027 年 3 月期の通期予想です。出典: /stable/earnings-forecast?symbol=7203 と /stable/key-metrics?symbol=7203&period=annual（2026 年 10 月 23 日 時点）。