Pool Analytics

Once a deal is in review, the platform creates a securitization pool from the loan tape. Pool analytics give you aggregate statistics — balances, weighted averages, delinquency breakdown, geographic spread, and vintage distribution. This recipe shows how to navigate pool data.

Overview

GET /originator/pools                    → list all pools
GET /originator/pools/:poolId            → pool details
GET /originator/pools/:poolId/summary    → aggregate statistics
GET /originator/pools/:poolId/report     → full pool report
GET /originator/pools/deal/:dealId       → find pool by deal

Step 1 — List Your Pools

Returns all securitization pools associated with your organization.

curl https://api.9squid.com/v1/api/originator/pools \
  -H "Authorization: Bearer <your_token>"

Response

{
  "success": true,
  "data": [
    {
      "pool_id": "clxpool001",
      "deal_id": "clx1a2b3c4d5e6f7g8h9",
      "asset_type": "Auto",
      "loan_count": 1240,
      "total_balance": 48500000,
      "created_at": "2026-04-01T00:00:00Z"
    }
  ]
}

Step 2 — Get Pool Details

Fetch a specific pool by its ID.

curl https://api.9squid.com/v1/api/originator/pools/clxpool001 \
  -H "Authorization: Bearer <your_token>"

Step 3 — Pool Summary Statistics

The summary endpoint returns the key aggregate metrics in a single call — the fastest way to get a health check on your pool.

curl https://api.9squid.com/v1/api/originator/pools/clxpool001/summary \
  -H "Authorization: Bearer <your_token>"

Response

{
  "success": true,
  "data": {
    "total_balance": 48500000,
    "loan_count": 1240,
    "wa_coupon": 6.85,
    "wa_maturity": 54.2,
    "wa_ltv": 72.4,
    "wa_fico": 718,
    "wa_dti": 38.1,
    "wa_seasoning": 8.3,
    "balance_stats": {
      "min": 4200,
      "max": 95000,
      "avg": 39112
    },
    "delinquency_breakdown": {
      "current": 94.2,
      "30_days": 3.8,
      "60_days": 1.4,
      "90_plus_days": 0.6
    },
    "geographic_top_5": [
      { "state": "CA", "pct": 22.1 },
      { "state": "TX", "pct": 14.3 },
      { "state": "FL", "pct": 11.8 },
      { "state": "NY", "pct": 9.2 },
      { "state": "IL", "pct": 6.7 }
    ],
    "vintage_distribution": {
      "2023": 18.4,
      "2024": 51.2,
      "2025": 30.4
    }
  }
}

Step 4 — Full Pool Report

For a comprehensive export of all pool data including loan-level detail and stratification tables:

curl https://api.9squid.com/v1/api/originator/pools/clxpool001/report \
  -H "Authorization: Bearer <your_token>"

Step 5 — Find Pool by Deal ID

If you know the deal but not the pool ID, look it up directly:

curl https://api.9squid.com/v1/api/originator/pools/deal/clx1a2b3c4d5e6f7g8h9 \
  -H "Authorization: Bearer <your_token>"

Returns the pool associated with that deal — same shape as the pool detail response.

Key Metrics Reference

Metric	Description
`wa_coupon`	Weighted average interest rate across all loans
`wa_maturity`	Weighted average remaining term in months
`wa_ltv`	Weighted average loan-to-value ratio
`wa_fico`	Weighted average borrower credit score
`wa_dti`	Weighted average debt-to-income ratio
`wa_seasoning`	Weighted average months since origination

What’s Next

ALM Analytics — run duration, convexity, and stress tests on the deal
Run Selection Criteria — validate loan eligibility before reviewing pool stats
API Reference — Pools — full schema for all pool endpoints

​Overview

​Step 1 — List Your Pools

​Step 2 — Get Pool Details

​Step 3 — Pool Summary Statistics

​Step 4 — Full Pool Report

​Step 5 — Find Pool by Deal ID

​Key Metrics Reference

​What’s Next