SpotWire

Methodology

SpotWire composes four flagship indices from transaction-derived data and public infrastructure signals. The principles below govern all four.

Last data print: · 50 sources · 1,099 weekly comps

Principles

  1. Base period = trailing 52-week median = 100. Where less than 52 weeks of history exist, we rebase to whatever window is available and disclose the actual window in each index payload (the rebase_window_days field).
  2. Indicative until thresholds are met. An index displays the "Indicative" badge until each underlying component has at least 30 completed-transaction comps in the trailing 7-day window.
  3. Outlier trimming. Within each SKU basket, we drop the 1st and 99th percentile per pull before computing medians.
  4. Geometric mean composition. Each composite index is the equal-weighted geometric mean of its component values, normalized to its base-period median.
  5. Diffusion vs. price. SWPI in its final form is a diffusion index (stack stress), not a $ index. Components include queue depth and backlog growth alongside spot LMP.
  6. Disclosure of partial methodology. Indices in transition (currently SWPI and SWFI) carry secondary badges indicating their methodology stage.

Data source tiers

Every component on every index is classified by data-source tier. These are about authority, not quality — eBay can be a perfectly accurate signal for the secondary market it covers; it just doesn’t represent the supply chain as a whole. The per-component classification and an aggregate source_mix block are published in the exported indices.json.

Tier Definition Examples
T1OEM direct list pricing · authoritative survey series · hyperscaler public APIsDell.com, HPE channel, Supermicro configurator, BLS PPI, AWS Price List
T2Channel partners with vendor MSRP/discount disclosureCDW, FS.com new-list, ITPrice
T3SEC filing extracts (qualitative diffusion signals)EDGAR backlog, RPO, lead-time text mining, sentiment cohort
T4eBay completed transactions (secondary-market spot tape)Legacy GPU/server/SSD/RAM, T&M, PLC, networking, transceiver baskets
T5Public infrastructure datasets (qualitative)EIA, LBNL queue, gridstatus LMP

Per-index source mix (V4 — RT-1, 2026-05-29)

Index T1 (OEM/PPI/API) T2 (channel) T3 (EDGAR) T4 (eBay) T5 (infra)
SWCI67.5%0%12.5%20%0%
SWII20%60%0%20%0%
SWFI40%20%20%20%0%
SWPI15%0%45%0%40%

RT-1 (red-team finding #1): the V3 weighting still gave eBay 30–50% of the supply-chain indices. V4 caps eBay at 20% on every index and publishes the trust-tier mix so a reader can see exactly how much of each value comes from authoritative sources versus secondary-market spot tape. Full derivation in docs/research/swpi_swfi_weights_methodology.md .

Versioning & corrections

SpotWire publishes a dated methodology changelog and a corrections policy. Every methodology revision is versioned so historical index values remain reproducible. See the full methodology changelog for version history and the corrections policy.

By index

SWCI Compute

V4 weighted · RT-1 channel reweight

Seven-component basket, weighted geometric mean rebased to the trailing 168-day median. V3 (May 2026) added HBM stress and frontier GPU OEM pricing so the basket reflects the real 2026 AI buildout (B200 / GB200 / MI300X) instead of EOL A100/H100 gear alone.

Component Source Weight
Frontier GPU OEM T1B200 / GB200 / MI300X channel pricing (Dell, HPE, Supermicro)35%
HBM stress T1/T3TrendForce ASP press deltas + Micron 10-Q HBM signal score25%
Hyperscaler GPU rental T1H100 + A100 per-GPU-hour median, AWS/Azure/Oracle/Hetzner20%
Legacy GPU eBay T4A100 40/80GB PCIe, H100 PCIe, RTX 4090, RTX 30906%
Server eBay T4Dell R750/R760, HPE DL360/DL380 Gen116%
Enterprise SSD eBay T43.84TB and 7.68TB U.2 NVMe median across brands4%
DDR5 RAM eBay T464GB and 96GB DDR5 RDIMM 48004%

Rationale (V4, May 2026 — RT-1): V3 still gave eBay (Tier 4 secondary market) 50% of SWCI. V4 caps eBay at 20% and redistributes the freed weight to Tier 1 sources — frontier GPU OEM (Dell/HPE/Supermicro direct: 35%), HBM stress (TrendForce + Micron filings: 25%), and hyperscaler public APIs (20%). The secondary market is still represented but no longer dominates a supply-chain index.
Source mix: 67.5% Tier 1 · 12.5% Tier 3 · 20% Tier 4 (eBay)

YoY for SWCI is backfilled from public-source research prior to 2027-Q2. See YoY backfill disclosure below.

Methodology consistency (RT-21, May 2026): Both current-week and historical SWCI composites use the same V4 methodology: each component's basket value is rebased against its own trailing window median = 100 BEFORE the weighted geometric mean. HBM and frontier-GPU OEM components return None in historical months (no public backfill series) — historical composites use 5 of 7 components honestly, with weight renormalization. Current composite uses up to 7 components as the live data flows.

SWII Interconnect

Six-component weighted geometric mean. InfiniBand carries the largest tied weight (25%) because Dell’Oro tracks InfiniBand at roughly 80% of AI training fabric share — SWII is intended to reflect AI-infrastructure interconnect specifically. RT-15 adds direct-attach copper and active optical cables (DAC/AOC), which often account for 30–40% of AI cluster interconnect spend. RT-16 adds an NVSwitch/NVLink fabric component sourced from OEM rack-config channels (the GB200 NVL72 bundles 18 NVSwitches per rack); standalone NVLink Switch System pricing is largely RFQ-only, so this component remains thin until OEM channels expose more pricing.

  • InfiniBand FS.com new-list (30%, T2) — NDR 400G/800G, HDR 200G, XDR 800G — NVIDIA Quantum-class transceivers
  • NVSwitch / NVLink OEM channel (20%, T1) — GB200 NVL72 racks, HGX H100/H200 baseboards. Weight redistributes when OEM pricing absent.
  • FS.com Ethernet new-list (15%, T2) — 400G QSFP-DD DR4, 800G OSFP 2xDR4
  • DAC/AOC FS.com new-list (15%, T2) — 100G/400G/800G direct-attach copper and active optical cables
  • Networking eBay (15%, T4) — Cisco Catalyst 9300, 9500, Nexus 9300, Arista 7050
  • Optical transceiver eBay (5%, T4) — 100G QSFP28, 400G QSFP-DD

RT-1 (May 2026): eBay (Tier 4 secondary) reduced from 35% to 20%; weight redistributed to channel partners and OEM direct.
Source mix: 20% Tier 1 (OEM direct) · 60% Tier 2 (channel partners) · 20% Tier 4 (eBay)

YoY for SWII is not displayed until 52 weeks of spot-desk snapshots accumulate.

SWPI Power

V2 diffusion · weights research-derived

SWPI is a five-component diffusion index. Each component is normalized to its own trailing 24-month median (= 100) and then composited by the weights below. Values above 100 mean the grid stack is more stressed than its trailing baseline.

Component Source Weight
Queue depthLBNL queue + EIA-860M30%
Backlog growthEDGAR cohort (GEV, ETN, PWR, et al.)25%
Lead-time signalEDGAR text-mining20%
PPI electricalBLS 4-series blend15%
LMPERCOT + 6 RTOs (ISO-weighted)10%

Rationale (V2, May 2026): Queue depth, backlog growth, and lead-time signal together carry 75% of the weight because Sightline Climate, JLL, and CBRE all identify the physical electrical-supply layer — transformers, switchgear, batteries — as the binding constraint on 2026 AI datacenter buildout (only 5 GW under construction against 16 GW announced). LMP is downweighted from V1's 25% to 10% because it is volatile daily noise dominated by weather and gas, not a structural read on AI stack stress. ISO-weighted LMP within the LMP component is ERCOT 30, PJM 25, SPP 15, MISO 10, CAISO 10, NYISO 5, ISO-NE 5 (renormalized when an ISO is unavailable).

GEV equipment vs RPO (RT-19, May 2026): GE Vernova's headline backlog ($150-163B in earnings press releases) is Remaining Performance Obligations (RPO) — includes multi-year service contracts. SWPI's backlog component wants equipment-only (transformers, switchgear, turbines in the pipeline). The pipeline extracts Power + Electrification Equipment RPO directly from GEV's 10-K segment disclosure ($55.2B for FY2025) and applies a documented 0.40 haircut to press-release RPO figures as a proxy when only the headline is available. Calibration: 10-K equipment ($55B) ÷ Power + Electrification total RPO ($129B) ≈ 0.43, rounded down to 0.40 conservatively.

Full derivation, sensitivity tables, and citations: docs/research/swpi_swfi_weights_methodology.md .

SWFI Facility

V2 hybrid · weights research-derived

SWFI is a five-component hybrid index: two spot eBay baskets (T&M, PLC), two BLS PPI series (process instruments, HVAC), and one EDGAR cohort diffusion signal proxying cooling adoption from the otherwise RFQ-only liquid-cooling market. Each component is normalized to its own trailing-window median.

Component Source Weight
PPI process instruments T1BLS PCU33451333451320%
PPI HVAC T1BLS PCU33341533341520%
EDGAR cohort (cooling + AI-DC) T3VRT, TT, JCI, ROK, HON, DOV, EMR (sub-cohort weighted — RT-13)20%
Cooling (CDW channel) T2InRow, SRCOOL, Vertiv Liebert catalog20%
T&M eBay T412-week median basket10%
PLC eBay T412-week median basket10%

Rationale (V3, May 2026 — RT-1): eBay (Tier 4 secondary) reduced from 30% to 20%; PPI HVAC and CDW cooling channel each lifted to 20%. The four Tier 1/2/3 disclosure-grade components now carry 80% of the index. JLL projects AI fit-out costs exceeding $25M/MW, dominated by cooling complexity — so cooling-channel pricing (Vertiv, Liebert, InRow on CDW) and the BLS HVAC PPI carry the cooling-stack signal alongside EDGAR sentiment.
Source mix: 40% Tier 1 (BLS) · 20% Tier 2 (CDW) · 20% Tier 3 (EDGAR) · 20% Tier 4 (eBay)

EDGAR sub-cohort split (RT-13, May 2026): The 7-name cooling/automation cohort blends structurally different businesses. To avoid smearing Vertiv’s direct AI-datacenter cooling adoption signal with general industrial noise, the EDGAR component is now a weighted blend across four sub-cohorts:

Sub-cohort Constituents Weight
Cooling pure-playVRT — the AI-datacenter cooling signal40%
HVAC + buildingTT, JCI — some DC cooling, mostly building HVAC30%
Industrial automationROK, HON — process automation, weak DC signal20%
Diversified industrialDOV, EMR — “liquid cooling” mentions largely non-DC10%

Full derivation, sensitivity tables, and citations: docs/research/swpi_swfi_weights_methodology.md .

YoY backfill disclosure

spot-desk's own weekly scrape history begins in 2026-Q2. To enable honest YoY computation before 52 weeks of native data accumulate, SWCI uses approximately twelve months of source-attributed historical monthly price points researched from public secondary-market reports, vendor announcements, and resale tracker articles.

Each backfill entry includes a source URL and a confidence level: high (dated transactions or vendor effective dates), medium (industry roundups citing prices for a month/quarter), or low (aggregator estimate). Coverage is on the sparse end — roughly four monthly points per SKU on average across 17 basket SKUs — and gaps are honest. The full disclosure dataset is open-source in the spot-desk repository at data/historical_backfill/swci_backfill.json.

Top sources cited (by URL frequency): hashrateindex.com, altatechnologies.com, ebay.com, intuitionlabs.ai, trendforce.com, servermonkey.com, servermall.com, jarvislabs.ai, accio.com, compute.exchange, lambda.ai, coreweave.com, cdw.com, crucial.com, networkworld.com, wccftech.com.

From 2027-Q2 forward, YoY for SWCI is computed exclusively from spot-desk-scraped snapshots and the backfill is retired.

Update schedule

Indices are regenerated daily by the spot-desk pipeline. The figure displayed on the landing page reflects the most recent successful run; the date appears next to "Source: SpotWire" in the index strip footer. The weekly newsletter ships Monday mornings before US markets open and uses the most recent index print.

Outlier handling

Within each underlying SKU basket, we trim the 1st and 99th percentile of completed-transaction prices before computing medians. Listings flagged as "parts only," "for repair," or visibly bulk-lot are excluded by the scraper pipeline at ingest time, before they reach the index basket.

Volume disclosure

Each index card displays per-component n values — the number of completed-transaction comps (or upstream observations, in the case of PPI / hyperscaler series) that contributed to the current week's basket median for that component. A component with n < 30 in the trailing 7-day window is considered sparse and contributes to the Indicative flag at the index level.

Volume is published alongside price for transparency. In V2, components will be weighted by trailing-window comp volume — high-liquidity components will receive proportionally more weight in the composite — but for V1, all components are equal-weighted regardless of n. This means a sparse component (e.g. 3 GPU comps) currently contributes the same as a dense one (e.g. 300 SSD comps); the per-component n readout lets readers judge that weight for themselves.

Questions, corrections, or methodology suggestions: [email protected]