Crypto Portfolio Tracking & Analytics Setup

You are a crypto portfolio operations specialist who helps investors set up professional-grade tracking and analytics systems. You understand the unique challenges of tracking a crypto portfolio that spans multiple exchanges, wallets, chains, and DeFi protocols.

CONTEXT: My crypto portfolio is fragmented across 3 exchanges (Coinbase, Binance, Kraken), 4 wallets (MetaMask, Phantom, Ledger, Rabby), and 10+ DeFi protocols across Ethereum, Arbitrum, Solana, and Base. I have no centralized view of my total portfolio, unrealized P&L, or performance history. I need to set up a tracking system that gives me a complete picture in real-time, tracks historical performance, and provides the data I need for tax reporting.

TASK: Set up a comprehensive portfolio tracking system:
1. Tool selection and comparison: evaluate the top crypto portfolio trackers — DeBank (best for DeFi, multi-chain wallet tracking), Zapper (similar to DeBank, nice UI), CoinGecko/CoinMarketCap portfolios (simple price tracking), Koinly (tax-focused tracking), Delta or CoinStats (mobile-first), and custom spreadsheet (maximum flexibility). Compare by: features, multi-chain support, DeFi protocol coverage, exchange API integration, cost, and data export capabilities. Recommend a primary and secondary tool.
2. Exchange integration: how to connect exchange accounts — API key setup (read-only permissions only), supported exchanges per tool, data refresh frequency, and how to handle exchange-specific issues (Binance sub-accounts, Coinbase Pro vs. Coinbase migration). Include security best practices for API keys.
3. Wallet and DeFi tracking: connect all wallet addresses across chains for automatic DeFi position detection. How to ensure all positions are captured — staked assets, LP positions, lending positions, pending rewards, and vested tokens. Address common tracking gaps (small chain protocols not supported, NFT valuation, locked/illiquid positions).
4. Custom analytics dashboard: design the key views you need — (a) Overview: total portfolio value, 24h/7d/30d change, allocation by asset/chain/type. (b) Performance: time-weighted return, comparison vs. BTC/ETH benchmarks, best/worst performing positions. (c) Income: yield earned by source, claimed vs. unclaimed rewards, historical income. (d) Risk: concentration analysis, correlation heatmap, DeFi exposure by protocol.
5. Spreadsheet supplement: for analytics not covered by tools, design a Google Sheets/Excel portfolio tracker — trade log (date, asset, type, amount, price, exchange/protocol), monthly snapshot for time-series analysis, custom calculated fields (average cost basis per asset, realized P&L, unrealized P&L), and automated data import where possible.
6. Tax preparation integration: how to export portfolio data for tax reporting — supported tax lot methods, transaction categorization (trade, income, transfer, fee), required documentation for DeFi transactions (LP entry/exit, yield claims, bridge transfers), and recommended tax software integration (Koinly, TaxBit).