EquationDB

Credit & distress early warning

For credit analysts, distressed-debt funds, lenders

Leverage, coverage, liquidity, price drawdowns, volatility spikes, downgrades and insider selling can be combined in one statement. Equity usually flags credit trouble first, and this is where you see it.

  • Financial markets
  • 6 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. Levered with thin coverage

    Net debt above four times EBITDA and EBIT covering interest less than three times, with price stress alongside.

    GET top500 SELECT symbol, sector, netdebt_ebitda, interest_coverage, dist_high(252), natr(14) WHERE netdebt_ebitda > 4 AND interest_coverage < 3 SORT interest_coverage
    Try it →
  2. Deep drawdown, volatility spiking

    More than 40% below the peak with volatility in the top decile of the stock's own year: the equity market pricing in stress.

    GET top500 SELECT symbol, sector, drawdown() AS dd, natr(14) WHERE drawdown() < -40 AND natr(14) > pctl(90) SORT dd
    Try it →
  3. Downgrades of levered names

    Analyst downgrades in the last month for companies with net debt above three times EBITDA.

    RATINGS IN top500 LAST 1mo WHERE action = 'downgrade' AND symbol IN (GET top500 WHERE netdebt_ebitda > 3)
    Try it →
  4. New lows among high-leverage names

    52-week lows in the past month for companies with debt above twice equity.

    EVENTS new_low_252 IN (GET top500 WHERE debt_equity > 2) LAST 1mo
    Try it →
  5. Insiders selling weak credits

    Insider sales at companies with interest coverage below three times.

    INSIDERS IN (GET top500 WHERE interest_coverage < 3) LAST 3mo WHERE type LIKE 'S%' SORT value DESC
    Try it →
  6. Liquidity squeeze

    Current ratio below 0.8 and negative free cash flow: short-term obligations with no internal funding.

    GET top500 SELECT symbol, sector, current_ratio, quick_ratio, fcf_yield WHERE current_ratio < 0.8 AND fcf_yield < 0
    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