Analysis of Complex Investment Portfolios

We integrate data from all necessary sources, process high-complexity operations and generate consolidated reports with complete traceability. Ideal for portfolios with DeFi operations, multichain staking, airdrops and decentralized structures.

Request a free evaluation

Introduction

Complex portfolio analysis is our most technical and specialized service. It is designed for investors who operate across multiple platforms simultaneously, manage high-complexity operations and need to consolidate dispersed data from exchanges, brokers, on-chain wallets and DeFi protocols. We apply advanced data engineering to integrate heterogeneous sources, detect duplicates, reconcile internal movements and generate consolidated reports with complete traceability. This service is not direct tax filing: it is the essential preliminary step when your data is too complex for automated tools and you need a solid foundation before preparing your tax obligations. If your portfolio presents high operational complexity, multiple blockchain ecosystems or sophisticated investment structures, this is the service you need. Shall we talk?

What's included

What the service includes

Multi-source integration: we connect and consolidate data from centralized exchanges, traditional brokers, on-chain wallets, DeFi protocols, own nodes, third-party APIs and manual CSV files.

Data normalization and cleaning: we standardize heterogeneous formats, correct timestamp errors, unify asset nomenclature and remove corrupt or incomplete records.

Advanced reconciliation: we detect and eliminate duplicate transactions, identify internal movements between your own wallets and exchanges, and reconstruct fragmented operation chains.

Operational classification: we categorize each transaction according to its nature (trading, staking, airdrops, fees, gas, bridging, wrapping, swaps, liquidity pools) to facilitate subsequent analysis.

Consolidated reporting: we generate global performance reports, balances by asset and platform, staking rewards analysis, airdrop tracking, fee breakdown and any custom view you need.

Complete deliverables: clean datasets in CSV/Excel/JSON ready for audits, technical documentation of applied methodology, traceability of adjustments and review session to resolve doubts.

How we work

Source ingestion and mapping

We receive your CSV files, read-only API credentials or on-chain wallet addresses. We map each data source, identify formats, validate integrity and detect possible structural inconsistencies before processing.

Modeling and normalization

We apply ETL transformations to unify heterogeneous data into a common model. We standardize timestamps to UTC, normalize asset symbols, convert units and correct encoding or format errors.

Cross-validation and reconciliation

We cross transactions between platforms to detect duplicates and internal movements. We validate final balances against real balances on exchanges and blockchains. We identify discrepancies and document them for joint review.

Report generation and delivery

We produce consolidated reports with views by asset, platform, operation type and time period. We deliver clean datasets, technical documentation and review session to resolve doubts about applied methodology.

Why choose us

Experience in high complexity: we have processed portfolios with numerous data sources and massive annual transaction volumes, including complex DeFi operations on Ethereum, BSC, Polygon, Solana, Cosmos, Osmosis and multiple additional networks.

Total traceability: every adjustment, duplicate removal or reclassification is documented with technical justification and possibility of subsequent audit.

No dependency on third-party software: we do not subcontract processing to automated tools. All analysis is performed with our own infrastructure and expert human judgment.

Tax compatibility: the generated reports are directly usable for preparing tax settlements, internal audits or Tax Agency requirements.

Continuous technical support: we include post-delivery follow-up to resolve doubts about consolidated data or make adjustments if you detect discrepancies.

Use cases

DeFi investor with operations on 15 blockchains

Client with active positions on Uniswap, Aave, Curve, PancakeSwap, Raydium, Osmosis and 20 other protocols. More than 200,000 on-chain transactions over 3 years. Needed to consolidate all their DeFi activity, calculate real staking and liquidity pool rewards, and prepare database for tax settlement. We integrated data from subgraphs, protocol APIs, own nodes and blockchain explorers. Result: consolidated report with complete traceability and dataset ready for tax filing.

Institutional trader with 50+ exchange accounts

Investment fund with accounts on Binance, Kraken, Coinbase, Bitfinex, OKX, Bybit and 45 more exchanges. Volume of 300,000 annual operations between spot, futures and options. Required global consolidation for internal reporting and quarterly audits. We processed APIs from all exchanges, reconciled inter-exchange transfers and generated consolidated views by trading strategy. We delivered custom dashboards and auditable datasets.

Early adopter with history since 2013

Investor with first Bitcoin purchases in 2013, operations on now-defunct exchanges, old wallets without complete records and migration between multiple hardware wallets. Needed to reconstruct complete history to comply with form 721 and prepare income tax return. We applied blockchain forensics techniques, recovered data from closed exchanges through client backups and reconstructed complete history with traceability. Result: verifiable historical database for their entire crypto tax life.

Frequently asked questions

What data formats do you support?

We support CSV from exchanges (Binance, Kraken, Coinbase, etc.), read-only APIs, on-chain wallet addresses for extraction via explorers or nodes, data from The Graph subgraphs, traditional broker files and any structured source containing transaction information. If you have a proprietary or legacy format, we can adapt after evaluation.

How long does analysis of a complex portfolio take?

It depends on the volume and complexity of your specific case. Portfolios with moderate complexity are usually processed in 1-2 weeks. Portfolios with high complexity, multiple sources and massive volumes may require between 3 and 5 weeks. In the initial evaluation we will give you a precise timeline based on your portfolio characteristics.

What exactly do you deliver at the end of the service?

We deliver clean datasets in CSV/Excel/JSON format with all your consolidated and classified transactions, analysis report with key metrics (performance, balances, fees, staking rewards), technical documentation of applied methodology, traceability of adjustments made and online review session to resolve doubts. Optionally, we can generate interactive dashboards if you require.

Does this service include tax preparation or only data analysis?

This service is exclusively data analysis. It does not include tax calculations, AEAT forms or tax advice. Its objective is to consolidate and clean your data so you have a solid foundation. If you need subsequent tax filing, we offer our Tax Settlements service as a natural complement after completing portfolio analysis.

Can you integrate data from exotic or little-known DeFi protocols?

Yes. We work with any protocol that has verifiable on-chain data or via APIs. We have integrated protocols on Ethereum, BSC, Polygon, Solana, Cosmos, Osmosis, Avalanche, Arbitrum, Optimism and other networks. If the protocol has a subgraph on The Graph, verified contract or public API, we can extract the data. In very specific cases, we can deploy own nodes if necessary.

What guarantees do you offer on the integrity of processed data?

We apply cross-validation between sources, verify final balances against real balances on blockchain and exchanges, document every transformation applied and offer complete traceability. If you detect discrepancies post-delivery, we review and correct them at no additional cost. All original datasets are kept intact during the process.

Request evaluation

Shall we talk?

If you have a portfolio with high operational complexity, operate on multiple blockchains or have received automated reports with reconciliation errors, we can help you. Tell us about your portfolio: number of platforms, transaction volume, asset types and any technical particularity. We send you an initial evaluation within 24-48 hours.

Request a free evaluation

Explore more