Skip to content

Dataset

S&P 500 guidance against results, 2023 to 2026

What companies told investors to expect, set against what they then reported, read from the quarterly results releases they filed with the SEC. Each of the 2,334 rows is one measure for one quarter: the range or figure guided in one release, the result in the next, and where the result landed. Every row links the filing it came from.

Download

Each file is CSV with a header row
FileRowsWhat it holdsSHA-256
guidance-lines-2026-11-02.csv (449 kB)2,334One measure for one quarter: the guide, the result and where it landed.5ad1a28c3d8b771a1de8e358b070d8dbc32d2dedb2ec9318fa462f5c0938c4f8
companies-read-2026-11-02.csv (34 kB)500Every company in the index, how many releases were read and how many lines matched, including those with none.e75920212b72aed9bee600b6700c78b74733cf8f2f3e4f30bb61b95952e6a65f
The columns
ColumnWhat it holds
companyThe company, as the index fund lists it.
quarterThe fiscal quarter the result is for.
filedThe day the release with the result was filed.
measureWhat was guided: eps, revenue, gross_margin, ebitda and others.
basisGAAP, non-GAAP, adjusted, organic or constant currency, where the release names one; matched like for like.
unitThe unit both figures are in.
guided_low, guided_highThe guided range; equal for a single figure.
actualThe reported figure.
positionAbove, within or below the range, or why it could not be placed (a result too far from the guide to be the same measure, or stated to fewer decimals).
urlThe SEC filing the result was read from.

What is in it

  • The 500 companies the Vanguard S&P 500 ETF held, 498 of them read: 5,929 results releases, filed from 2023 to 2026.
  • 140 companies have at least one matched line. The rest guide in words, on a call or not at all, or the reader could not match a guide to a result, so companies that publish a number and report the same measure next quarter are over-represented.
  • 20 measures in all. Those with at least a hundred lines:
Where each result landed against its guide
MeasureLinesAboveWithinBelowNot placed
eps89945820466171
revenue76836920243154
gross margin1726161491
ebitda15674141553
operating margin1328010402

These counts take every line as it is. How often companies beat their own guidance counts each company's quarters once and sets ranges apart from single figures.

Load it

curl -O https://canlicapital.com/datasets/company-guidance/guidance-lines-2026-11-02.csv
shasum -a 256 guidance-lines-2026-11-02.csv

python3 -c "
import csv
rows = list(csv.DictReader(open('guidance-lines-2026-11-02.csv')))
print(len(rows), rows[0]['company'], rows[0]['measure'], rows[0]['position'])"

How it was made, and what uses it

  • Read with guidance_record in canli-mcp, free and open source, which matches each guide to the next result by measure, basis and unit.
  • beat_probability, the first Canli model, is fitted and tested on it: the chance a company's next result lands above, within or below its own guide.

Limits

  • A hand read of a random sample of 30 lines against both quotes found 29 right. Other errors will remain.
  • Only what the releases print: guidance given on a call or in a slide deck is not here.
  • A record of the past. It is not a forecast and not investment advice.