Mileage-Banded Advance Grid
The asking-price band by mileage band for a book's model years in one state, with the unbanded market beside it: the input to an advance-rate grid.
This is the technical reference. For the price, a rendered sample and answers to common questions, see the Mileage-Banded Advance Grid product page.
At a glance
| Price | $9.99 per run. |
| Tool name | generate_mileage_banded_advance_grid |
| Scope | reports:mileage-banded-advance-grid |
| Built for | Auto Lender, Insurance Adjuster |
What it does
The mileage-banded price grid for a lender's book: the model years (e.g. 2019-2023) in one US state, optionally one nameplate or body type, in five mileage bands (under 30,000; 30,000 to 59,999; 60,000 to 89,999; 90,000 to 119,999; 120,000 and up) plus the same book unbanded. Each band is read from its latest month with 30 or more priced sales (percentiles cannot pool months): the priced sample (n), the Low end, median and High end of the advertised asking price at exit, the median odometer, the median days to sell and the units over the window (3 months by default). A read compares the deepest band's own median with the unbanded figure a book-level grid would use, steps the median down the bands, names the widest and tightest middle half and the slowest and fastest band, and states how many of the unbanded priced sales the bands cover. A band without 30 priced sales falls back to its latest month with 5 and is marked thin; a band with none is shown without figures and says so. From the Sold Summary API: a sale is inferred when a listing leaves a dealer website, every price is the advertised asking price at exit (never a negotiated, wholesale or lending value), and the data runs through the latest complete month. An input to an advance-rate grid, not the grid. Use when a lender, insurer or portfolio team asks what a book's model years list for by mileage band in a state, how much each 30,000 miles takes off the median, or whether the unbanded figure misstates the mileage mix. Do NOT use for how a model year holds value over time (use Value-Retention Curve), for where units clear fastest (use Remarketing Liquidity Map), or to value one VIN (use Vehicle Valuation Report). State grain, not ZIP or radius. PRICING: $9.99 per run.
Arguments
| Argument | What it is | Example | |
|---|---|---|---|
state |
Required | US state of the book, as a 2-letter code (e.g. TX). The sold data has state grain only, no ZIP or radius. | TX |
year_range |
Required | The book's model years, e.g. 2019-2023 (one year, e.g. 2021, is fine). | 2019-2023 |
make |
Recommended | Make (e.g. Chevrolet) to narrow the grid to one nameplate. Pass make and model together. | Chevrolet |
model |
Recommended | Model (e.g. Silverado 1500). Use with make. | Silverado 1500 |
body_type |
Optional | A body type to narrow the grid to one segment: SUV, Sedan, Pickup, Hatchback, Minivan, Coupe, Wagon, Convertible, Cargo Van or Passenger Van. | Pickup |
inventory_type |
Optional | Which market: used (the default), new, or certified pre-owned. | used |
months |
Optional | The window in months, ending at the latest data month: 3 by default, 1 to 12. Each band is read from its latest month in the window with 30 or more priced sales; units add across the window. | 3 |
What comes back
- The grid: five mileage bands (under 30,000; 30,000 to 59,999; 60,000 to 89,999; 90,000 to 119,999; 120,000 and up) and the same book unbanded, each with n, the Low end, median and High end of the asking price at exit, the median odometer, the days to sell and the units over the window
- Each band read from its latest month with 30 or more priced sales, labelled with that month; a thin band falls back to 5 and says so; a band with no data is shown without figures and noted
- Grid read: the deepest band's own median against the unbanded figure, the step down each band, the widest and tightest middle half, the slowest and fastest band, and how much of the book the bands cover
- Key metrics: bands with a price band, the deepest band and its median, the all-mileage median, the top-to-bottom band medians, the data month
- The caveat on every section: bands of advertised asking prices at exit, an input to an advance-rate grid, not the grid
- Next steps: the Value-Retention Curve for a model year over time, the Remarketing Liquidity Map for where units clear fastest, a monthly monitor
Asking for it in a chat client
Mileage-banded price grid for 2019-2023 used vehicles in Texas
Advance grid by mileage band for used Silverado 1500s in Ohio
Running it from a backend
Grant an agent the reports:mileage-banded-advance-grid scope, then call the tool over MCP:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "generate_mileage_banded_advance_grid",
"arguments": {
"state": "TX",
"year_range": "2019-2023",
"inventory_type": "used",
"months": 3
}
}
}
See Server-side access for the token exchange and how to read the response.