Smart money: insiders & analysts
For fundamental PMs, analysts, event-driven funds
Form 4 purchases, rating changes and target revisions are joined to prices and technicals in one statement, so you can ask whether insiders are buying a stock that is also cheap and being upgraded.
- Financial markets
- 7 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
Large insider purchases
Open-market buys above $1M in the last month, the insider signal most research focuses on.
INSIDERS IN top500 LAST 1mo WHERE type LIKE 'P%' AND value > 1000000 SORT value DESC
Insiders buying the dip
Stocks with insider purchases in the last quarter, ranked by how far they sit below their 52-week high.
GET top500 WHERE symbol IN (INSIDERS IN top500 LAST 3mo WHERE type = 'P-Purchase') SELECT symbol, sector, close, dist_high(252) SORT dist_high(252)
Insider buying plus an upgrade
Two independent smart-money signals on the same name, with the remaining upside to the average target.
GET top500 WHERE symbol IN (INSIDERS IN top500 LAST 6mo WHERE type = 'P-Purchase') AND symbol IN (RATINGS IN top500 LAST 1mo WHERE action = 'upgrade') SELECT symbol, close, target_upside
This week's upgrades
Every upgrade with the firm and the old and new rating.
RATINGS IN top500 LAST 5d WHERE action = 'upgrade' SORT date DESC
Targets moving up fast
Stocks whose 30-day average target is 5% above the 90-day average: analysts are chasing the numbers higher.
GET top500 SELECT symbol, close, price_target, price_target_1m, target_upside, analyst_consensus WHERE price_target_1m > price_target * 1.05 SORT target_upside DESC
Do upgrades pay?
Forward returns after upgrades versus baseline at 1, 5, 20 and 60 days (takes up to ~12 s).
OUTCOMES AFTER analyst_upgrade IN top500 SINCE 2015-01-01
CEOs selling
The largest sales by chief executives in the last quarter.
INSIDERS IN top500 LAST 3mo WHERE role LIKE '%CEO%' AND type LIKE 'S%' SORT value DESC LIMIT 20
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.