It certainly can.
You just have to understand that once you pull the data into the spreadsheet it is ONLY in the spreadsheet.
A spreadsheet does not update automatically, it only will update when you run the macro.
After that it is what is referred to as 'uncontrolled data'
But as long as the computer you are running the macro on is on a network that has access to the location you are pulling from, you can pull repeatedly without any issues.
Let me know if you need further assistance.
In the mean time I will switch this to a Q&A format question so you can come back to it at any time. I will also be notified when you make a posting.
*** 4 IMPORTANT THINGS *** (please read them) 1- Please click the ACCEPT button. This is what completes the transaction. 2- Let me know if the answer doesn't work INSTEAD of leaving negative feedback, I will be happy to continue troubleshooting the issue with you to ensure you are satisfied. 3- Positive Feedback is very important to us. Please leave me a positive feedback after you are happy with the answer. 4- Any bonus will be greatly appreciated.
I am very confused how this just answer works!!
Simply can you help and I have no problem paying if can solve my problem.
I will get details and send to you
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.
can you look at my request
its coming from www.agricharts.com