Which sources cover five year price history?

Where to pull multi-year price records

KANSAS CITY, Missouri — Five-year price history is available from several public sources, and most are free. The core ones are NASS for prices received by farmers, AMS Market News for market reports at terminals, auctions and wholesale points, ERS for downloadable data products, and AgMRC for commodity price resources. University sites such as the Iowa State Ag Decision Maker library add charts and spreadsheets.

Which one you need depends on what price you mean: a national average, a state average, a local cash bid, a futures settlement or a wholesale quote.

Farm-level prices from NASS

NASS collects prices received by farmers and publishes monthly and annual series by commodity and often by state. Its online database, called Quick Stats, can be searched by commodity, geography and time period, and the results can be downloaded. If you want the average price farmers received across several years, this is where it usually lives. Check the definitions, since NASS differentiates between prices received in a month and marketing-year averages.

Market reports from AMS

AMS Market News covers a wide range of commodities, including grain, livestock, dairy, specialty crops and more, reported by location. Reports describe what actually traded or was bid at a given place and time. The site offers search and archive tools for past reports, and some data can be downloaded. This is the source to use if you need local or regional prices at auctions, terminals or terminal markets, though the length of the archive varies by report, so check what's available for yours.

If you need to understand how a market behaved around a particular season in a particular place, such as a sale barn or a terminal, search the archive by report title and use the date range filters. Many reports can be exported, and you can paste the results into a spreadsheet to build your own multi-year table. Keep the report name and number with the file so you can find it again.

ERS data products

ERS compiles historical data into downloadable files covering crop and livestock prices, costs and returns, and farm income. These tend to be organized by topic, such as feed grains, oil crops, wheat or livestock. They're well suited to long-run comparisons and to spreadsheets, and each product includes documentation. Check the ERS data products page for a list.

Extension and university sources

Many land-grant universities publish historical price tables for their states, including cash prices at local markets and budgets that rely on those prices. Farmdoc daily and similar economist-written sites often reproduce price histories in articles, and some provide charts you can request or download. Ask your county extension office if your state has a local price series, since a few offices maintain their own.

Tips for using the data

Match the series to your question. A five-year average of national prices won't tell you what you would have earned at your elevator. Decide whether you want cash, futures, or farm-level average prices, and stick with one for each comparison.

Watch for revisions and definition changes. Note the units, such as bushels, hundredweight or pounds, and whether prices are nominal or adjusted for inflation. Five years of nominal prices can hide changes in what a dollar bought.

Save a copy of the data you download, along with the source and the retrieval time, in a folder you can find later. Six months from now you'll want to know exactly where the numbers came from.

If you're using the history to plan marketing, also look at costs for the same period. Price without cost is half a picture. The same ERS pages and extension budget tools can help with costs of production.

One more caution: the word average can mean different things. A simple average of monthly prices treats a small month the same as a big one, while a marketing-year average weights prices by how much was sold. Read the source's definition before you compare two series, or you may end up comparing apples to hay bales. When two sources disagree, the definitions are the first place to look.