LEARN HOW TO USE OUR FREE VISUALIZATION TOOL
Purpose of the Free Tool:
Analyze historical USDA "Mid Mostly" Weekly price data for your produce commodity. Filter as desired to create the optimal Graphs or Data Tables.
1. Easy-to-customize Line Graph
Select data that is relevant for your needs: Commodity, Variety, Sub Variety, Shipping Point, Package, Item Size, and Year.
"Select All" or select any number of Criteria by holding the Ctrl key.
Visualize the historical trends and volatility for each Year using your customized filter criteria.
2. Exportable Data Tables
Export the Filtered Data into an Excel, CSV or PDF File. Use the exported data to create your own Pivot Tables in Excel without having to search the USDA website and calculate the mid-mostly.
contains "Calculated Fields" to determine the USDA mid-mostly by week number:
If a "mid-mostly" price is not reported by the USDA, then the Mid-Mostly is calculated by taking an average of low price and high price provided. The Data is exhibited as the Average "Mid Mostly" price for the Week by averaging the Daily Prices.
The Week # is defined by Excel function, =weeknum().
The majority of the Mid-Mostly Prices are expressed as a "per package" Price, however, "Bins" and "Bulk" are expressed as $/LB. Therefore, the Data is less meaningful if Bin (Bulk) Packages are selected with "Case" data.