For many mortgage lenders, secondary marketing still runs on a familiar set of tools: Excel workbooks, email attachments, and manual data entry. Those methods may have worked when pipelines were smaller and market conditions were more forgiving, but things have changed. Today, these processes can quietly erode execution, introduce hidden risk, and consume scarce time that capital markets teams simply do not have.
A growing number of lenders are rethinking how they manage mortgage capital markets workflows. Instead of relying on ad hoc spreadsheets and disconnected systems, they are moving toward automated, technology-enabled processes that are designed to scale, reduce error, and provide real-time visibility.
At the heart of that shift is a simple idea: the most valuable time in secondary marketing should be spent on decisions, not data entry.
The Three Pain Points Behind Manual Workflows
Most manual capital markets workflows fall into at least one of three categories:
Time-intensive tasks
Monthly servicing released premium (SRP) updates, recurring pooling exercises, or daily trade confirms can all consume hours of expert time. Activities like rekeying pricing grids or slotting loans into mortgage-backed securities (MBS) pools are necessary, but they are not the highest-value use of a trader’s or secondary manager’s attention.
High risk of error
Typing in trade details, recutting an SRP grid by hand, or maintaining complex pooling logic in spreadsheets creates a margin of error. A misplaced decimal point or an outdated constraint may not surface immediately, but it can show up later as a pricing discrepancy, a margin leak, or a painful reconciliation at settle.
Lack of visibility
When key processes live in individual spreadsheets or offline models, the broader organization often lacks a clear view into coverage, positions, or pricing assumptions. That makes it harder for leadership to understand risk, validate decisions, and respond quickly to changing market conditions.
Modern mortgage capital markets automation aims squarely at these three issues.
Automating MBS Pooling and Best Execution
MBS pooling is a prime example of where manual workflows can hold lenders back. Deciding whether a loan should go into a 5.0 or 5.5 coupon, determining which loans qualify for specified pools, and aligning with de minimis constraints is often handled in spreadsheets. As volume grows, that approach becomes increasingly harder to manage and easier to misconfigure.
Automated pooling tools are designed to take in a lender’s pipeline and apply pre-configured constraints and investor rules. They can:
Assign loans to optimal pools based on size, coupon, and eligibility
Evaluate which loans should be delivered into specified pools versus aggregated execution
Feed pool information back to upstream systems so that locks and positions remain aligned
Instead of manually sorting rows and recalculating pool sizes, the Pool Solver feature in Optimal Blue’s CompassEdge hedging and loan trading platform gives capital markets teams the ability to review recommendations, scrutinize exceptions, and focus on strategic decisions. This automation may help reduce operational risk, improve execution consistency, and free up time for deeper margin and risk analysis.
Rethinking SRP Grids and Loan-Level Pricing
Another area where manual work can create unnecessary risk is SRP grid management. As investors update pricing, some lenders still rely on staff to key SRP values by hand into internal systems. This becomes even more complex when grids include multiple dimensions such as property type, manufactured housing, or other loan characteristics.
Direct integrations to investor APIs through Optimal Blue's open-API infrastructure can automate this process.
Instead of manually entering values, lenders can:
Pull updated SRP grids directly from approved sources
Eliminate the risk of typos that can skew margins
Update pricing more frequently in response to market movement
In parallel, Optimal Blue’s agency whole loan APIs that return loan-level dynamic pricing at the time of commitment are giving capital markets teams a clearer view of true best execution. When loan-level adjustments from agencies are incorporated directly into best execution analysis, lenders gain an apples-to-apples comparison with bulk bids and other outlets. Visibility into that agency pay-up can support more precise execution decisions and better margin management.
Bringing Structure and AI to Trade Confirmations
Trade confirmation is one of the most operationally critical tasks in secondary marketing. Every detail on a confirm needs to match what is in the internal system. Yet confirming trades one by one is time-consuming and often delivers a low hit rate in terms of caught errors.
Increasingly, capital markets teams are turning to document intelligence and AI to transform this process. In an AI-assisted confirmation workflow:
Trade confirms are uploaded in bulk
Data is extracted and matched against internal trade records
Confirms that match within defined tolerances are automatically cleared
Only genuine discrepancies are flagged for human review
This approach, made possible through tools like the Confirm Assistant feature in CompassEdge, may allow teams to confirm dozens or hundreds of trades in the time it used to take to review a handful. It also keeps confirmation logic consistent and creates a centralized, easily retrievable audit trail for internal and external reviews.
The real value is not just speed. It is the ability to focus expert time only where it is truly needed: on the small minority of trades where something does not reconcile.
Integrating Trading and Reducing Human Touchpoints
Even with strong internal controls, manually typing trade details into multiple systems leaves room for error. To address this, many lenders are increasingly interested in direct integrations between their capital markets platforms and trading venues, including agency portals and electronic trading platforms.
When prices can be requested, trades can be executed, and confirmations can be retrieved through a single, integrated workflow, lenders can:
Reduce the number of times a given trade must be manually keyed
Lower the risk of transcription errors
React more quickly in volatile markets
Capture richer data about pricing, competition, and execution quality
Over time, the trade data captured through these integrations can also support deeper analytics, such as broker dealer performance, hit rates relative to screens, and how competitive bids align with internal marks.
A Roadmap for Modernizing Secondary Marketing
The path away from spreadsheets does not require a single big-bang transformation. Many lenders start by targeting a few high-impact workflows such as:
MBS pooling and coupon allocation
SRP grid ingestion and maintenance
Agency whole loan pricing integration
Trade confirmation and document management
From there, they build toward a more connected, API-driven capital markets stack that spans pricing, hedging, pooling, and trading.
Technology platforms designed to centralize mortgage capital markets tools, including pricing engines, hedge analytics systems, and trading tools, are increasingly built to support this journey. They typically focus on delivering real-time data, robust integrations, and automation that can scale up when pipelines expand and market volatility increases.
For capital markets leaders, the strategic question is no longer whether to automate, but where to start. The manual workflows that are most time intensive, error prone, or opaque are usually the best candidates.
Follow Optimal Blue for more industry insights.
Commentary included in this piece shall not be construed as, nor is Optimal Blue providing, any legal, trading, hedging, or financial advice.
