The old workflow vs. the new one
- 1Portfolio managers arrive early to study models and overnight market activity
- 27am team meeting — proposals discussed, no shared view, no decisions
- 3Return to desks, refine Excel models, run compliance checks manually
- 4Email proposed changes as PDFs to approvers and wait for reply
- 5Manually generate trade file and upload to the order management system
- 6Archive the session — compliance record: a folder of spreadsheets and email threads
- Concerto syncs each analyst's Excel models in realtime — no morning downloads
- Bloomberg holdings load into Atelier automatically before the meeting starts
- 7am meeting: everyone opens Atelier on iPad or iPhone
- Proposed rebalancings visible to the whole team in real time
- Compliance rules enforced live — violations flagged before any trade is submitted
- Team agrees → single approval → trades submitted for execution automatically
The problem
The most valuable team. The most valuable hours. Spent on coordination.
Every morning, the investment team at this ETF firm followed the same ritual. Portfolio managers arrived early — sometimes before 6am — to review their Excel models, study overnight market activity, and prepare proposed portfolio rebalancings before the 7am team meeting.
The 7am meeting was structured. Everyone presented their proposed changes. The team debated. But the meeting couldn't end with a decision — because no one in the room had a live, shared view of how proposed changes interacted with each other, or whether the resulting portfolio would pass compliance.
"The 7am meeting was where proposals started — not where decisions happened."
So the meeting ended with more work. Each portfolio manager returned to their desk, refined their models in Excel, ran compliance checks manually in separate tools, emailed proposed changes as PDF attachments, and waited for confirmation. Only after that chain completed — taking hours more — could anyone generate a trade file and submit.
Compliance was checked after proposals were submitted, not before. Historical rebalancing records were reconstructed from spreadsheets and email archives when regulators asked.
The new workflow
The 7am meeting now ends with trades submitted.
The objective wasn't to replace Excel. Portfolio managers knew their models. The goal was to eliminate the coordination overhead between them.
Overnight preparation — automatic
Concerto's Excel integration captures each portfolio manager's model data automatically. Every analyst continues working in Excel — their models, their formulas, their workflow. Concerto syncs those workbooks into Atelier in realtime. Bloomberg feeds current holdings through Atelier's ingestion pipeline. By the time the meeting starts, the platform has current holdings and each manager's proposed allocations already loaded. No one downloads anything. No one manually enters numbers.
Collaborative rebalancing on iPad and iPhone
Everyone opens Atelier on their iPad or iPhone. Each portfolio manager's proposed rebalancing is visible to the whole team. Any manager can adjust allocations directly in the interface. As changes are made, the platform instantly shows how each proposed change affects holdings, position weights, sector exposures, and compliance metrics — across all proposed changes combined. Compliance rules are enforced live. If a proposed allocation violates a blocker metric, the system flags it immediately in the room. The team can resolve conflicts in real time rather than discovering them hours later.
One approval. Trades submitted.
When the team agrees on the proposed rebalancing, a single approval triggers Atelier's execution workflow: the approved session is validated, a trade file is generated in the exact format the order management system expects, the file is submitted automatically, the session is marked executed with timestamp and user attribution, and confirmation notifications are sent. The meeting ends. The trades are submitted. The most important work of the trading day is done.
What it delivered
Faster decisions. Cleaner compliance. Every trading day.
Hours recovered daily
Every trading day, the investment team's most senior members recovered hours previously lost to manual coordination.
Mobile-first in the meeting room
iPad and iPhone. Proposed rebalancings visible to every manager simultaneously, with live compliance evaluation.
Compliance enforced at proposal time
Blocker metrics prevent non-compliant allocations from being submitted. Violations are caught in the room, not discovered later.
Complete audit trail
Every session, proposed change, metric evaluation, and approval is recorded with timestamp and user attribution — regulator-ready.
Automatic trade execution
Approval triggers trade file generation, execution, and confirmation notifications automatically — no manual export.
Existing tools preserved
Bloomberg stayed. The OMS stayed. Excel stayed. Atelier and Concerto filled the gaps between them.
How the platform made it possible
Atelier and Concerto — built for this.
The foundation — auth, audit logging, workflow orchestration, data ingestion, deployment pipelines — was already built. The team configured the rebalancing business logic on top.
Atelier — Rebalancing Engine
- Session lifecycle: draft → submitted → closed → executed
- Real-time allocation editing with live totals and change tracking
- Configurable compliance metrics with blocker enforcement — no code changes to add or modify rules
- Event-triggered approval workflow with user attribution
- Automatic trade file generation, formatting, and execution submission
- Every session, edit, metric evaluation, and approval logged and auditable
Concerto — Excel Integration
- Analyst Excel models sync into Atelier automatically in realtime
- Platform data available as Excel formulas through the Concerto add-in
- Time-series model history captured and queryable
- Analysts keep their workflow; the platform gets their data
- No manual exports, no re-entry, no spreadsheet emailing
