look-03-growth-trend

You can analyze growth trends by running the script with a stock code, analysis date, and lookback years to compute CAGR. It uses DuckDB to query revenue and net profit data, handles missing values, and outputs structured evidence for growth quality.

Acquisition influence is identified using proxy signals like goodwill changes and cash paid for subsidiaries. By analyzing these alongside CAGR calculations, the Skill helps distinguish organic growth from acquisition-driven expansion in financial reports.

DuckDB supports this financial analysis by querying the ashare.duckdb database to calculate CAGR from annual reports. The Skill handles missing data gracefully and automatically flags financial sector firms as not applicable for this growth trend check.

This growth trend analysis tool does not work for financial firms. It explicitly flags financial sector companies as not applicable, restricting its CAGR computations and acquisition signal detection to non-financial annual report data.