Print error JSON to stderr and exit.

Safely get a value from yfinance info dict, returning None on failure.

GET request with auth. Returns parsed JSON.

Write a row of header-styled cells.

Last n values from series, filtering None.

Set column widths based on content length, clamped to [min_w, max_w].

Format a number with comma separators.

Freeze the first row and first column.

Save figure and close.

Write a single data cell with proper style and number format.

Compute trailing average ratio of numerator/denominator over recent periods.

Apply green/red conditional formatting for positive/negative values.

Recursively flatten a nested dict into dot-notation key/value pairs.

Return True if a metric name looks like a percentage.

Apply design system styling to an axes object.

Generic builder for Income Statement, Balance Sheet, Cash Flow tabs.

Get the most recent non-None value for a metric.

Compute trailing average of a metric over the last n available periods.

Build Basic Auth headers from environment variables.

Auto-paginate a list endpoint that returns {count, next, results}.

Build a Subdoc containing a formatted table. Args: doc: DocxTemplate instance rows_data: list of dicts (the table rows) c

Recursively compare two dicts, returning a list of change entries.

Internal helper to fetch multiples for a ticker. Returns a dict.

Write text into a cell and apply formatting.

Run a single poll cycle.

Compute each quarter's share of trailing annual revenue. Returns a list of n_quarters fractions that sum to ~1.0, representing the seasonal w

List all available sub-industries.

Load .env file manually without requiring python-dotenv.

POST request with auth. Returns parsed JSON.

Division returning None when b is zero or either operand is None.

Add a clickable hyperlink to a paragraph.

Build a table config from the keys in the first row of data. Assumes every row dict has a 'metric' key plus period columns.

Compare two lists and return change entries for added/removed/changed items.

Determine changed/unchanged status for each top-level section.

Compute YoY growth percentages. Returns list same length as values, with None for the first 4 entries (no prior-year comp).

Set up document styles for Title, Heading 1, Heading 2, and Normal.

Set up document styles for Title, Heading 1, Heading 2, and Normal.

Generate a default output path from chart type and timestamp.

Derive sub-line items for projected periods from high-level projections. Uses historical ratios to fill in IS/CF/BS items that weren't directly

Find Chrome/Chromium binary.

Find Chrome/Chromium binary.

Load .env file from project root if it exists.

Merge projected values into income_statement, balance_sheet, and cash_flow. For each metric in ctx["projections"], if a matching metric name exis

Extract the top-level section name from a dotted path.

Write text into a cell, converting [text](url) to hyperlinks.

Generate n period labels after last_period_str.

Build the full multi-tab workbook from context data.

Check the latest update timestamps for a list of companies.

Main crawling function

Compare two JSON objects and return a structured diff report.