Download the Agricharts Excel ADD-In


Instructions for Excel



Download the Agricharts Excel Add-In

(Click on the button and select "Save" / "Save File") This saves the Excel Add-In on your desktop.


Once you have downloaded the Add-In to your computer, you need to install it.

1. Run the 'Agricharts.AddIn.Setup.msi' installation program, and follow the instructions on your screen.
Note: Make sure the "Just Me" option is selected on the second Installation page:

download excel

2. Open Excel. Select the Add-Ins tab on the ribbon, and click Settings.

download excel

3. Enter your Username and Password in the dialog box that appears. (Leave the "Server" field empty, and leave the "Connection" field set to "Default").

download excel

4. To receive price updates for a contract such as Corn, enter in a cell the following update formula: =RTD("Agricharts.Quotes",,"SYMBOL","field")

Example: =RTD("Agricharts.Quotes",,"ZCH2","last")
Important: Use only a 1-digit year for commodities. 1=2011; 2=2012, etc.

This formula will update the cell with the last price for March 2012 Corn (ZCH2).

Alternatively, you can enter a symbol in a cell to the left of your data fields, such as RJZ1 in cell A2, then enter the formula to use the data found in cell A2, such as =RTD("Agricharts.Quotes",,A2,"last"). Notice that quote marks are not required around A2 in the formula.

download excel

This will result in the last price for the symbol entered in A2. To continue with additional fields to the right, such as timestamp, in cell C2 enter: =RTD("Agricharts.Quotes",,"A2","timestamp")

Get a Sample Spreadsheet


5. To start the update of data into your worksheet, select the Add-Ins tab on the ribbon and click Start.


Note: If you get an error or receive no data, open the Add-Ins tab, and click on Settings. Re-enter your Username and Password. If you have a firewall, you may also set the Connection Mode to HTTP Stream. Click OK to save the settings, and restart Excel.

For assistance, please contact Agricharts Customer Support at 800-238-5814, 312-554-8122 or info@agricharts.com.

Agricharts Excel Add-In Additional Information


This add-in provides the capability of accessing ddfplus real-time data within Excel by using a simple function: =RTD("Agricharts.Quotes",,"Symbol","Field").

In order to use this function, simply enter it in one or more cells specifying the desired symbol as the first parameter and the desired field as the second parameter. For example, to request the 'Open' field value for 'IBM' the following text should be typed in a cell: =RTD("Agricharts.Quotes",,"IBM","open")

The following fields are available using the RTD() function:

"timestamp": date and time of last update
"bid": current bid
"bidsize": current bid size
"ask": current ask
"asksize": current ask size
"open": open
"high": high
"low": low
"close": close
"last": last
"previous": previous price
"volume": volume
"oi": open interest
"previousvolume": previous trading day's volume
"previousoi": previous trading day's open interest