Data collected for fiscal quarters ending within the reporting period. Companies are matched by ticker symbol across time periods.
Stock price percentage change following earnings announcement (typically measured as close-to-close or intraday swing).
The following table shows individual company data used in calculations. Total records: 1
| Symbol | Company | Report Date | Revenue | Rev Growth % | EPS | EPS Est. | EPS Growth % | Surprise | Reaction % |
|---|---|---|---|---|---|---|---|---|---|
| IDT | IDT Corporation | Mar 10, 2026 | $0.32B | N/A | $2.05 | $0.90 | N/A | +$1.15 | +5.1% |
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 = 'Communication Services'
AND e.fiscalDateEnding IS NOT NULL
AND e.revenue > 1000000 -- Minimum revenue threshold