SPB Git

spb/wp36_uqo

Public
15.0 KB

# External benchmarks inventory — WP 36 (Quebec used-car listing panel, 2026-08-12 → 2026-11-01)

Compiled 2026-11-01; every URL, table ID and latest period was checked by HTTP request that day (StatCan WDS, Données Québec CKAN API, BoC Valet, page fetches). could not verify = not confirmed. Raw copies: data/raw/external/ (README there).

# 1. Statistics Canada (all tables: Statistics Canada Open Licence; CSV = https://www150.statcan.gc.ca/n1/tbl/csv/<pid8>-eng.zip; API = POST https://www150.statcan.gc.ca/t1/wds/rest/getDataFromVectorsAndLatestNPeriods or getDataFromCubePidCoordAndLatestNPeriods; full-table link resolver GET .../getFullTableDownloadCSV/<pid8>/en)

  • New motor vehicle sales. Table 20-10-0001-01 is ARCHIVED (last period Dec 2024; released 2025-04-14). The live successor is 20-10-0085-01 "New motor vehicle sales, monthly" (dims: Geography incl. Quebec, Vehicle type, Fuel type, Origin, Units/Dollars, Unadjusted/SA). Latest period Aug 2026, released 2026-10-15 (lag ≈ 6–7 weeks). Quebec, total, unadjusted: v1617815620 (units; Aug 2026 = 41,657; Jul 41,755; Jun 42,053) and v1617815621 ($ thousands; Aug 2026 = 2,258,218). SA Quebec vector (v1617815717) is null for 2026. Sep 2026 is not on the major-release calendar; expect ~mid-November by analogy (not verified). Annual: 20-10-0002-01 archived, 20-10-0086-01 live (2025).
  • New motor vehicle registrations. 20-10-0024-01 is ARCHIVED (last 2024-Q4). Live: 20-10-0025-01 "New motor vehicle registrations, quarterly, by geographic level" (5,345 geographies incl. municipalities; fuel type; vehicle type). Latest 2026-Q2, released 2026-09-08 (lag ≈ 10 weeks); Q3 ≈ Dec 2026. New vehicles only.
  • CPI "Purchase of used passenger vehicles (202204=100)". Table 18-10-0004-01, product member 372; latest Sep 2026, released 2026-10-19; Oct 2026 due 2026-11-16 (verified in StatCan 2026 release calendar). Published for Canada only: v1374568107 (Sep 2026 = 104.5; Aug 105.4; Jul 105.0; Jun 105.0; May 105.2; Apr 103.8). Coordinates for Quebec (geo 11) and Montréal (geo 13) with member 372 return FAILED — there is no provincial used-vehicle index. Quebec has only the aggregate "Purchase of passenger vehicles" v41691856 (Sep 2026 = 131.4), All-items v41691783 (167.7) and Gasoline v41691858 (270.2). Methodology (StatCan 62F0014M2022008): J.D. Power dealer transaction prices (incl. trade-in value) aggregated by make/model with mean price, vintage age, odometer, count; hedonic time-dummy WLS (log price on log odometer, log age, model FE, rolling 5-month window); introduced with the June 2022 basket update (series start April 2022, not 2023); one-month lag in the price data (Sep index reflects Aug transactions).
  • Retail trade, NAICS 441. 20-10-0008-01 ARCHIVED (last Dec 2022). Live: 20-10-0056-01 "Monthly retail trade sales by province and territory", NAICS member 2 "Motor vehicle and parts dealers" (441); geographies include Quebec (6), Montréal CMA (7), Québec CMA (8), Gatineau (9). Latest Aug 2026, released 2026-10-23; Sep 2026 due 2026-11-20 (verified). Quebec 441 unadjusted v1446859668 (Aug 2026 = $4,755,964k; Jul 5,317,100; Jun 4,973,621); Montréal 441 unadjusted v1446859699 (Aug = $2,211,165k). SA exists for total retail (v1446859667); SA for Quebec 441 returned FAILED (could not verify). 441 mixes new/used dealers and parts.
  • Vehicle registrations (stock). 23-10-0067-01 ARCHIVED (last 2019). Live: 23-10-0308-01 "Vehicle registrations, by type of vehicle and fuel type", annual, Quebec; latest 2025, released 2026-09-22. Stock only, no flows.
  • LFS Quebec. 14-10-0287-01, Quebec employment SA v2063754 (Sep 2026 = 7,577.2k; Aug 7,575.4; Jul 7,578.3); released 2026-10-09; Oct 2026 due 2026-11-06 (verified). Unemployment rate = member 7.
  • Gasoline, monthly. 18-10-0001-01, Montréal regular self-service v735096 (Sep 2026 = 198.4 ¢/L; Aug 184.9; Jul 187.4); Québec City is geo member 6. Released with the CPI (Sep 2026 on 2026-10-19).

# 2. SAAQ / Données Québec

  • Organisation saaq on donneesquebec.ca has 8 datasets, all annual, all last updated 2023-12-18/19: Véhicules en circulation, Permis de conduire, Rapports d'accident, Avis de non-conformité CRQ, Constats d'infraction CRQ, Interventions de contrôle, Dossiers indemnisation, Blessures indemnisation.
  • "Véhicules en circulation" (https://www.donneesquebec.ca/recherche/dataset/vehicules-en-circulation), CC-BY 4.0, one CSV per year 2011–2022 (e.g. https://dq-prd-bucket1.s3.ca-central-1.amazonaws.com/saaq/Vehicule_En_Circulation_2022.csv, 905 MB, Last-Modified 2023-12-18). Vehicle-level stock snapshot (class, make, model, model year, mass, cylinders, colour, fuel, région administrative, MRC): useful for fleet composition benchmarking, not flows. No 2023–2025 vintage; revised for Loi 25.
  • Ownership transfers (transferts de propriété): no dataset found on Données Québec (queries "transfert propriété véhicule", "immatriculation", organisation SAAQ). Only procedures are published; the annual "SAAQ en bref" PDF may hold aggregate counts — could not verify any monthly/weekly series. This is the main missing official flow measure.

# 3. Industry indices (all Canada-wide, none public at Quebec level except AutoTrader/AutoHebdo regional averages)

  • Canadian Black Book — Wholesale Used Vehicle Retention Index (https://www.canadianblackbook.com/black-book-index/; the /used-vehicle-retention-index/ URL is 404). Monthly, Canada; % of original MSRP for 2–6-year-old vehicles at wholesale, volume-weighted, seasonally/age/mileage/inflation adjusted. PDF "Updated October 2026" contains Jan 2005 → Sep 2026: 2026 = 133.5, 132.2, 132.5, 130.8, 129.7, 128.0, 127.9, 127.5, 127.5 (Sep −7.6 % YoY, 0.0 % MoM). Lag ≈ 2–4 weeks; © Hearst, no reuse licence, no regional split, PDF only. Aug and Sep 2026 fall inside the panel window.
  • AutoTrader.ca Price Index (https://www.autotrader.ca/consumer/price-index/). Quarterly since 2021 (monthly only in 2020); latest Q2 2026 (published 2026-07-14): used average $36,690 (−2.6 % YoY), used sales −2.5 % YoY (DesRosiers/Dealertrack), used days' supply 44 (vs 41), used inventory by segment; p. 11 "Average price by region (used)" gives Quebec June 2025 $35,746 → June 2026 ≈ $35.7–35.9k (≈ 0.1 % YoY; column pairing ambiguous in text extraction, read the PDF). Make/age-adjusted listing prices. Q3 2026 not yet published (not verified). PDF only, © TRADER. French/Quebec edition AutoHebdo Indice des prix: latest found Q4 2025 (https://go.trader.ca/wp-content/uploads/2026/02/Price-Index-Q4-2025FR.pdf); no 2026 French edition found.
  • Cox Automotive / Manheim: Manheim Used Vehicle Value Index is US only (Sep 2026 = 205.9). No Canadian Manheim/Cox index found. Canadian wholesale alternatives: CBB (above) and OPENLANE Canada "Vehicle Value Index" (https://www.openlane.ca/en/vehicle-value-index/, narrative commentary, latest text references March 2026, "mid-150s"; monthly PDF commentaries e.g. .../Commentary-January-2026.docx.pdf; no data file; no 2026-Q3 commentary found).
  • CARFAX Canada Used Vehicle Market Insights (https://www.carfax.ca/media/..., site returns 403 to automated fetch — content could not be verified directly; secondary coverage: autosphere.ca 2026-06-15, repairerdrivennews.com 2026-08-21). Monthly-ish press releases: national average listing price (~$31.0–31.5k, Jun 2026 $31,487), used transactions (Jun 2026 = 277,361, −2.9 % YoY), inventory (+15.5 % MoM, +2.5 % YoY), damage share. No Quebec split found; no Sep/Oct 2026 edition found.
  • Clutch used-car pricing report (https://clutch.ca/blog/posts/clutch-used-car-pricing-report-aug-2026, published 2026-09-28). Monthly; Clutch retail sales (MY 2016+, <200k km): national $33,752 (−0.5 % YoY), Quebec $30,097 (+1.9 % YoY; same model/age −1.7 %) for Aug 2026. No Sep/Oct 2026 posts linked yet; no download; one retailer's own sales, not a market index.
  • Kijiji Autos / CarGurus Canada: no 2026 index or report found (could not verify any current series). DesRosiers (desrosiers.ca): paid (DAR twice-monthly, AutoWatch monthly, CUVAFY used-vehicle yearbook with CBB); no public used-vehicle series. J.D. Power Canada / PIN: paid; it is the CPI vendor (above).

# 4. Macro / event timing

  • Bank of Canada: 2026 fixed announcement dates verified: Jan 28, Mar 18, Apr 29, Jun 10, Jul 15, Sep 2, Oct 28, Dec 9. Valet V39079: 2.25 % throughout Aug–Oct 28 (Sep 2 = hold), raised to 2.50 % effective 2026-10-29 (Oct 28 decision). https://www.bankofcanada.ca/valet/observations/V39079/json (daily, open).
  • Gasoline, weekly (inside window): (i) NRCan "Weekly Average Retail Prices for Regular Gasoline" https://www2.nrcan.gc.ca/eneene/sources/pripri/prices_bycity_e.cfm?productID=1&locationID=28&frequency=W&priceYear=2026 — Montréal (28), Québec (29), Gatineau (98), Sherbrooke (30), Trois-Rivières (79); week ending Tue; latest 2026-11-03 = 187.0 ¢/L (Oct 27 185.0; Oct 20 192.3; Oct 13 198.6; Oct 6 198.0; Sep 29 196.6); XLS export; published within days. (ii) Régie de l'énergie du Québec: the /fr/consommateurs/prix-de-lessence URL is 404; live pages are https://www.regie-energie.qc.ca/fr/prix-produits-petroliers (dynamic weekly table, daily + weekly averages by region/MRC/Montréal sectors, back to Jan 2023, "Exporter les données" button, format unverified) and daily/weekly PDFs: .../releve-quotidien/rqe.pdf (daily posted prices by MRC, overwritten daily) and .../Bulletin/bulletin.pdf (weekly, 17 regions + Quebec weighted average; week of 2026-10-26: Montréal 188.9, Québec weighted 184.5 ¢/L). Historical tables page lists only rack-price PDFs. No open licence stated (© Gouvernement du Québec).

https://trends.google.com/trends/explore?geo=CA-QC&q=... returns HTTP 429 to scripts; no official API (pytrends is unofficial). Weekly values exist for windows ≥ 90 days but are sampled, normalised 0–100 per query, re-sampled on each pull, relative — a qualitative demand proxy only (average repeated draws; bilingual terms such as "auto usagée", "used car", "Kijiji autos").

# 6. Open transaction-price datasets

None found for Canada (Kaggle/Zenodo/Dataverse/academic searches): only commercial scrapers (Apify actors), a 233-row Reddit sample (June 2026, unverified licence) and UK/German/US sets. Transaction prices exist only behind J.D. Power PIN / CBB (paid).

# Within-sample (weekly) feasibility, honestly

Panel = 2026-08-12 → 2026-11-01 (≈ 11.6 weeks). Series that are weekly or finer AND already published for Aug–Oct 2026: only gasoline prices (NRCan weekly, Régie daily/weekly) and the BoC policy rate (daily; two events, Sep 2 hold, Oct 28 hike). Google Trends is the only weekly demand proxy, with the caveats above. Everything about the used-car market itself is monthly or quarterly and lagged: CBB (monthly, through Sep → 2 of 3 panel months, no Quebec), CPI used-vehicle index (monthly, Canada only, through Sep, itself lagged one month in its inputs), Clutch (monthly, Quebec figure, through Aug only), CARFAX (national, through Jun), AutoTrader (quarterly, Q2 only; Q3 pending). Official Quebec volume measures (NMVS units, retail 441, LFS) are monthly, cover only Aug (Sep arrives Nov 16–20; Oct in December). A contemporaneous weekly validation of the liquidity index is therefore not possible with external data; the feasible design is (a) composition benchmarking against the SAAQ 2022 fleet file, AutoTrader Q2 2026 regional prices and Clutch Aug 2026 Quebec prices, and (b) monthly aggregation of the index compared with CBB Sep/Aug and CPI-used Sep/Aug (2–3 points, descriptive only), with Sep/Oct official Quebec series added after 2026-11-20.

# Summary table

Source Publisher ID / URL Geo Freq Latest (2026-11-01) Lag Licence Machine-readable Variable Weekly & in-window?
New motor vehicle sales StatCan 20-10-0085-01 (v1617815620) QC M Aug 2026 (rel. Oct 15) ~6–7 wk Open Licence CSV zip / WDS new units, $ No
New vehicle registrations StatCan 20-10-0025-01 QC → municipality Q 2026-Q2 (rel. Sep 8) ~10 wk Open CSV/WDS new regs No
CPI used passenger vehicles StatCan 18-10-0004-01 m.372, v1374568107 Canada only M Sep 2026 (rel. Oct 19) ~3 wk (+1 mo data lag) Open CSV/WDS hedonic used price index (J.D. Power) No
Retail sales NAICS 441 StatCan 20-10-0056-01, v1446859668 QC, Mtl CMA M Aug 2026 (rel. Oct 23) ~7 wk Open CSV/WDS dealer sales $ No
Vehicle registrations stock StatCan 23-10-0308-01 QC A 2025 ~9 mo Open CSV/WDS fleet stock No
LFS employment StatCan 14-10-0287-01, v2063754 QC M Sep 2026 (Oct 2026 on Nov 6) ~1 wk Open CSV/WDS employment, unemp. rate No
Gasoline monthly StatCan 18-10-0001-01, v735096 Mtl, Qc City M Sep 2026 ~3 wk Open CSV/WDS ¢/L No
Gasoline weekly NRCan prices_bycity_e.cfm locationID 28/29 Mtl, Qc, Gat., Sherb., T-R W week ending 2026-11-03 days GoC terms XLS ¢/L Yes
Gasoline daily/weekly Régie de l'énergie rqe.pdf, bulletin.pdf, prix-produits-petroliers 17 regions, MRC D/W week of 2026-10-26 days © Gouv. QC PDF; web export (unverified) ¢/L posted Yes
Véhicules en circulation SAAQ via DQ vehicules-en-circulation QC, région, MRC A 2022 >1 yr CC-BY 4.0 CSV (905 MB) fleet composition No (composition only)
Ownership transfers SAAQ none found — — — — — — — No
Used Vehicle Retention Index Canadian Black Book black-book-index/ PDF Canada M Sep 2026 (127.5) ~2–4 wk © Hearst PDF only wholesale retention % No (monthly, Aug–Sep in window)
Price Index AutoTrader.ca / AutoHebdo consumer/price-index/ PDF Canada + regions (QC) Q Q2 2026 (Jul 14) ~2 wk © TRADER PDF only listing prices, days' supply No
Vehicle Value Index OPENLANE Canada openlane.ca/en/vehicle-value-index/ Canada M (narrative) ~Mar 2026 text ? © none wholesale index No
Used Vehicle Market Insights CARFAX Canada carfax.ca/media (403) Canada ~M Jun 2026 ~2 mo © none listing price, transactions, inventory No
Pricing report Clutch clutch.ca/blog Canada + QC M Aug 2026 (Sep 28) ~4 wk © none retail sold prices No
Manheim UVVI Cox Automotive US only US M Sep 2026 — © — — n/a
DesRosiers, J.D. Power PIN, Kijiji, CarGurus various paid / none found — — — — — — — No
Policy rate Bank of Canada Valet V39079 Canada D 2026-10-29 (2.50 %) 0 BoC terms JSON API rate; events Sep 2, Oct 28 Yes
Google Trends Google trends.google.com (429 scripted) CA-QC W current 0 Google ToS unofficial only relative search interest Yes, with caveats
Files · f9bf466deda3bcf4729bb4dc6e4078483843c761
Menu

Theme