Bufetico Join the waitlist

You guessed a number that wasn't there, and it cost you: what to do when a number is missing

· 5 min read

Course contents

You hit a blank where a number should be, so you put in a guess and made your decision on top of it. On October 29 last year, Jerome Powell got a fair question at his press conference as chair of the Federal Reserve. The government had been shut down for four weeks, and a Reuters reporter asked him if he worried the Fed would end up making policy by anecdote. Powell said the situation was temporary and the Fed would look at everything it could get. Asked whether the missing numbers could change what the Fed did in December, he said you could imagine it. Then he said, in the Fed’s own transcript: “what do you do if you’re driving in the fog? You slow down.”

That day the Fed cut its rate to a range of 3.75% to 4%. By then the government had stopped collecting and publishing its numbers, including payrolls and retail sales, CNBC reported. The one exception was the September report on consumer prices. It came out a week earlier, because Social Security’s yearly raise depends on it.

Two ways to handle a hole

The shutdown ran from October 1 to November 12. The Bureau of Labor Statistics, the agency that counts jobs and prices, didn’t handle jobs and prices the same way.

For jobs, it left the hole as a hole. The household survey, where the unemployment rate comes from, wasn’t collected for October 2025, and it wasn’t collected later either. So that month has no unemployment rate.

For prices, it did a bit of both. Most of its price indexes have no October number, just a dash in the tables. But the November index is built by comparing November’s prices with October’s, so the BLS filled October in. It carried September’s prices forward into October, and rents forward from April 2025. That left rent with no change at all in October. The BLS used a method already written in its handbook, and it says so. It also says that when prices are going up, carrying old ones forward can make the number too low. And the guess didn’t stay in October. The BLS checks the rent on the same homes every six months, so it said the October fill would show up again in April 2026, the next time it checked those homes.

You face the same choice with a company’s numbers, just on a smaller scale. A cell in your spreadsheet is empty, and you have to decide what goes in it.

Find out why it’s missing

A blank in a company’s numbers usually comes from one of four places, and each one needs something different.

Sometimes the measure doesn’t fit the company. A bank’s cash from operations, the cash that comes in from running the business, swings with what the bank does with its depositors’ money. So it can’t tell you what the bank earns. Leave it blank and look at what does fit, like net income next to deposits. The JPMorgan case walks through it.

Other times the number isn’t there yet. A company that listed last year doesn’t have many years of history. Nothing’s wrong with it. There just aren’t enough years to measure yet.

Or the number stopped coming in. A company that left the stock exchange still has a last price, and if you carry that price forward, it looks like today’s. In my list, I found 4,041 dead companies that still had a price.

And sometimes what’s missing is something behind the number. To value some companies, I need an exchange rate, and some currencies don’t have one I can use. Companies that report in them are left without a value.

Never fill it with a guess you’ll forget

A zero is a number, and so is last month’s price carried forward. Once a guess is in the cell, it looks exactly like a number someone measured, and nothing reminds you later which one it was. The BLS at least wrote its guess down in public. In your own spreadsheet, there’s no footnote unless you write one.

So leave the cell empty and write down why. And watch your formulas. In Excel, the AVERAGE function skips an empty cell, but a formula like =A2*2 treats it as a zero. A blank that turns into a zero without telling you is the worst kind of guess.

Then decide how a blank counts in a screen. A stock screen is a set of rules that cuts a long list of companies down to a few. A company with a missing number either passes a rule or it doesn’t, so put it on the “doesn’t” side. You might lose a company you’d have liked. Do it the other way, and you keep one because of a number that was never measured.

My screener does the same. In the Bufetico Filter, anything that can’t be measured stays a gray square. Bufetico never fills it with an estimate, so the company stays off the list.

Where this breaks

A gray square looks the same whether the measure doesn’t fit, the number isn’t there yet, or the exchange rate is missing. You have to open the company’s page and find out which.

And a list that drops every blank leans toward old, simple businesses that report in a major currency. Young companies and companies in some countries never show up, however good they are. Sometimes filling in a number is also the only way to get anything out on time, which is why the BLS did it.

The fog, a year later

The October that Powell was talking about is still a hole in the tables, and the BLS has already said how it’ll handle that. When October 2026 prices come out, it won’t publish a 12-month change (the change from a year earlier) for any index that’s missing its October 2025 number. That report is scheduled for November 10, at 8:30 a.m.

Key factsThe numbers and where they come from · 10 October 2026
  • On October 29, 2025, the Fed cut its rate to a range of 3.75% to 4%. By then the government had stopped collecting and publishing its numbers, including payrolls and retail sales, CNBC reported.
  • The shutdown ran from October 1 to November 12, 2025, and the Bureau of Labor Statistics never collected its household survey for October 2025, so that month has no unemployment rate.
  • To build its November 2025 price index, the BLS filled in October by carrying September’s prices forward, and rents forward from April 2025. That left rent with no change in October.
  • The BLS says that when October 2026 prices come out, in a report scheduled for November 10, it won’t publish a 12-month change for any index missing its October 2025 number.

Sold too early, or held on too long?

Join the waitlist and I'll email you when Bufetico opens, plus a new article or tool now and then.

No more than one email a week. You can unsubscribe anytime, and the Privacy Policy explains how we handle your name and email.

Can't tell a cheap stock from a dying one?

The Bufetico Filter checks more than 30,000 companies against six layers and shows you only the ones that pass. You decide how strict each layer is. Bufetico opens soon.

Join the waitlist »