Record Daily Market Prices

After setting up your Grain Trader Pricing Points you will be able to record the Daily Market Price for each Commodity and Pricing Point. This is carried out on the Daily Market Prices window from the View | Daily Market Prices menu.

For each Commodity Group, you select a Base Commodity (grade) from which the Daily Market Prices of all other Commodities (grades) in that Group are calculated. To designate the Base Commodity just select it by clicking in any cell in that row in the grid then click the Set as Base button. The Base Commodity/grade is always shown at the top of the Group and is highlighted with a yellow background.

When you select a Base Commodity, any adjustment amounts already recorded for other Commodities in that Group will not be changed. The Daily Market Price for the new Base Commodity, and the adjustment amount for the old one if any, are both reset to zero.

If the selected Commodity is already the Base for that Group the Set as Base button is greyed out.

You then enter an adjustment amount (plus or minus) for each other Commodity/grade in the Group and for each Pricing Point into the cells for those Commodities. You should select a Base Commodity before entering the adjustment amounts for each other Commodity/grade in the Group. When entering data in the grid you can press the <TAB> key to accept your entry and move to the next cell to the right or next row down as applicable, click in another cell with the mouse, or press <ENTER> and use the arrow keys or mouse to move from cell to cell.

For example, you could designate F1 Barley as a Base Commodity. Then at a particular Pricing Point you might assign a price adjustment of -$40 for F2, -$70 for F3 and so on. You do not need to enter dollar signs in the grid cells; these are added automatically.

Whenever you have changed a value in the grid, the affected cells are all highlighted in bold, and the heading for the Group is prefixed with an asterix, in order to give you visual clues about what has been changed. These highlights are removed when your changes have been saved.

If you leave the default value of $0 in the non-Base Commodity cells, no adjustment will be made in the Mark to Market report for that combination, that is, the Daily Market Price for the Base Commodity will be used “as is” for the non-Base Commodity. If you leave the Daily Market Price for the Base Commodity as zero your report will reflect that also, and any adjustments recorded for non-Base Commodities will be applied to zero and also reflected in the report.

You then need only enter the Daily Market Price for each Base Commodity on a regular basis, and all the derived prices will automatically be recalculated.

You can toggle a preview of the overall picture by clicking the Preview button:

Click Apply to save any changes and leave the window open, or OK to save changes and close the window.

You also have the option to copy Daily Market Price formulas to a new Commodity (provided the existing Commodity is not the Base Commodity for the Commodity Group) when using the Copy to New button on the Commodity window:

Back: Mark to Market Profit & Loss Report · Next: Assign Pricing Points and Zones to Contracts