Symbol Guide: USDA Report Data

Back To Previous Screen

IQFeed provides data from the USDA and the CFTC Commitment of Traders Report as part of the USDA and CFTC Data premium service. The reports available include:

USDA Symbology Format

All USDA report data will have symbols that start with a character "U" representing that the data is from the USDA. This will be followed by additional characters representing the report type, commodity, data type, state/national/district location, and a 5YR average signifier if applicable.
The easiest way to get all of the symbols for USDA reports is to use the Symbol Lookup on our website. In the "Filter by Exchange" pull down list, choose USDA for USDA Crop Reports symbols, WASDE for WASDE report symbols or GRNST for grain stocks report symbols. Leave all of the other fields blank or click the "Output Symbols Only" checkbox and you will receive a list of symbols which can easily be cut/paste into your watch list or 3rd party application.

USDA Reports Symbol decode:
U[Report Type]_[Commodity Root]_[Crop Data Type Code].[State or National Location][District Code - if applicable]5YR(if applicable)

Example Grain Stocks Symbol:
US_W_ON.US = Wheat on Farm Storage United States
US_W_ON.TX = Wheat on Farm Storage Texas

Example WASDE:
UW_BO_EXPORT.US = Soybean Oil Exports United States
UW_C_DOMCOMS.NA = Corn Domestic Consumption North America
UW_W_BEGSTK.AS = Wheat Beginning Stocks South Asia
UW_S_TOTSUP.US = Soybeans Total Supply United States

Example USDA Crop Reports:
UD_W_ACR.US = USDA Crop Progress US Wheat Acres Planted
UC_C_POOR.US = USDA Crop Progress US Corn Poor Condition
UC_C_POOR.US5YR = USDA Crop Progress US Corn Poor Condition 5 year average
UC_C_EXCL.IA = USDA Crop Progress Iowa Corn Excellent Condition
UP_S_EMER.US = USDA Crop Progress US Soybeans Emerging

USDA Report Types
Code Description
D Crop Production
Crop Production Data Type Codes
Code Description
HARV Acres Harvested
ACR Acres Planted
YLD Yield Data (BU/Acre)
PROD Production (1000 BU)
C Crop Condition (reported in %)
Crop Condition Data Type Codes
Code Description
VPOR Very Poor Condition - Extreme degree of loss to yield potential, complete or near crop failure. Pastures provide very little or no feed considering the time of year. Supplemental feeding is required to maintain livestock condition.
POOR Poor Condition - Heavy degree of loss to yield potential which can be caused by excess soil moisture, drought, disease, etc. Pastures are providing only marginal feed for the current time of year. Some supplemental feeding is required to maintain livestock condition.
FAIR Fair Condition - Less than normal crop condition. Yield loss is a possibility but the extent is unknown. Pastures are providing generally adequate feed but still less than normal for the time of year.
GOOD Good Condition - Yield prospects are normal. Moisture levels are adequate and disease, insect damage, and weed pressures are minor. Pastures are providing adequate feed supplies for the current time of year.
EXCL Excellent Condition - Yield prospects are above normal. Crops are experiencing little or no stress. Disease, insect damage, and weed pressures are insignificant. Pastures are supplying feed in excess of what is normally expected at the current time of year.
COND Condition Index Value (calculated by DTN) - A weighted index value for each state plus a national index based on the overall crop conditions for each commodity
P Crop Progress (reported in %)
Crop Progress Data Type Codes
Code Description
DENT Dent - Occurs when all kernels are fully dented and the ear is firm and solid. There is no milk present in most kernels.
DOUG Dough - Normally half of the kernels are showing dent with some thick or dough-like substance in all kernels.
EMER Emerged - As soon as the plants are visible.
HARV Harvested - A crop is considered harvested when the crop is cut, threshed, or otherwise gathered from the field.
MATU Mature - Plant is considered safe from frost. Corn is about ready to harvest with shucks opening and there is no green foliage present.
PLNT Planted - A crop is considered planted when the seeds are placed in the ground. For transplanted crops, the planting period refers to the time of setting the plants in the field.
SILK Silking - The emergence of silk like strands from the end of ears. Occurs approximately 10 days after the tassel first begins to emerge from the sheath or 2-4 days after the tassel is emerged.
BLOM Blooming - A plant should be considered as blooming as soon as one bloom appears.
DROP Dropping Leaves - Leaves near the bottom of the plant are yellow and dropping, while leaves at the very top may still be green. Leaves are 30-50 percent yellow.
SETT Setting Pods - Pods are developing on the lower nodes with some blooming still occurring on the upper nodes.
HEAD Headed - The head is present, visible, and fully emerged.
S Grain Storage/Stocks Reports
Grain Storage/Stocks Data Type Codes
Code Description
ON On Farm Storage
TOT Total Storage
OFF Off Farm Storage
W WASDE - World Ag Supply/Demand Estimates
WASDE Data Type Codes
Code Description
BEGSTK Beginning Stocks
DOMCONS Domestic Consumption
ENDSTK Ending Stocks
EXPORT Exports
IMPORT Imports
PRODUCT Production
TOTSUP Total Supply
BEGSTK Beginning Stocks
Commodity Roots
Code Description
C Corn
W Wheat
S Soybeans
SM Soybean Meal
BO Soybean Oil
SW Spring Wheat
WW Winter Wheat

The 2 character state location uses standard US state abbreviations while the national location values will use the following:
National Abbreviations
Code Description
AF Sub-Saharan Africa
AS South Asia
EU European Union
ME Middle East
NA North America
NF North Africa
OC Oceania
OE Other Europe
SA South America
SE Southeast Asia
SU Former Soviet Union
US United States