Liquidity Flow Crypto USD Dashboard

An auto-updating Google Sheets dashboard for tracking broad U.S. dollar liquidity conditions and crypto-market liquidity stress signals.

The dashboard was designed and inspired by Zoltan Pozsar's work on the plumbing of global dollar liquidity: central bank balance sheets, Treasury cash balances, reserves, repo, funding pressure, collateral scarcity, and the way those flows can influence risk assets. This project adapts that macro-liquidity lens into a practical monitoring sheet for crypto and stablecoin markets.

This is an independent tool. It is not affiliated with or endorsed by Zoltan Pozsar, FRED, DefiLlama, CoinGecko, Binance, OKX, Bybit, Kraken, or Google.

What It Tracks

The dashboard combines macro liquidity gauges with crypto-native liquidity indicators:

• Fed balance sheet, Treasury General Account, ON RRP, reserves, SOFR, and IORB from FRED.
• Net liquidity proxy: Fed balance sheet - TGA - ON RRP.
• Stablecoin market capitalization from DefiLlama.
• USDT and USDC peg deviations from CoinGecko, with Kraken as fallback.
• BTC perpetual funding from Binance, with OKX and Bybit as fallbacks.
• Manual rows for cross-currency basis, SOFR-OIS/FRA-OIS, MOVE, and spot ETF flows.
• A composite tightening/easing score based on available signals.

Files

• liquidity-dashboard-automation.md contains the full Google Apps Script and implementation notes.
• README.md gives the project overview and setup instructions.

Setup

1. Get a free FRED API key: https://fred.stlouisfed.org/docs/api/api_key.html

2. Create a new Google Sheet.

3. Add two tabs:

   • Dashboard
   • History

   The script can create them if missing, but creating them upfront keeps the layout explicit.

4. Open Extensions -> Apps Script.

5. Delete the default Apps Script code.

6. Copy the JavaScript block from liquidity-dashboard-automation.md and paste it into Apps Script.

7. Replace:

   const FRED_KEY = 'YOUR_FRED_API_KEY_HERE';

   with your actual FRED API key.

8. Run updateDashboard manually once.

9. Review and approve the Google authorization prompt.

   Google may show "Google hasn't verified this app" because this is your personal Apps Script project. Proceed only if you created the script yourself and the developer email shown is your own account or an account you trust.

10. Run createDailyTrigger once to schedule automatic refreshes.

How To Use It

After setup, the Dashboard tab shows the latest values and flags. The History tab stores one row per calendar date. If both the daily trigger and the Thursday H.4.1 refresh run on the same date, the later run updates that date's row instead of appending a duplicate.

The key output is:

• score: number of tightening/risk flags currently active.
• score_max: number of available signals. This can be below 8 if a free API is unavailable.
• regime: EASING, MIXED, or TIGHTENING.

Manual entries live in column B of the Dashboard manual-entry rows:

• 3m EUR cross-currency basis.
• SOFR-OIS / FRA-OIS.
• MOVE index.
• Spot ETF flows, 5-day net.

The script preserves those manual values across refreshes.

API Fallbacks

Some free endpoints throttle or block requests depending on quota or region. The script handles that by using fallback sources where practical:

• Stablecoin supply: DefiLlama stablecoins.llama.fi, then api.llama.fi.
• USDT/USDC pegs: CoinGecko, then Kraken.
• BTC funding: Binance, then OKX, then Bybit.

If every source for a field fails, the field shows N/A and does not count in the score denominator.

To inspect API issues, open Apps Script -> Executions and check the latest run logs.

Interpreting The Score

The score is a rough regime filter, not a trading system.

• More tightening flags means liquidity conditions are deteriorating or risk appetite is more crowded.
• Fewer tightening flags means conditions are looser or less stressed.
• The thresholds are intentionally editable in the TH config object inside the script.

The framework is useful for monitoring macro liquidity context, but it should be calibrated against your own market view and risk process.

Contributing

Contributions are welcome. Useful improvements include better data-source fallbacks, cleaner Apps Script ergonomics, additional liquidity gauges, chart templates, alerting examples, documentation fixes, and calibration notes for different market regimes.

If you change the script, please keep the setup flow simple for non-engineers and document any new API keys, permissions, quotas, or regional restrictions.

Disclaimer

This is monitoring tooling, not investment advice. The inputs can be delayed, revised, rate-limited, geo-blocked, or wrong. Validate the data before making decisions from it.