We have developed many Microsoft Excel and VBA tools for financial analysis, advanced charting, website development and other applications. We are making a small selection of these tools available for personal or commercial use, free of charge. The source code may be modified in any way. In return for our efforts, we only ask that you create a link back to our site.
Collective 2 Signal Upload and XML reader
If you are a trading system developer on collective2.com then you may want to take advantage of their XML API requests. With this Excel / VBA application, you can perform simple tasks such as placing orders and confirming buyer power in Excel. You can manage your trading system remotely in Excel and avoid web browsers all together.
Download the Collective2 Tool ver 1.0 here.
From time to time, we may improve this code, time permitting. Check back for updates. Below are brief instructions to make the application work.
- The Microsoft XML reader requires a unique reference. If the code does not work on your computer, a missing reference is the likely cause. To add the reference, open this file in Excel, press Alt-F11 to open the VBA editor, select Tools-->References, scroll to Microsoft XML, v6.0, check the box, and press OK to close the dialog box.
- Macros must be enabled for the tool to work properly.
- Plug in your system ID and password to point URLs at your system.