Watch the demo: https://youtu.be/Yd143L3qTqQ
ClearLedger Analytics’ Export feature is designed for one purpose: give portfolio managers a clean, portable, compliance‑friendly snapshot of their portfolio diagnostics.
In practice, exporting is not just a convenience — it’s a workflow enabler. PMs need to communicate changes, justify decisions, archive versions, and share analysis with clients, advisors, and internal teams. The export engine creates a professional, standalone workbook that supports all of those needs.
This guide explains what the export does, why it matters, how it works, and where your files are stored.
1. Why Portfolio Managers Care About Exporting
A frozen-in-time record of your portfolio
Every export is date‑stamped and stored in a dedicated folder. This gives PMs a clean historical trail of:
- portfolio weights
- diagnostics
- risk metrics
- factor exposures
- chart outputs
Perfect for compliance, oversight, and client reporting.
A shareable version of your analysis
The exported workbook contains no macros, no external links, and no ClearLedger Analytics dependencies. You can send it to:
- clients
- advisors
- internal analysts
- auditors
- CIOs
- risk teams
Everyone sees the same numbers you see — without needing ClearLedger Analytics installed.
2. Where Are Exported Files Saved?
When you trigger an export, the application dynamically builds a targeted directory structure within your local user profile. The files are automatically routed to:
C:\Users
\[YourUsername]\ClearLedgerAnalytics\Export
\[PortfolioName]\
Within this folder, the system saves a clean, formula‑intact, macro‑free Excel workbook named with the active portfolio convention and a date stamp:
[PortfolioName]_yyyymmdd.xlsx
Upon completion, the system automatically launches Windows Explorer and highlights the newly generated file for immediate distribution.
3. How the Export Engine Works
The ClearLedger Analytics export utility is engineered to handle the heavy lifting behind the scenes, ensuring that when you generate a snapshot, it is immediately ready for institutional distribution:
- Dynamic Directory Provisioning: The system automatically manages your archive folders, ensuring each version is organized and timestamped.
- Data Assembly: Core documentation, holdings, and portfolio diagnostics are intelligently compiled into a fresh, standardized workbook sequence.
- Sanitization: All live connections and external workbook dependencies are cleanly severed, ensuring the output file is entirely self‑contained.
- Macro‑Stripping Transformation: The engine removes all underlying code and security wrappers, outputting a standard
.xlsxfile designed for universal compatibility. - Formatting Enforcement: The system automatically applies institutional standards to charts and labels to ensure a professional finish.