DTN Grain Bids – Relevant Fields

ProphetX

DTN Grain Bids - Relevant Fields

Quote  Fields

These QUOTE fields are specific to Cash Grains:

  • PRICE – This should be the last bid value. It will also be int he Last and Settlement fields.
  • BASIS – The basis based on the related future symbol.
  • ELEVATOR ID – The elevator ID for the symbol.
  • ELEVATOR NAME – The name of the elevator.
  • ELEVATOR STATE – The state the elevator is in.
  • ELEVATOR COUNTY – The county the elevator is in.
  • ELEVATOR CITY – The city the elevator is in.
  • ELEVATOR ZIP – The zip code of the elevator.
  • ELEVATOR LATITUDE – The latitude of the elevator.
  • ELEVATOR LONGITUDE – The longitude of the elevator.
  • ELEVATOR DISTANCE – The distance of the elevator from a known point.
    • Using the Latitude and Longitude and the distance form a known location, it is easy to find the N number of elevators that are X miles from your location using the Great Circle Distance calculation.
  • BASIS SYMBOL – The future symbol currently used to calculate the Basis.
  • INPUT TYPE – Notes how the bid was collected:
    • 1 = Basia Quote
    • 2 = Cash Price Quote
    • 3 = Both were received for the day
  • START DELIVERY – Beginning of the delivery period for a particular price quote.
  • END DELIVERY – End of the delivery period for a particular price quote.
  • CURRENCY – Currency the value is being displayed in.
  • QUOTED CURRENCY – Currency the value is quoted to DTN in.
  • DELIVERY – Marker for SPOT or NEW CROP symbols.
    • e.g. CORN$.9999 or CORN.9999
  • FIPS CODE – Numbers which identify unique geographic areas.
    • State-level FIPS codes have two digits.
    • County-level FIPS codes have five digits.
      • The first two digits are denote the state the county is in.
  • QUOTED BASIS – Original basis value that was quoted to DTN, often in $X.xx format. The basis specific symbols are displayed in the xx cents.
  • UNIT \ QUOTED UNIT – See below.
Units

The DTN Cash Grain Symbols have a unit field associated with them. This field is a 1 character field that contains one of the values below. ProphetX currently displays the ASCII value of the character rather than the character.

Unit Code ASCII Value Description
B 66 Bushel
C 67 Hundred Weight
L 76 Long Ton
M 77 Metric Ton
S 83 Short Ton
OpenInterest
  • In HISTORY, OpenInterest stores the underlying future symbol associated with that date’s value. Using the ProphetX Tabular display will translate directly to recognizable symbols. Using RTD links, CCYYYYMM is returned.
    • CC = Product Code
    • YYYY = 4 digit year
    • MM = 2 digit month
  • So 11201705 corresponds to @CK17 Basis Symbol (see the product code table below)
Product Code Root Description
10 @B Barley
11 @C Corn
12 @KW Hard Red Winter Wheat
13 @MW Hard Red Spring Wheat
14 @O Oats
15 @RR Rough Rice
16 @RS Canola
17 @S Soybeans
18 @SM Soybean Meal
19 @W Wheat
Volume
  • The Last Volume field is used to denote if the update was from a Basis quote (1) or a Cash Price quote (2). That value will also be sent to history for the tick volume.
  • The value stored in the volume field of daily historical data will be:
    • 1 = Basis Quote
    • 2 = Cash Price Quote
    • 3 = Both were received for the day