HomeKnowledge BaseHow to evaluate portfolio performance with Dune

How to evaluate portfolio performance with Dune

8 min read
·
Published May 6, 2025, 2:24 AM

Dune Analytics operates as a web-based platform that queries public blockchain data and transforms it into comprehensive dashboards. For portfolio evaluation, this provides access to real-time data about wallet holdings, transaction history, and market valuations across multiple blockchain networks. The platform supports over 100 chains, including Ethereum, Polygon, Solana, and Bitcoin, offering comprehensive coverage for diversified cryptocurrency portfolios.

The platform's primary advantage lies in its ability to aggregate data from multiple sources and present it in digestible formats. Users can track individual wallet addresses, monitor specific tokens, and analyze portfolio composition over time. This transparency eliminates the need for manual data entry and reduces errors common in traditional portfolio tracking methods.

Setting up portfolio tracking dashboards

Creating effective portfolio tracking dashboards begins with identifying relevant wallet addresses and establishing the metrics you wish to monitor. The process starts with wallet identification, where you input the public addresses of the wallets you want to track. For institutional investors or funds, this typically includes multiple addresses across different chains.

Consider a venture capital fund that holds positions across three main wallets: one containing DeFi investments on Ethereum, another holding Solana-based positions, and a third managing Bitcoin holdings. Using Dune, you would create queries that aggregate data from all three addresses to provide a unified view of the fund's total portfolio value.

The dashboard displays current holdings, daily balance changes, and token-specific breakdowns. This might show that 40% of a portfolio consists of Ethereum-based tokens, 35% Solana tokens, and 25% Bitcoin, with real-time updates as market conditions change.

Tracking daily balance changes

Daily balance tracking provides insight into portfolio volatility and performance trends. Dune's queries calculate day-over-day changes in portfolio value, accounting for both price movements and position changes from new investments or exits.

If a portfolio was valued at $10 million on Monday and $10.5 million on Tuesday, the dashboard would show a 5% daily gain. The system can break this down further, showing that the gain came from a 3% increase in Ethereum positions, a 7% increase in Solana holdings, and a 1% decrease in Bitcoin value.

This granular tracking helps identify which portions of a portfolio drive performance and which may require attention. Over time, these daily snapshots create a comprehensive performance history that can be analyzed for patterns and trends.

Analyzing token-level performance

Portfolio evaluation requires understanding how individual holdings contribute to overall performance. Dune enables token-level analysis by breaking down portfolio composition and tracking individual asset performance over time.

Consider analyzing a portfolio's top five holdings: Ethereum, Solana, Chainlink, Uniswap, and Polygon. The dashboard would show each token's current value, percentage of total portfolio, and performance over various time periods. If Ethereum represents $4 million of a $10 million portfolio, Dune displays this as a 40% allocation along with Ethereum's price performance and contribution to overall portfolio returns.

This breakdown becomes particularly valuable when rebalancing portfolios. If Solana has increased from 20% to 35% of the portfolio due to price appreciation, the dashboard immediately highlights this shift, enabling informed rebalancing decisions.

Comparing performance across time periods

Effective portfolio evaluation requires analyzing performance across multiple timeframes. Dune's historical data capabilities enable comparison of performance over days, weeks, months, and years, providing context for current performance levels.

A three-month view might show a 25% gain, while the one-year view displays a 150% increase, and the six-month period reveals a 45% return. This multi-timeframe analysis helps distinguish between short-term volatility and long-term trends.

Additionally, these comparisons can reveal seasonal patterns or market cycle influences on portfolio performance. If a portfolio consistently performs better in the fourth quarter across multiple years, this information can inform future investment timing decisions.

Benchmarking against market indices

Portfolio performance gains meaning through comparison with relevant benchmarks. While a portfolio might show a 25% quarterly return, this performance should be evaluated against broader market indices or peer portfolios to determine relative success.

Dune enables benchmark comparisons by creating queries that track market indices or competitor portfolios alongside your holdings. If the broader cryptocurrency market increased by 15% during the same quarter, a 25% return represents outperformance of 10 percentage points. Conversely, if the market gained 35%, the portfolio underperformed by 10 percentage points despite positive absolute returns.

This benchmarking extends to peer comparison, where you can track other funds' performance using their public wallet addresses. Such analysis helps identify whether performance differences stem from asset selection, timing, or market exposure.

Risk assessment through portfolio analysis

Portfolio evaluation extends beyond returns to encompass risk analysis. Dune's data enables assessment of portfolio concentration, volatility, and correlation risks through comprehensive holdings analysis.

A dashboard might reveal that 60% of portfolio value concentrates in the top three holdings, indicating concentration risk. Additionally, if most holdings consist of DeFi tokens on Ethereum, this exposes the portfolio to both sector-specific and blockchain-specific risks.

Volatility analysis compares daily portfolio value changes over time, calculating metrics such as standard deviation of returns. If one portfolio shows daily volatility of 8% while a peer fund exhibits 5% volatility, this indicates higher risk levels that should be considered alongside return metrics.

Integration with external data sources

Sophisticated portfolio evaluation often requires combining on-chain data with external information. While Dune primarily focuses on blockchain data, its queries can be structured to facilitate integration with traditional financial data sources.

For institutional investors, this might involve combining Dune's on-chain portfolio tracking with off-chain holdings data from traditional assets or private investments. The blockchain portion provides transparency and real-time updates, while external data sources complete the full portfolio picture.

Automated reporting and alerts

Consistent portfolio monitoring requires systematic reporting processes. Dune's dashboard capabilities support automated report generation, ensuring stakeholders receive regular portfolio updates without manual intervention.

Daily reports might show portfolio value, top holdings, and significant position changes. Weekly reports could include performance comparisons and risk metrics, while monthly reports provide comprehensive analysis including benchmark comparisons and detailed asset allocation reviews.

Alert systems can notify managers of significant portfolio events, such as individual positions exceeding predetermined allocation limits or total portfolio value changes beyond specified thresholds.

Dune Analytics provides comprehensive tools for portfolio performance evaluation that surpass traditional methods in transparency, accessibility, and real-time accuracy. By leveraging blockchain data, investors can track their holdings with unprecedented precision while maintaining the analytical depth required for informed decision-making.

The platform's strength lies in its combination of detailed data access, flexible query capabilities, and visual dashboard creation. Whether managing a personal portfolio or institutional fund, Dune enables thorough performance evaluation that encompasses returns analysis, risk assessment, and benchmark comparison. Success with Dune-based portfolio evaluation requires understanding the platform's capabilities, structuring queries appropriately, and interpreting results within proper market context.

Frequently asked questions

How can I use Dune dashboards to analyze the performance of my cryptocurrency portfolio?

Dune dashboards allow you to create comprehensive portfolio analysis by inputting your wallet addresses and setting up custom queries. You can track real-time portfolio value, monitor daily balance changes, and analyze token-level performance across multiple blockchain networks. The platform supports over 100 chains including Ethereum, Polygon, Solana, and Bitcoin. Set up dashboards that display current holdings, percentage allocations, and performance breakdowns over various time periods to get a complete view of your portfolio's performance.

How to track crypto portfolio performance?

Track your crypto portfolio performance by monitoring several key metrics: daily balance changes, token-level performance, and multi-timeframe comparisons. Use portfolio tracking tools to calculate day-over-day changes in portfolio value, accounting for both price movements and position changes. Break down performance by individual assets to identify which holdings are driving returns. Compare performance across different time periods (daily, weekly, monthly, yearly) to distinguish between short-term volatility and long-term trends.

How to evaluate portfolio performance?

Evaluate portfolio performance through comprehensive analysis that includes absolute returns, benchmark comparisons, and risk assessment. Compare your returns against relevant market indices or peer portfolios to determine relative performance. Analyze portfolio concentration to identify risk factors - if 60% of your value concentrates in the top three holdings, this indicates concentration risk. Calculate volatility metrics like standard deviation of returns and assess sector-specific or blockchain-specific risks based on your holdings distribution.

How to use Dune for crypto?

Use Dune Analytics by creating queries that access public blockchain data across multiple networks. Start by identifying the wallet addresses you want to track, then build dashboards that aggregate data from these addresses. Create queries that calculate portfolio metrics, track token performance, and monitor allocation changes over time. Set up automated reporting for regular portfolio updates and configure alerts for significant portfolio events like allocation limit breaches or major value changes.

What percent of your portfolio should be in crypto?

The appropriate crypto allocation depends on your risk tolerance, investment timeline, and financial goals. Conservative investors might allocate 5-10% to crypto as an alternative asset class, while more aggressive investors might go up to 20-30%. Institutional investors and crypto-focused funds may have higher allocations. Key factors include your ability to withstand high volatility, understanding of the technology, and overall portfolio diversification. Always ensure crypto allocation doesn't exceed what you can afford to lose, given the asset class's inherent volatility and regulatory uncertainties.