Prism Data Lab

Finance, data, and what the models can actually do with it.

Every analysis here ships its dataset and the code that produced every figure. Nothing on this site is investment advice.

Latest

Methods

Nelson-Siegel on the Treasury curve: where three numbers miss

Nelson-Siegel fitted to 11 Treasury yields on 5,171 days misses by 9.4 bp on a median day; since May 2020 the 20-year sits above a curve fitted without it daily.

+21.0 bp

average miss of the 20-year yield against a Nelson-Siegel curve fitted without it, above the curve on 1,598 of 1,598 trading days since 20 May 2020

Data and code: two CSV files and one Python script, attached to the note.

Average miss by maturity, actual minus fitted, basis points (1M and 20Y in the warm colour)

1M3M6M1Y2Y3Y5Y7Y10Y20Y30Y
1M3M6M1Y2Y3Y5Y7Y10Y20Y30Y

Notes

All 29 notes
  • 4 of 60

    month-of-year tests survive a 5% false discovery rate, all of them in retail gasoline; 10 passed at p < 0.05 unadjusted

    Data Analysis

    Month-of-year effects in market data, under a false discovery rate

    Sixty month-of-year tests on the Nasdaq, Treasuries, oil, gasoline and natural gas: 10 pass at p < 0.05, and a 5% false discovery rate keeps 4, all gasoline.

    Unadjusted103.0 by chanceBenjamini-Hochberg4Holm2Bonferroni2
    Month-of-year tests passed, of 60, by correction at 0.05
  • −0.8%

    real change in average hourly earnings by the CPI-U, January 2021 to August 2026; +1.7% by the PCE price index

    Methods

    Real versus nominal: deflating a series correctly, and six mistakes

    From January 2021 to August 2026, real hourly pay fell 0.8% by the CPI and rose 1.7% by the PCE price index. How to deflate, checked against the BLS, and six traps.

    0102020082012201620202024PCECPI-U
    Start months March 2006 to August 2025. Shaded: months where the two deflators disagree on the sign. FRED CES0500000003, CPIAUCSL and PCEPI, computed from the note’s dataset.
  • 35.6%

    of the CPI-U basket is shelter in the December 2025 weights; energy is 6.4%

    Data Sources

    The CPI basket explained, from the BLS relative importance tables

    Shelter is 35.6% of the CPI-U basket for 2026 and energy 6.4%, yet energy supplied 38% of the index's rise from December to August. The weights, and how to use them.

    Energy6.26.4Core services59.560.7Core goods20.219.2Food14.113.7
    Weight in the CPI-U, December 2020 (light) and December 2025 (dark), percent
  • 5.37 bp

    mean absolute move in the 2-year yield on statement days, against 3.10 to 3.80 bp on the days either side

    Data Analysis

    An event study around 199 FOMC announcements, honestly scored

    Rates, VIX and the Nasdaq in a five-day window around every FOMC statement since 2003, with permutation tests, a multiple-testing correction, and what survives it.

    036−2−1day5.37+1+2
    Mean absolute daily change in the 2-year yield, basis points, two days either side of 197 statements
  • 1.222

    range travelled by the rolling 126-day correlation of 10-year yield changes and Nasdaq returns, from −0.529 to +0.692

    Data Analysis updated

    Correlation instability: rates, equities, and the dollar since 2006

    Rolling 126-day correlations between the 10-year yield, equities, and the dollar, with a simulation that separates a real regime change from sampling noise.

    −0.50+0.5202620182010
    Rolling 126-day correlation of 10-year yield changes and Nasdaq returns, month-end values
  • 116,000

    payroll growth in 2025 by today’s vintage; the twelve first prints summed to 1,208,000

    Data Sources

    Data revisions in FRED: ALFRED vintages and why final is not final

    Every payroll and real GDP vintage since 2010, pulled from ALFRED without a key: how far first prints moved, the annual benchmarks, and the level trap.

    −1m0+1m+2m’19’21’23’25
    Today’s vintage minus the sum of first prints, millions of jobs, 2019 to 2025

Earlier notes

Desks

Notes published on each desk, as of .
DeskNotesWhat it covers
Data Analysis9A question, a public dataset, the code, and the answer, with every figure reproducible.
Methods7Time series, risk measures, backtesting discipline, and the statistics that keep an analysis honest.
Data Sources6FRED, SEC EDGAR, BLS, exchange feeds: how to pull them, parse them, and not misread them.
LLMs in Finance5Where language models are used in financial work, what the papers and filings show, and what they get wrong.
Briefs2Short readings of a release, a filing, or a paper, dated and sourced.