Skip to main content

Price Alerts! are here for all

As we bring price alerts to Agronometrics we thought we would pen a piece on our thinking behind the service as well as the methodology for it.

The idea for the Alerts arose from our conversations with the industry, where several people expressed high interest in knowing when there are important changes in the market prices that could affect their business.

This impetus created the Price Alerts! service, whereby we monitor daily average prices of every commodity on our platform, so that you don’t have to. As soon as the difference in price reaches a certain threshold you get an email alerting you of said price change. You can take a look at our sample report through this link (US Avocado Price Alert!)

In order not overflow our users with these email alerts, we have used some fancy statistical analysis and determined the required values so as to send some 12 alerts per year for each commodity. In the table below you will find the list of commodities along with their estimated limits that would trigger and result in a Price Alert! email notifying you of a significant price change.

The last column on the chart is a link that Agronometrics users can use to look at the reports that create the alerts. Although these reports are not ideal for everybody, they are the best we have found so far to summarize each of the commodities we work with.

Price Alert! Trigger Limits by Commodity (Non-Organic)

FruitMeasureLimit LowLimit HighLive Updates
APPLESPrice Per Package-$1.00$1.01Report Link
ASPARAGUSPrice Per Kilo-$0.57$0.57Report Link
AVOCADOSPrice Per Package-$2.48$2.52Report Link
BLACKBERRIESPrice Per Package-$1.39$1.41Report Link
BLUEBERRIESPrice Per Kilo-$1.01$1.02Report Link
CHERRIESPrice Per Kilo-$0.41$0.41Report Link
CLEMENTINESPrice Per Kilo-$0.11$0.11Report Link
GRAPEFRUITSPrice Per Package-$0.43$0.43Report Link
GRAPESPrice Per Kilo-$0.21$0.21Report Link
KIWIFRUITPrice Per Package-$0.69$0.70Report Link
LEMONSPrice Per Kilo-$0.06$0.06Report Link
LIMESPrice Per Package-$2.36$2.35Report Link
MANGOESPrice Per Package-$0.63$0.63Report Link
NECTARINESPrice Per Kilo-$0.11$0.10Report Link
ORANGESPrice Per Kilo-$0.05$0.06Report Link
PEACHESPrice Per Kilo-$0.11$0.10Report Link
PEARSPrice Per Kilo-$0.07$0.07Report Link
PLUMSPrice Per Kilo-$0.12$0.11Report Link
RASPBERRIESPrice Per Package-$1.21$1.21Report Link
STRAWBERRIESPrice Per Package-$1.72$1.71Report Link

Price Alerts! Methodology
For the nerdier fresh produce market observes, below we offer a technical look at how these limits are calculated. To help demonstrate our methodology, we can look at the last six months of Non-Organic Avocado prices, which, of all the categories we track, has been the most volatile.

This chart shows the daily average price calculated by Agronometrics, with prices ranging from $23.75 on the 15th of February 2019, to a peak of $72.51 on the 16th of July 2019. During that time the market has been littered with massive price swings from one day to the next, which provide useful intelligence to market observers.

USDA Avocado Non-Organic Prices

(Source: USDA Market News via Agronometrics)
[Agronometrics users can view this chart with live updates here]

Because the pricing data is not strictly continuous and is broken up by weekends, holidays, or unavailability of fruit on the market, it is necessary to fill in such gaps. This is done by simply using the last price calculated. This means that if there is a big difference between the last price reported on Friday and the newest price on Monday, the Price Alert! will be generated and sent on said Monday.  A similar process is performed for any sort of extended time period where pricing is unavailable. The chart below demonstrates what the same data looks like with the gaps filled in.

USDA Avocado Non-Organic Prices

(Source: USDA Market News via Agronometrics)

The next step in the process helps us visualize the changes in each price observed. The calculation is straighforward, simply subtracting the last price reported by the previous price reported. The chart below shows us what the difference in prices looks like for the time period we are observing. These peaks and dips are the raw material for Price Alerts!

Difference in Daily Avocado Prices

(Source: USDA Market News via Agronometrics)

Because prices change almost every day and we don’t want to flood email boxes, we have to establish a limit that only informs us of significant price swings and lets the rest carry on without bothering us. To accomplish this across every commodity we track, for the five years of daily history we used as our test population, we relay on a basic statistical tool called a Standard Deviation. This tool allows us to describe the distribution of a population of values by measuring the distance from average that encompasses an expected percentage of the observations.

This isn't an arithmetic lesson, so we won't go step-by-step into how to make the calculation and the transformation we used to determine the final cut off, but rather our focus is the interpretation of its results. The chart below shows what the distribution of the difference in price looks like. The average for the dataset we looked at is $0.0147 with a standard deviation of $1.09. The numbers at the bottom are the standard deviations represented by the symbol σ. So this means that 1σ is amount of changes in price that we have measured in the last five years between the average plus one standard deviation, so between $0.0147 and $1.1047. -1σ is the number of changes in price that we have measured in the last five years between between average minus one standard deviation, or -1.0753. The same applies to the rest of the standard deviations in the chart.

In general +/- 1σ = 68.1% of the observations, +/- 2σ = 95.4% of the observations, +/- 3σ = 99.6% of the observations.

Distribution of Difference in Daily Avocado Prices

(Source: USDA Market News via Agronometrics)

The values we calculated by themselves are interesting. The positive average price for the dataset tells us that over the last five years prices have increased, which already says a lot about the category and its projection. We can also see that -1σ is higher than 1σ. This is also really interesting because it tells us that when prices fall they do so in smaller increments, and when they rise they go up faster. This observation is reinforced with 2σ being larger than -2σ.

With this information at hand and a bit of proprietary secret sauce, we can calculate what the standard deviation has to be for us to generate approximately 12 reports a year. Admittedly an arbitrarily chosen Goldilocks number that we trust is not too many email alerts, nor not too few, but rather results in sending on average one alert per month.

For Avocados, the standard deviation that would create 12 reports a year comes out to 2.3σ, giving us the lower limit of -$2.48 and the upper limit of $2.52. If we look again at the difference in daily prices over the last six months of avocado prices we can appreciate what these limits look like.

USDA Avocado Non-Organic Prices

(Source: USDA Market News via Agronometrics)

Following this methodology, our Price Alerts! system would have had created 13 emails in the last six months. Sending several between March and April indicating sharp rises in prices. Between April and May there were two alerts notifying of a fall in price, and between May and June there were three alerts notifying that prices were rising again. The rest of the reports after the 15th of June let us know that prices have been falling steadily. If we compare these results against the first chart of this article we can clearly see how the alerts follow the general trend of the prices quite remarkably.

As was stated earlier, the objective of this tool is to send 12 alerts a year, a measure that, in Avocados, we have already surpassed. This doesn't mean that the system will stop working, but it does say that we are seeing greater volatility than in the last five years. If the prices jump or dip again above the established thresholds, then the service will send more alerts. Because markets are constantly changing and evolving, we will periodically revisit these calculations and adjust the values to ensure that our limits are relevant to the data and categories we work with.

We also strive to constantly improve our service and invite any comments, opinions and suggestions to the service and the methodology. And as always, feel free to write to us at

Written by: Colin Fain


Popular posts from this blog

Blueberry boom: Worldwide growth creates challenges for NW producers

Overview of the northwest blueberry season by Doug Krahmer of Berries Northwest, Cort Brazelton of Fall Creek Farm and Nursery, Kasey Cronquist of the U.S. Highbush Blueberry Council and Mark Hurst of Hurst's Berry Farm, complemented by charts from Agronometrics.

Original published in on July 30, 2020

ALBANY, Ore. — On a seasonably warm July afternoon in the fertile Willamette Valley, Doug Krahmer stood between rows of organic blueberries and watched as a large mechanical harvester rolled slowly through the field, rattling bushes heavy with ripe fruit.

Measuring a little more than 15 feet tall, 11 feet wide and weighing 7 tons, the harvester seemingly floated in the distance over neat rows while fiberglass rods, or “fingers,” shook the berries onto a conveyor belt that swooped them to the upper deck and into plastic crates.

From there, the crates were loaded into refrigerated trucks and driven from the farm north of Albany, Ore., to a packing shed east of Po…

The table grape industry is in uncharted territory right now

Overview of the potential impact of COVID-19 on future grape supply and price, by Ira Greenstein of Direct Source Marketing, complemented by charts from Agronometrics.

Original published in on March 24, 2020

While the Chilean and Peruvian grape seasons are winding down and their weekly volumes are decreasing, the table grape industry has seen an uptick in demand in the past weeks. This is partially a result of the high retail movements due to the coronavirus panic-shopping of the past few weeks. Ira Greenstein of Direct Source Marketing says: “A month ago, importers had a real concern that the industry wouldn’t be able to move through the condensed volumes and huge inventories would be sitting in cold storages. That sentiment has completely reversed with substantially increased retail demand due to the COVID-19 pandemic.”

With the lower volumes but increasing demand, the cold stores are rapidly being depleted and spot market pricing is expected to continue to increase, …

Avocados In Charts - Prices are falling and why are they likely to settle below 2018

Agronometrics has often spoken about what is to come and how the market could be affected. We hold a strong belief in being able to look at objective data can help navigate complicated scenarios. The recent spike in prices that avocados have seen is an example of one of these scenarios, catching many by surprise at a time of the year where we had never seen movements like this before. This can be seen in the chart below where the 2019 line has towered above all other prices since Sept. 2017 and every price recorded for June in the last five years.

Historic Hass Avocado Prices

Source: USDA Market News via Agronometrics. (Agronometrics users can
view this chart with live updates here)
Comparing the volumes of this year to the last can offer some insight as to how these prices have come about. Considering the prices were almost flat last year, the volume data serves as a great benchmark to understand where customers expectations lie.

In this year’s data, an important oversupply can be …