Create a systematic crypto watchlist with tiered categorization, automated alerts, and opportunity scoring. Includes Notion and spreadsheet templates.
With thousands of cryptocurrencies, finding tradeable opportunities requires a systematic watchlist. Random scrolling leads to random results.
This guide shows you how to build a watchlist system that surfaces the best opportunities consistently.
A tiered watchlist system that:
Tokens you always monitor:
Major positions in your portfolio
Highest conviction plays
Most liquid markets
Review frequency: Daily
Action: Active position management
Tokens near tradeable setups:
Approaching key levels
Developing patterns
Sector leaders showing strength
Review frequency: Daily
Action: Prepare orders, set alerts
Tokens with potential:
Interesting fundamentals
Not yet at entry levels
Sector plays to monitor
Review frequency: Weekly
Action: Scan for promotion to Tier 2
Everything else worth knowing:
Screened for basic criteria
Checked during sector rotation
Source for Tier 3 additions
Review frequency: Monthly
Action: Scan for standouts
Fundamental filters: - Working product or clear roadmap
Category limits: - Maximum 30% in any single sector
For each token, track:
Fundamental (30%)
Catalysts (20%)
Risk (10%)
Technical = (Level + Pattern + Trend + Volume) / 4 × 0.4
Fundamental = (Dev + Adoption + Tokenomics) / 3 × 0.3
Catalyst = (Events + Narrative) / 2 × 0.2
Risk = (Liquidity + Correlation) / 2 × 0.1
Total Score = Technical + Fundamental + Catalyst + Risk
| Column | Content |
|---|---|
| A | Token Symbol |
| B | Tier (1-4) |
| C | Current Price |
| D | Key Support |
| E | Key Resistance |
| F | % to Support |
| G | % to Resistance |
| H | Thesis |
| I | Technical Score |
| J | Fundamental Score |
| K | Catalyst Score |
| L | Risk Score |
| M | Total Score |
| N | Last Reviewed |
| O | Alert Price |
| P | Notes |
% to Support (F): =(C2-D2)/C2
% to Resistance (G): =(E2-C2)/C2
Total Score (M): =I2*0.4+J2*0.3+K2*0.2+L2*0.1
Days Since Review: =TODAY()-N2
- **Name:** Text
- **Tier:** Select [1, 2, 3, 4]
- **Current Price:** Number
- **Support:** Number
- **Resistance:** Number
- **Thesis:** Text
- **Technical Score:** Number (1-10)
- **Fundamental Score:** Number (1-10)
- **Catalyst Score:** Number (1-10)
- **Risk Score:** Number (1-10)
- **Total Score:** Formula
- **Last Reviewed:** Date
- **Next Event:** Date
- **Category:** Select [L1, DeFi, Gaming, AI, Meme, etc.]
- **Exchange:** Multi-select
- **Alert Set:** Checkbox
Active Trading View: Filter: Tier = 1 or 2
Sort: Total Score descending
Weekly Review View: Filter: Last Reviewed < 7 days ago
Sort: Tier ascending
Approaching Levels View: Filter: % to Support < 5% OR % to Resistance < 5% Sort: % to level ascending
Catalyst Calendar View: Calendar by Next Event
Filter: Next Event exists
For each Tier 2 token, set alerts at:
Alert when:
Monitor for:
You can't effectively track 500 tokens. Keep active watchlist (Tier 1+2) under 30.
Old entries clog your system. Set criteria for removal:
Markets change. Review and update scores regularly, not just when adding new tokens.
Future you needs context. Document why each token is on the list and what would make it a trade.
import requests
def fetch_prices(symbols):
"""Fetch current prices for watchlist"""
prices = {}
for symbol in symbols:
# Use CoinGecko, CoinMarketCap, or exchange API
response = requests.get(f"https://api.coingecko.com/api/v3/simple/price?ids={symbol}&vs_currencies=usd")
prices[symbol] = response.json()[symbol]['usd']
return prices
def check_alerts(watchlist, current_prices):
"""Check if any tokens hit alert levels"""
alerts = []
for token in watchlist:
price = current_prices.get(token['symbol'])
if price <= token['support'] * 1.02:
alerts.append(f"{token['symbol']} approaching support at {token['support']}")
if price >= token['resistance'] * 0.98:
alerts.append(f"{token['symbol']} approaching resistance at {token['resistance']}")
return alerts
Use GOOGLEFINANCE or API calls to auto-update prices:
=IMPORTDATA("https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd")
How many tokens should be on my watchlist? Active trading tiers (1+2): 20-35 tokens. Radar tier (3): 50-100. Universe (4): Unlimited but filtered.
Should I use multiple watchlists? One integrated system with tiers works better than separate lists. Use views to filter for different purposes.
How often should I add new tokens? Monthly universe scans are sufficient. Add to radar when genuinely interesting, not just because something is pumping.
What tools are best for watchlist management? Notion for flexibility, Google Sheets for simplicity and formulas, TradingView for chart-integrated tracking.