The ClearLedger Product Suite

ClearLedger is a complete portfolio intelligence engine for professional managers, combining diagnostics, optimization, machine‑learning signals, and reporting in a single local application.

ClearLedger works on your real portfolio — not a model proxy, not a backtested construct, and not a hypothetical simulation. Every diagnostic, signal, and optimization output reflects the actual holdings you manage today.

How It Works

ClearLedger uses a disciplined, two‑layer decision engine followed by a deterministic optimization process. Every step is transparent, local, and fully under your control — and every step operates on your real holdings, not on hypothetical portfolio constructs.

• Asymmetric Scoring: Determines which securities deserve to be in the portfolio.
• Machine‑Learning Signal Layer: Adjusts conviction and sizing sensitivity.
• Deterministic Optimization: Constructs a stable, transparent, PM‑friendly weight set.

Optimization Engine

ClearLedger's optimization engine is built around the diagnostics portfolio managers rely on every day. All calculations run locally, in memory, with deterministic and reproducible outputs — applied directly to your real portfolio, not a theoretical stand‑in.

• Expected return and volatility
• Sharpe ratio and efficiency measures
• Alpha, beta, and factor alignment
• Correlation and covariance structure
• Contribution to risk and return
• Diversification benefit and portfolio efficiency

Before / After Portfolio Comparison

Because ClearLedger works with your real portfolio, the before/after view reflects your actual current state — not a modeled proxy or reconstructed simulation. Every risk improvement figure, expected return impact, diversification change, and position‑level attribution is grounded in the holdings you actually hold.

Signals & Machine Learning

ClearLedger uses machine learning to enhance conviction — not to replace portfolio managers or predict markets. The ML layer is local, interpretable, and fully under your control.

• Buy / Hold / Sell signal strength
• Weight sensitivity and conviction adjustments
• Short‑term vs long‑term dynamics
• Regime‑aware sizing behavior

The ML layer operates as a sensitivity and conviction engine on top of a deterministic scoring framework, not as a black‑box prediction model

Security & Data Protection

ClearLedger is engineered for regulated environments where data residency, privacy, and auditability matter. Every calculation — scoring, signals, diagnostics, and optimization — runs locally, in memory, on your Windows machine. Your portfolio data never leaves your environment.

ClearLedger produces zero telemetry. No cloud compute, no external processing, no hidden API calls, and no shared infrastructure. Your analytics stay fully contained within your device.

ClearLedger's engine is delivered as hardened, compiled modules with a permanently locked VBA orchestration layer — creating a sealed, deterministic workflow that cannot be modified, inspected, or tampered with.

• Local execution only — all analytics run inside Excel and compiled Python modules
• Zero telemetry — no data transmission of any kind
• Compiled engine protection — core logic cannot be accessed or altered
• Permanent VBA project lock — orchestration layer is sealed and non‑modifiable
• No shared infrastructure — no cloud runtime or external exposure

Multi‑Tenant Architecture

ClearLedger runs inside Excel, but it is not an Excel workbook system. The application uses a single, universal Excel interface while each portfolio operates in its own fully isolated tenant workspace.

Every portfolio has its own configuration, logs, scoring outputs, ML signals, and optimization results, stored in separate tenant folders outside of Excel. Nothing is shared, duplicated, or exposed across portfolios.

This architecture delivers true multi‑tenant isolation with a clean, centralized UI — allowing professionals to manage multiple real portfolios with deterministic, reproducible workflows without juggling sheets or workbooks.

• One Excel interface — unlimited isolated tenants
• Separate folders for each portfolio's data and outputs
• No duplicated sheets or workbooks
• Instant tenant and portfolio switching
• Deterministic resolver for path and data routing

Feature Set

• Portfolio diagnostics and efficiency metrics
• Optimization engine with asymmetric scoring
• Holdings and exposure views
• Advisor‑ready reporting and export

Built for Portfolio Managers

ClearLedger is designed for professionals who think in covariance, risk budgets, factor alignment, and attribution — not for casual investors. The workflow mirrors how real portfolio decisions are made, because it is built around real portfolios, not hypothetical ones. Every input is your actual book; every output is actionable against it.

• Daily portfolio review and diagnostics
• Rebalancing and tactical adjustments
• Risk and concentration analysis
• Idea generation and security selection
• Client and CIO reporting support