---
title: "Get just the funds_latest row"
method: GET
path: "/data/funds-latest/{bw_fund_id}"
tags: ["Funds Data Plane"]
---

# Get just the funds_latest row

`GET /data/funds-latest/{bw_fund_id}`

## Request

- Base URL: `https://riskmodels.app/api`
- URL: `https://riskmodels.app/api/data/funds-latest/{bw_fund_id}`
- Auth: one of:
  - HTTP bearer
  - none

Returns only the wide-row snapshot from `public.funds_latest`. Skips the registry join — useful when the SDK already has the registry row or only needs the metric columns.

## Path parameters

- `bw_fund_id` string, required

## Response `200`

Latest snapshot row.

- FundLatest: Wide-row latest knowledge-mode snapshot from `public.funds_latest`. One row per `bw_fund_id`. Returns and diagnostics flatten the per-fund `ds_portfolio.zarr` (Funds_DAG Slice 8). Multi-quarter history lives in GCS Zarr (Stage B+). See ARCHITECTURE_FUNDS_API.md §4.2.
  - `bw_fund_id` string, required
  - `report_date` string, date, required
  - `filing_date` string, date, required
  - `extracted_at` string, date-time, required
  - `portfolio_gross_return` number, float, nullable
  - `portfolio_market_return` number, float, nullable
  - `portfolio_sector_return` number, float, nullable
  - `portfolio_subsector_return` number, float, nullable
  - `portfolio_idiosyncratic_return` number, float, nullable
  - `identity_residual` number, float, nullable
  - `weight_sum` number, float, nullable: ERM3 universe coverage (fraction of fund AUM mapping to in-universe symbols).
  - `n_holdings_active` integer, nullable
  - `effective_n` number, float, nullable: HHI-derived diversification (1 / sum(w_i^2)).
  - `top10_weight_sum` number, float, nullable
  - `total_adj_mv` number, float, nullable
  - `equity_style_9box` string, nullable
  - `n_funds_in_cell_at_report_date` integer, nullable
  - `model_version` string, nullable
  - `factor_set_id` string, nullable
  - `last_synced_at` string, date-time, required
  - `metadata` object, nullable

## Other responses

- `404`: No funds_latest row for this fund.

---

[API](https://skmtc.dev/riskmodels/apis/riskmodels-api.md) · [All operations](https://skmtc.dev/riskmodels/apis/riskmodels-api/llms.txt) · [OpenAPI document](https://skmtc.dev/riskmodels/apis/riskmodels-api/revisions/1a034cad408a?raw)