SPB Git

spb/wp36_uqo

Public
5.9 KB · 82 lines markdown
1# The Hidden Dynamics of Used-Car Markets: Price Discovery, Inventory Liquidity, and Strategic Dealer Behavior23**UQO Working Paper No. 36** — *Evidence from a Daily Panel of 273,265 Quebec Listings*45![Paper](https://img.shields.io/badge/paper-PDF-NavyBlue) ![Python](https://img.shields.io/badge/Python-3.12-3776ab) ![Data](https://img.shields.io/badge/data-Auto--Ka%20snapshot%202026--11--01-ff5a2a) ![Reproducible](https://img.shields.io/badge/reproducible-make%20all-green) ![UQO](https://img.shields.io/badge/UQO-DSA-blue) ![Author](https://img.shields.io/badge/author-S.--P.%20Boucher-lightgrey)67## TL;DR8- Daily panel of every used-vehicle listing on 131 Quebec dealer websites, 2 full-inventory portals and 5 dealer groups, 12 Aug–1 Nov 2026 (273,265 listings, 428,484 price-log rows, 586 crawl cycles), from the aggregator Auto-Ka.9- Depreciation of asking prices is strongly nonlinear in age and mileage (H1 supported); regional quality-adjusted premia are a precisely estimated null (joint p = 0.53).10- 20 % of listings get a sustained markdown (median 2.8 %); the markdown hazard rises over three weeks; overpriced vehicles are cut sooner and more deeply.11- Competitor price cuts co-move the same day (+0.9 pp vs a 1.4 % base rate) with no lagged response; placebo null — association, not causation.12- Listing exit ≠ sale: 94 % of exits coincide across two sources within a week, but ≥ 10 % are followed by a relisting.13- A five-component Automobile Market Liquidity Index (AMLI) explains 56 % of common variation and its non-exit components predict next-week exits; deep markdowns load as illiquidity. No external forecasting claim.1415## Status16Version 1.0, November 2026. Not yet submitted (SSRN: not yet submitted). Preregistered plan: `research/analysis_plan.md` (amendments in `DECISIONS.md`).1718## What this paper does19Audits an aggregator database, builds a reproducible listing-day panel with auditable exclusions, estimates hedonic, hazard, event-study and prediction models under a preregistered plan, validates listing exit as a sale proxy, and constructs and internally validates a market-level liquidity index.2021## Headline results22| Hypothesis | Result | Evidence |23|---|---|---|24| H1 nonlinear depreciation | Supported (χ²(12)=664; CV RMSE −2.8 %) | `results/hedonic/` |25| H2 markdown hazard ↑ listing age | Supported (χ²(8)=170); competition/relative-price effects significant in Cox, imprecise in cloglog | `results/hazards/` |26| H3 competitor response | Same-day co-movement only; no lagged response; placebo null | `results/competition/` |27| H4 regional premia | Null (p = 0.53; all |premia| < 4 %) | `results/hedonic/region_premia_A4.csv` |28| H5 relative price → exit | Not supported (p = 0.42/0.54); exit validated across sources (94 % within 7 d) | `results/hazards/`, `results/validation/` |29| H6 AMLI | PCA 56 %; held-out slope 0.97 pp [0.69, 1.24]; no external test possible | `results/amli/` |3031## Repository layout32```33paper/            main.tex, sections/, appendix/, tables/, figures/, references.bib, main.pdf34src/ucml/         ingest, pricepaths, cleaning, features, hedonic, hazards, competition, prediction, amli, validation, robustness, descriptives, figures, tables, plotstyle, synthetic35scripts/          01_ingest … 13_tables (numbered pipeline)36tests/            pytest suite (synthetic fixture, no restricted data)37research/         questions.md, analysis_plan.md (preregistration)38literature/       references.bib (172 verified), evidence_matrix.csv, novelty_memo.md, search_protocol.md39reports/          data_access_audit.md, external_benchmarks_inventory.md40data/             raw/ (restricted, not committed), interim/, processed/, synthetic/41results/          machine-readable outputs per model42STATUS.md DECISIONS.md EXPERIMENTS.md CLAIMS_LEDGER.csv REPRODUCE.md43```4445## Quick start46```bash47make env && make test48make all            # data → models → tables → figures → paper  (≈45 min; needs the restricted snapshot)49cd paper && make    # PDF only50```5152## Data53Owner-authorised read-only snapshot of the Auto-Ka production database (SQLite, 1.35 GB, SHA-256 in `data/raw/*.sha256`), user table dropped before transfer; VINs, URLs, free text and exact coordinates restricted to `data/raw` and `data/interim`. Not redistributed. See `reports/data_access_audit.md`.5455## Methodology56Hedonic splines with make–model(–trim) and dealer FE (pyfixest); discrete-time cloglog and Cox hazards with dealer-clustered SEs (statsmodels, lifelines); linear-probability event study with market×week and model-year×week FE and a within-make–model placebo; LightGBM/logistic prediction with chronological, dealer and region holdouts; five-component AMLI with equal/PCA/supervised weights, dealer block bootstrap and held-out-component validation.5758## Figures & tables inventory59Figures 1–10 (`figures/`, vector PDF + PNG): coverage, depreciation surface, durations/cuts, price paths, hazards, event study, regional map, AMLI series, AMLI validation, prediction. Tables 1–9 (`paper/tables/`): sources, sample construction, descriptives, hedonic (+tests), hazards, competition (+region premia), AMLI, prediction, robustness.6061## Limitations62Asking prices, not transactions; exit = observed disappearance (≥ 10 % relistings); 81-day window; registry is not a random sample of dealers; H3 is association only; AMLI validated internally only.6364## Citation65```bibtex66@techreport{boucher2026usedcars,67  author = {Boucher, Simon-Pierre},68  title  = {The Hidden Dynamics of Used-Car Markets: Price Discovery, Inventory Liquidity, and Strategic Dealer Behavior},69  institution = {Université du Québec en Outaouais, Département des sciences administratives},70  type   = {UQO Working Paper},71  number = {36},72  year   = {2026},73  month  = {November}74}75```7677## Author & contact78Simon-Pierre Boucher — simon-pierre.boucher@uqo.ca7980## Notes81Built under the autonomous research protocol of 2026-11-01 (mandate in `docs/MANDATE.md`); all substantive claims are traced in `CLAIMS_LEDGER.csv`.82
Files · f9bf466deda3bcf4729bb4dc6e4078483843c761
Menu

Theme