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: 2
| Symbol | Company | Report Date | Revenue | Rev Growth % | EPS | EPS Est. | EPS Growth % | Surprise | Reaction % |
|---|---|---|---|---|---|---|---|---|---|
| AXR | AMREP Corporation | Mar 12, 2026 | $0.01B | +55.1% | $0.58 | $0.57 | +162.4% | +$0.01 | +4.2% |
| MAYS | JW Mays Inc | Mar 12, 2026 | $0.01B | N/A | $-0.25 | N/A | N/A | N/A | +1.4% |
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 = 'Real Estate'
AND e.fiscalDateEnding IS NOT NULL
AND e.revenue > 1000000 -- Minimum revenue threshold