How do I find historical price data?

Archives for crops, livestock and inputs

LUBBOCK, Texas — Historical price data lets you check seasonal patterns, test your assumptions and build budgets using real numbers rather than memory. Several free sources have it. The main ones are USDA NASS, USDA ERS, USDA AMS and university sites, and each covers different series and time spans. This article explains where to look and how to use the data carefully. It doesn't quote any numbers, since you can pull them yourself in a few minutes.

NASS Quick Stats

USDA NASS maintains Quick Stats, a searchable database with data on prices received by farmers, acreage, yield, production, inventories and more. You choose a commodity, a statistic, a geography and a time frame, and download the results. It's great for annual and monthly prices received, which are averages for farm-level sales. Read the definitions, since "price received" may reflect specific marketing conditions and differ from your local bid.

ERS data products

The USDA Economic Research Service publishes data sets on commodity costs and returns, feed grains, oil crops, livestock, dairy and farm income, many going back years. Look under its data products section for downloadable spreadsheets. The costs and returns data is useful for budgeting, because it tracks typical production costs by crop and region.

AMS Market News archives

USDA AMS Market News offers archived reports and, for many commodities, data downloads. These are useful for daily and weekly prices at auctions, terminals and regional markets, which are closer to what a seller saw on a particular day. Coverage start dates vary by report, so check the details. If a series was discontinued or changed, look for notes explaining it.

University and other sources

farmdoc daily publishes charts and data tied to its analyses. Extension programs such as the Iowa State Ag Decision Maker provide historical price and cost data in spreadsheets, including some local basis information. Futures exchanges also provide historical settlement data, some free and some for a fee. Your elevator or auction may keep records you can ask for.

Use the data well

Cleaning and checking the data

Once you've downloaded a file, spend a few minutes checking it. Look for gaps in dates, changes in units, or notes that a series was redefined. Plot the data, even in a simple spreadsheet chart, and look for strange jumps that could be errors or real events. Compare two sources for the same period when you can. If NASS shows a monthly average price and AMS shows daily prices, the monthly average from the daily data should be in the same neighborhood, though definitions differ. Record the source, the download date and the filters you used in a notes tab, so you or someone else can repeat it later. This takes ten minutes and prevents hours of confusion when a number you used turns out to be from a different series than you thought.

One more tip: keep a short list of the questions you want the data to answer before you start pulling it, such as how wide basis usually gets or how often prices fall below your break-even. Without questions, a download turns into a wandering afternoon. With them, it turns into a one-page summary you can reuse each year, and update in a few minutes when new numbers come in.

Historical prices tell you what happened, not what will happen. They help you set realistic expectations and see how often bad years show up. A decade of data is a good reminder that the lowest price you've ever seen isn't necessarily the lowest price there is. Keep a copy of your own records too, because your history is the one nobody else has.