Sector Statistics Report

Executive Summary

Total Companies Analyzed

7

COUNT(DISTINCT symbol) WHERE sector = 'Healthcare'

Beat Estimates

25.0%

Percentage of companies exceeding estimates

Average QoQ Revenue Growth

+10.10%

AVG((current_revenue - prev_quarter_revenue) / prev_quarter_revenue * 100)

Average YoY Revenue Growth

+16.00%

AVG((current_revenue - prev_year_revenue) / prev_year_revenue * 100)

Average QoQ EPS Growth

-100.00%

AVG((current_eps - prev_quarter_eps) / ABS(prev_quarter_eps) * 100)

Average YoY EPS Growth

-10.00%

AVG((current_eps - prev_year_eps) / ABS(prev_year_eps) * 100)

Methodology

Data Collection Period

Data collected for fiscal quarters ending within the reporting period. Companies are matched by ticker symbol across time periods.

Growth Calculations

Quarter-over-Quarter (QoQ): Compares current quarter to previous quarter (2-5 months prior for flexibility)
Year-over-Year (YoY): Compares current quarter to same quarter last year (11-14 months prior)
Outlier Handling: Growth rates are capped at -100% to +200% to prevent extreme outliers from skewing averages
Minimum Revenue Threshold: Only companies with >$1M revenue in comparison period are included in growth calculations

Earnings Surprises

Beat: Actual EPS > Estimated EPS
Meet: Actual EPS = Estimated EPS
Miss: Actual EPS < Estimated EPS

Price Reaction

Stock price percentage change following earnings announcement (typically measured as close-to-close or intraday swing).

Detailed Company Data

The following table shows individual company data used in calculations. Total records: 7

Symbol	Company	Report Date	Revenue	Rev Growth %	EPS	EPS Est.	EPS Growth %	Surprise	Reaction %
ENLV	Enlivex Therapeutics Ltd	Mar 30, 2026	N/A	N/A	$-0.23	$-0.03	N/A	$-0.20	+9.7%
PHR	Phreesia Inc	Mar 30, 2026	$0.13B	N/A	$0.02	$0.07	N/A	$-0.04	+5.8%
IRIX	IRIDEX Corporation	Mar 26, 2026	$0.01B	N/A	$-0.01	$-0.02	N/A	+$0.01	+7.2%
PMCB	PharmaCyte Biotech Inc	Mar 17, 2026	N/A	N/A	$-0.17	N/A	N/A	N/A	+6.4%
CSBR	Champions Oncology Inc	Mar 12, 2026	$0.02B	+10.1%	$-0.02	$0.09	-222.6%	$-0.11	+10.4%
BCTX	BriaCell Therapeutics Corp	Mar 11, 2026	N/A	N/A	$-2.58	N/A	N/A	N/A	+6.2%
IONS	Ionis Pharmaceuticals Inc	Feb 25, 2026	$0.20B	N/A	$-1.41	$-1.24	N/A	$-0.17	+7.4%

SQL Query Reference

Main Statistics Query

SELECT
    e.symbol,
    e.revenue as current_revenue,
    e.eps as current_eps,

    -- Previous quarter (flexible 2-5 month lookback)
    (SELECT revenue FROM earningscalendar
     WHERE symbol = e.symbol
     AND fiscalDateEnding < e.fiscalDateEnding
     AND fiscalDateEnding >= DATE_SUB(e.fiscalDateEnding, INTERVAL 5 MONTH)
     ORDER BY fiscalDateEnding DESC LIMIT 1) as prev_quarter_revenue,

    -- Previous year (11-14 month lookback)
    (SELECT revenue FROM earningscalendar
     WHERE symbol = e.symbol
     AND fiscalDateEnding BETWEEN DATE_SUB(e.fiscalDateEnding, INTERVAL 14 MONTH)
         AND DATE_SUB(e.fiscalDateEnding, INTERVAL 11 MONTH)
     ORDER BY ABS(DATEDIFF(fiscalDateEnding, DATE_SUB(e.fiscalDateEnding, INTERVAL 1 YEAR)))
     LIMIT 1) as prev_year_revenue

FROM earningscalendar e
JOIN ticker t ON e.symbol = t.ticker
WHERE t.sector = 'Healthcare'
AND e.fiscalDateEnding IS NOT NULL
AND e.revenue > 1000000  -- Minimum revenue threshold