How do I find average seasonal price trends?
Build or borrow a seasonal index
TOPEKA, Kansas — You find average seasonal price trends by pulling several years of monthly prices for the commodity and location you sell, then comparing each month with the yearly average. Some university economists and extension offices publish ready-made seasonal charts, and you can build your own from public data. Start with AgMRC, the Iowa State Ag Decision Maker library, farmdoc daily and the monthly price series from NASS.
A seasonal pattern is the tendency for prices to rise or fall at certain times of year, such as around harvest or before the grilling season. It is a tendency, not a rule, and it can fail badly in any given year.
Option one: find a published chart
Extension economists and commodity marketing sites often include seasonal price charts in their market outlook pages. Search the sites above for the commodity name plus "seasonal." Look for what years the chart covers, what price series it uses (cash, futures, or a state average), and whether it was built from a few years or many. A chart based on a handful of years can mislead, since one drought or one trade dispute can dominate the average.
Livestock markets carry strong seasonal patterns too, for reasons tied to calving, weaning and demand. State extension beef and livestock economists often publish their own versions.
Option two: build your own
This takes an hour and a spreadsheet.
- Download monthly price data for your commodity. NASS publishes prices received by farmers, and some state and university sources offer local cash prices.
- Put the same number of years side by side, ideally many years rather than few.
- For each year, divide each month's price by that year's average, so every month becomes a ratio.
- Average each month's ratios across years.
The result is a seasonal index. A figure above one for a month means prices in that month have tended to run above the yearly average, and below one means the opposite.
Spreadsheet programs make this easy. Most have an average function and a simple chart tool, so once the ratios are in place you can graph the index and see the shape at a glance. Label the chart with the source, the years covered and the date you pulled the data, so you can explain it later to a lender or a business partner.
Use your own local series if you can
National charts hide local differences. Your own elevator's cash bids, or a cash price series from a regional report at AMS Market News, reflect your basis, and basis has its own seasonal rhythm. A seasonal low in futures may be offset or exaggerated by basis at your delivery point. If you can build a local series covering several years, you'll see the pattern that matters for your checkbook.
Know the limits
Averages smooth out the years that surprised everyone. If a pattern appears in nine years out of ten, the tenth may be the one you happen to be farming. Policy changes, export disruptions, weather and energy markets can overwhelm a seasonal tendency. Treat the index as one input alongside supply and demand information, your storage costs and your cash flow needs.
Check the data source's notes, too. Series get revised, and some seasonal charts use different adjustments. Where the source explains its method, read it.
A useful discipline is to test the pattern against the past. Take your seasonal index and ask how often prices in the so-called high month actually beat the so-called low month. If the answer is closer to a coin flip than you expected, treat the pattern as a mild lean at best. A pattern that holds only in the average is a thin reason to sit on grain you could sell.
Turn it into a habit
Put the seasonal index next to your marketing plan, and note in advance what you'll do if prices follow the usual pattern and what you'll do if they don't. Some producers use the pattern to spread sales across several months instead of selling all at once. That's a decision about risk, not a prediction.
Update the chart every year after harvest. It takes minutes, and your own record beats a remembered impression.
