AgriCharts WebStation and AgPlus Real-Time are built on Windows-based advanced technology that allows you to pull data into an Excel spreadsheet. This can be accomplished using an Excel Add-In.
Please follow these directions to get started:
Download the AgriCharts Excel Plug-In
The Excel Add-In is designed for AgriCharts data to be imported into one worksheet. Any custom views, additional calculations, etc. that you write would be done on another worksheet that links into the data sheet.
{if $site.template.name|strtolower != 'responsive'}{else}{/if} Download the AgriCharts Excel Add-In
(Right click on link and select "Save Target As ...")
Save the Excel Plug-In on your desktop.
Once you have downloaded the Plug-In to your computer, you need to install it.
For assistance, please contact AgriCharts Customer Support at 800-238-5814, 312-554-8122 or realtime@barchart.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: AGDATA(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: ‘=AGDATA(“IBM”,”open”)’ (excluding the single quotes). The following fields are available using the AGDATA() 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
Settings
The settings can be accessed by clicking on the ‘Tools->AgriCharts->Settings’ menu. A dialog will be displayed that contains three options: ‘Username’, ‘Password’, and ‘Connection Mode’.
Enter the user name and password provided by AgriCharts in the corresponding fields. Select the ‘TCP Streaming’ setting in the ‘Connection Mode’ pull-down list.