Globex Grains and USDA Crop Progress Reports

This Microsoft Excel® dashboard has two parts: the top half pulls the forward curves for soybeans, corn, and wheat traded on the CME Globex platform and the bottom half pulls the USDA Crop Progress Reports by date. The USDA reports are issued at the start of April and end in November. The dashboard can pull in reports as far back as the year 2000.

There is a drop-down menu just below and to the far of left the soybean chart. The menu lists the corn, soybeans, winter wheat, and spring wheat crops.  Next to the crop selection is a drop-down menu that allows you to pick a particular stage of the crop progress. Each crop has some similar stages, such as planted and harvested, and each crop has unique stages, such as Corn Silking and Soybeans Blooming. If you select a crop and do not select a correct stage, then you will see “mismatched” highlighted in red next to the drop-down menu. If the particular stage data is not in the report, then “Not Available” is displayed in the table.

On the left side of the table there is a Get Data radio button where you enter the month, day, and year for the data. Nearly all of the crop reports are issued on a Monday. Occasionally, Monday is a holiday and the report is issued on a Tuesday. When you enter in the value for the day, Microsoft Excel will show you the day of the week, so you can easily pick a Monday. Then, simply click the Get Data radio button. The table then shows you the current report’s crop progress as a percentage by state. Also displayed is the data one week back and the difference. Next is the data from one year ago and the difference from the current report. Finally, the five-year average is listed and the difference from the current report.

The next section of the table shows the condition of the crop by state ranging from very poor to excellent.

The third section offers the ability to do comparative analysis. You enter in a date and as long as the same data is available on that date, you will see the value and the difference. The section titled crop conditions difference details the difference between the crop conditions. For example, if the first value in the Excellent column in the crop conditions table reads 20 and the first value in the Excellent column in the crop condition difference table displays 9, then the condition for that date was 11 and has climbed by 9 percent points. From the image above, the June 24, 2018 Soybeans condition report for Arkansas showed that 20% of the crop was Excellent, and the report from June 18, 2001 was a difference of 9%, so then the conditions report is 11% on June 18, 2001, and it improved by 9%.

There is a tab that shows what details in general are in each weekly report.

Note: If you enter a date, then select Get Data, and see the following error, the date entered is incorrect.

Requires either CQG Integrated Client or CQG QTrader. 

Download the Excel File ‌‍‍‍‍

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.