Kryptofolio Documentation

Core Pillars & Innovations

🏛️ Strict Hexagonal Architecture

Total domain isolation. Zero framework imports inside pure domain models. Fully decoupled UI (Vue 3 + Pinia Colada) and backend calculation layers (Hono + SQLite + DuckDB).

⚖️ Global FIFO Tax Engine

Spanish AEAT-compliant tax reporting. Segregates fiscal lot identity from physical account custody, preventing transfers from fabricating taxable events or reordering lot queues.

🗄️ Dual-Database Analytical Engine

OLTP Transactional Ledger in SQLite with strict text-precision and cryptographic hashing, coupled with a pooled DuckDB OLAP engine for vectorized Window Functions and ASOF joins.

🔐 Privacy First & Local Vault

100% self-hosted and offline capable. AES-256-GCM authenticated credential vault with V8 RAM memory scrubbing (buffer.fill(0)), ensuring keys never leave your machine.

📊 Institutional Risk Metrics

Real-time portfolio analytics: Sharpe Ratio, 30-day annualized volatility, ATH drawdowns, Alpha & Beta vs BTC, and TTWROR with Hive-partitioned Parquet time-series.

🧹 Source Format Ingestion Wizard

Multi-step CSV/XLSX parser with exchange-specific source format profiles (Kraken, Bitvavo, Bit2Me, Bitunix, Tangem) ensuring lossless direction classification and fee attribution.

---

Technical Highlights

// Absolute Precision: Branded Value Object eradicates IEEE-754 floating-point errors
export type PreciseAmount = string & { readonly __brand: 'PreciseAmount' };

// Vectorized DuckDB OLAP: Zero-copy SQLite attachment for instantaneous tax calculation
ATTACH 'kryptofolio_ledger.db' AS ledger (TYPE SQLITE);