EquationDB

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.

  1. 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
    Try it →
  2. 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)
    Try it →
  3. 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
    Try it →
  4. 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
    Try it →
  5. 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
    Try it →
  6. 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
    Try it →
  7. 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
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More financial markets use cases