AgriCharts Excel Add-In
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
"previous": previous price
"oi": open interest
"previousvolume": previous trading day's volume
"previousoi": previous trading day's open interest
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.
This is where I am bringing the feed from.
Basically my question/request is can I have this feed come into a spreadsheet and also run a macro.
For example if I have this feed coming in can I have a macro that will list the results ie everytime the feed figure changes can we save it in a list by way of a macro.