'
)
year_labels = [str(c)[:4] for c in cols]
grid_cols = "2fr " + " ".join(["1fr"] * n_cols) + " 1fr"
header = '
Metric
'
for yr in year_labels:
header += '
' + yr + '
'
header += '
YoY Δ
'
rendered = set()
body = ""
row_idx = 0
for section, candidates in groups.items():
section_rows = [r for r in candidates if r in df.index and r not in rendered]
if not section_rows:
continue
body += (
'
'
+ _esc(section) + '
'
)
for row_lbl in section_rows:
rendered.add(row_lbl)
row_data = df.loc[row_lbl]
yoy_pct = _yoy_pct(row_data.iloc[0], row_data.iloc[1]) if n_cols >= 2 else None
inv = _is_inverse(row_lbl)
bg = "var(--ink-1)" if row_idx % 2 == 1 else "var(--ink-0)"
cs = "background:" + bg + ";"
body += '
' + _esc(row_lbl) + '
'
for col in cols:
body += '
' + _fmt_cell(row_data.get(col)) + '
'
body += '
' + _yoy_html(yoy_pct, inv) + '
'
row_idx += 1
other_rows = [r for r in df.index if r not in rendered]
if other_rows:
body += (
'
'
'Other Reported Line Items
'
)
for row_lbl in other_rows:
row_data = df.loc[row_lbl]
yoy_pct = _yoy_pct(row_data.iloc[0], row_data.iloc[1]) if n_cols >= 2 else None
inv = _is_inverse(row_lbl)
bg = "var(--ink-1)" if row_idx % 2 == 1 else "var(--ink-0)"
cs = "background:" + bg + ";"
body += '
' + _esc(row_lbl) + '
'
for col in cols:
body += '
' + _fmt_cell(row_data.get(col)) + '
'
body += '
' + _yoy_html(yoy_pct, inv) + '
'
row_idx += 1
return (
'
'
'
'
'
'
'
'
+ header + body
+ '
'
)
def _augment_balance_sheet(df, ticker: str, quarterly: bool):
if quarterly or df is None or df.empty:
return df
bridge = get_balance_sheet_bridge_items(ticker)
prism_net_debt = bridge.get("net_debt")
if prism_net_debt is None:
return df
out = df.copy()
if "Prism Net Debt" not in out.index:
out.loc["Prism Net Debt"] = [float("nan")] * len(out.columns)
out.loc["Prism Net Debt", out.columns[0]] = prism_net_debt
return out
def render_financials(ticker: str):
import json as _json
info = get_company_info(ticker) or {}
price = get_latest_price(ticker)
df_income_ann = get_income_statement(ticker, quarterly=False)
df_income_qtr = get_income_statement(ticker, quarterly=True)
df_balance_ann = _augment_balance_sheet(
get_balance_sheet(ticker, quarterly=False), ticker, False
)
df_balance_qtr = get_balance_sheet(ticker, quarterly=True)
df_cashflow_ann = get_cash_flow(ticker, quarterly=False)
df_cashflow_qtr = get_cash_flow(ticker, quarterly=True)
# Context bar values
prev_close = info.get("previousClose")
if price and prev_close and prev_close > 0:
chg_pct = (price - prev_close) / prev_close * 100
sign = "+" if chg_pct >= 0 else ""
arrow = "▲" if chg_pct >= 0 else "▼"
chg_str = arrow + " " + sign + f"{chg_pct:.2f}%"
chg_cls = "chg-pos" if chg_pct >= 0 else "chg-neg"
else:
chg_str, chg_cls = "—", ""
raw_x = info.get("exchange") or ""
exchange = _XMAP.get(raw_x, raw_x) or "—"
co_name = _esc(info.get("longName") or info.get("shortName") or ticker.upper())
price_str = f"${price:,.2f}" if price else "—"
most_recent = "—"
if df_income_ann is not None and not df_income_ann.empty and len(df_income_ann.columns) > 0:
most_recent = str(df_income_ann.columns[0])[:10]
# Build all six statement HTML blobs
income_ann_html = _build_table_html(df_income_ann, INCOME_GROUPS, "stmt-income-annual", 4, False)
income_qtr_html = _build_table_html(df_income_qtr, INCOME_GROUPS, "stmt-income-quarterly", 8, True)
balance_ann_html = _build_table_html(df_balance_ann, BALANCE_GROUPS, "stmt-balance-annual", 4, True)
balance_qtr_html = _build_table_html(df_balance_qtr, BALANCE_GROUPS, "stmt-balance-quarterly", 8, True)
cashflow_ann_html = _build_table_html(df_cashflow_ann, CASHFLOW_GROUPS, "stmt-cashflow-annual", 4, True)
cashflow_qtr_html = _build_table_html(df_cashflow_qtr, CASHFLOW_GROUPS, "stmt-cashflow-quarterly",8, True)
def _safe_len(d):
return 0 if d is None or d.empty else len(d)
max_rows = max(
_safe_len(df_income_ann), _safe_len(df_balance_ann), _safe_len(df_cashflow_ann),
_safe_len(df_income_qtr), _safe_len(df_balance_qtr), _safe_len(df_cashflow_qtr),
)
height = 1400 + max_rows * 34
_ROOT = (
""
)
fonts_link = (
""
""
)
_FS_CSS = """"""
ctx_html = (
'
Income statement, balance sheet, and cash flow for '
+ ticker.upper() + '. '
'Toggle Annual / Quarterly and switch between statements using the controls below. '
'YoY column reflects change vs. the prior period.