Tracking Your Portfolio
Lesson by Uvin Vindula
Tracking Your Portfolio
Why Portfolio Tracking Matters
Once you start building a crypto portfolio, tracking it becomes essential. Without proper tracking, you won't know your true performance, you'll struggle with tax reporting, and you'll likely make worse investment decisions. Good portfolio tracking helps you:
- Understand your actual returns (not just what you think you've made).
- Monitor your asset allocation and rebalance when needed.
- Maintain records for tax purposes.
- Identify which strategies are working and which aren't.
- Make informed decisions based on data, not memory or gut feeling.
Popular Portfolio Tracking Tools
CoinGecko
CoinGecko is one of the most widely used free cryptocurrency data platforms. It offers a portfolio tracking feature that allows you to manually add your holdings and track their value over time. Key features include:
- Real-time price data for thousands of cryptocurrencies.
- Portfolio tracking with profit/loss calculations.
- Price alerts for specific assets.
- Available as a website and mobile app.
- Free to use with optional premium features.
CoinGecko is particularly good for Sri Lankan users because it supports multiple fiat currencies for display, though LKR may need manual conversion in some cases.
Delta App
Delta is a dedicated portfolio tracking app with a clean interface and powerful features:
- Supports crypto, stocks, and other asset classes in one place.
- Automatic exchange syncing via API keys (read-only).
- Detailed analytics including cost basis tracking.
- Available on iOS and Android.
- Free tier available with a premium option for advanced features.
CoinMarketCap
Similar to CoinGecko, CoinMarketCap offers portfolio tracking alongside its well-known price data platform. It provides watchlists, price alerts, and a portfolio tracker accessible via web and mobile.
The Spreadsheet Approach
Many experienced investors prefer tracking their portfolio manually using spreadsheets (Google Sheets or Excel). While more labor-intensive, spreadsheets offer complete control and customization:
A basic portfolio tracking spreadsheet should include these columns:
- Asset name: Which coin or token.
- Purchase date: When you bought it.
- Amount: How many units you purchased.
- Purchase price: Price per unit at time of purchase (in LKR and/or USD).
- Total cost: Amount multiplied by purchase price.
- Current price: Can be pulled automatically using Google Sheets functions or CoinGecko API.
- Current value: Amount multiplied by current price.
- Profit/Loss: Current value minus total cost.
- Platform/Wallet: Where the asset is stored.
Google Sheets can pull live crypto prices using the =GOOGLEFINANCE() function for major coins, or you can use third-party add-ons for broader coverage.
Privacy Considerations
This is a critical topic that many investors overlook. When you use portfolio tracking tools, consider the following privacy implications:
- API key security: If you connect an exchange via API, ensure you use read-only API keys. Never give a tracking app withdrawal or trading permissions.
- Data sharing: Understand what data the app collects and how it's used. Read privacy policies carefully.
- Cloud storage risks: Portfolio data stored in the cloud could potentially be accessed in a data breach. Consider whether you're comfortable with a company knowing your complete crypto holdings.
- Physical security: Don't show your portfolio value on your phone screen in public. In Sri Lanka and elsewhere, being known as someone with significant crypto holdings can make you a target.
- Screenshot sharing: Never share screenshots of your portfolio on social media. This is a common way scammers identify and target victims.
Best Practices for Portfolio Tracking
- Update regularly: Log transactions as soon as they happen. Don't rely on memory weeks later.
- Track everything: Include fees, transfers between wallets, staking rewards, airdrops — every movement of crypto.
- Use consistent units: Track values in one consistent fiat currency (LKR or USD) for accurate performance measurement.
- Back up your records: Keep backups of your spreadsheets and export data from apps periodically.
- Review periodically: Set a schedule — weekly or monthly — to review your portfolio performance and allocation.
What to Monitor Beyond Price
Effective portfolio management goes beyond just watching prices go up and down. Pay attention to:
- Portfolio allocation percentages: Has one asset grown to dominate your portfolio? Do you need to rebalance?
- Overall portfolio performance: Are you meeting the goals you set?
- Correlation changes: Are your assets all moving together, or is your diversification working?
- News and fundamentals: Has anything changed about the projects you're invested in?
Key Takeaways
- •Track your portfolio consistently using apps like CoinGecko, Delta, or a custom spreadsheet.
- •Always use read-only API keys when connecting exchanges to tracking apps — never grant withdrawal permissions.
- •Never share screenshots of your portfolio on social media — this makes you a target for scammers.
- •Record every transaction including fees and transfers for accurate performance tracking and tax reporting.
- •Review your portfolio allocation periodically and rebalance if necessary.
Quick Quiz
Question 1 of 3
0 correct so far
What type of API key should you use when connecting an exchange to a portfolio tracking app?