Macro Edge Research

Kuwait CPI 2006–2026 — Reconstruction Methodology

How 231 CSB bulletins in five formats became one cross-validated monthly series across three base years

Version 1.0 — August 2026

Series: monthly Kuwait CPI, all items and twelve COICOP divisions, 2006-01 → 2026-06 (246 months), plus official weights and CSB's exclusion aggregates from 2016-06.

Status: MER reconstruction of the official record. Values from 2013 onward reproduce the Central Statistical Bureau's printed base-2013 figures; history before 2013 is chain-linked from the 2000 and 2007 bases and is not an official series.


1. Why a reconstruction exists

Kuwait's Central Statistical Bureau publishes consumer prices as monthly bulletins — PDF and, in most years, Excel — on a page that offers no machine-readable archive, no continuous series, and no bridge across its three base years (2000, 2007, 2013). Public aggregators carry either annual averages or short recent windows. Anyone who wants the monthly record has to assemble it from the bulletins themselves. This document records how MER did that, and every safeguard between the bulletins and the published charts.

2. Source material

The raw archive is 231 CSB issues spanning 2007-01 → 2026-06 (333 files), held permanently on disk exactly as downloaded: 102 issues exist in both PDF and Excel, the rest in PDF only — all of the pre-2014 era, plus later stretches (notably 2021–2023) where CSB posted no workbook. Five container formats appear across the archive and each has its own parser path:

Era Container Notes
2007–2013 PDF bulletins some without ruling lines — parsed from word geometry
2014–2016 multi-sheet Excel workbooks one sheet per table
2017–2020 Excel + PDF pairs the PDFs carry base-2013 history the same era's workbooks print in base 2007
occasional OLE2 files served with an .xlsx name detected by magic bytes, not extension
occasional Word .docx with embedded worksheets worksheets extracted and parsed as Excel

Arabic text is normalised before matching (Unicode NFKC, hamza/yā/tā-marbūṭa folding, tatweel and diacritic stripping, Eastern-Arabic digit translation), and reversed-Arabic runs — an artifact of some PDF text layers — are matched against their reversal.

3. Cross-validation: every month, multiple witnesses

Each bulletin prints a trailing table of roughly thirteen months, so almost every month of the series appears in many independent issues, and from 2014 in two file formats of the same issue. The parser exploits that redundancy instead of trusting any single file:

4. Base years and chain-linking

CSB rebased the index in 2007 and 2013 (bases 2000 = 100, 2007 = 100, 2013 = 100). The parser tags every observation with its base — stated in the table title where present, inferred from the level (~30% apart) where not — and never mixes bases in a single series. The published level series is base 2013 throughout: official prints from 2013-01 onward, and earlier history chain-linked per division through the overlapping months of adjacent bases (headline linking factors ≈ 0.6441 for base 2000 → 2013 and ≈ 0.7786 for base 2007 → 2013). Chain-linking preserves every month-to-month change exactly as printed in its own base; what it cannot preserve is the level's official status, which is why the pre-2013 span is labeled a reconstruction.

5. External anchors

Two checks against sources that never touched this pipeline:

Before 2013, the reconstruction's annual averages sit 0.1–0.6pp below World Bank figures. That is the expected vintage effect of chain-linking from later-base tables rather than averaging the original base-2000 prints, and it is disclosed rather than adjusted away.

6. Internal consistency gates

Two identities are computed on every rebuild and gate what the site publishes:

7. Update pipeline

The series refreshes automatically: a fetcher checks the CSB page daily and downloads any issue not already archived (the archive is append-only — nothing is ever deleted, so the record survives source-side removals); a new issue triggers a full re-parse of the entire archive with all of the validation above; a parse failure rolls back to the previous CSVs and leaves the published page untouched. The quarantine list is versioned in the parser source, so a re-parse cannot silently re-admit a known-bad file.

8. Known limitations


Prepared by Macro Edge Research (Qutaiba Mohammad, Macro Strategist). This document describes data construction only; it is general research, not investment advice, and contains no recommendation to deal in any security. The underlying official record belongs to the Central Statistical Bureau, State of Kuwait.

© 2026 Macro Edge Research · General research, not investment advice; no recommendation to deal in any security. · macroedgeresearch.com