The ClearLedger Analytics Product Suite

ClearLedger Analytics is a complete portfolio optimization software suite for professional managers, combining diagnostics, advanced portfolio optimization, machine‑learning signals, and advisor‑ready reporting in a single Windows‑native application.

Every calculation operates on your real portfolio — not a model proxy, not a backtest, and not a hypothetical simulation. ClearLedger Analytics reflects the actual holdings you manage today.

How It Works

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

• Asymmetric Scoring: Identifies which securities deserve to be in your optimized portfolio.
• Machine‑Learning Signal Layer: Adjusts conviction and sizing sensitivity for your optimization parameters.
• Deterministic Portfolio Optimization: Produces stable, transparent, PM‑friendly weights.

Portfolio Optimization Engine

The ClearLedger Analytics portfolio 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.

• 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 Analytics works with your real portfolio, the before/after view reflects your actual current state. Every risk improvement figure, expected return impact, diversification change, and position‑level attribution is grounded in the holdings you actually own.

Signals & Machine Learning

ClearLedger Analytics 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 portfolio optimization framework — not as a black‑box prediction model.

Security & Data Protection

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

ClearLedger Analytics 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.

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

• 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 Analytics runs inside Excel, but it is not an Excel workbook system. The application uses a single universal interface while each portfolio operates in its own fully isolated tenant workspace.

Every portfolio has its own configuration, logs, scoring outputs, ML signals, and portfolio optimization results, stored in separate tenant folders outside of Excel. Nothing is shared or duplicated 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.

• 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
• Portfolio optimization engine with asymmetric scoring
• Holdings and exposure views
• Advisor‑ready reporting and export

Built for Portfolio Managers

ClearLedger Analytics is designed for professionals who think in covariance, risk budgets, factor alignment, and attribution — not for casual investors. 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