Google Ad

How to Install TWS on a 64 bit Windows 7 system.

If you are unable to run TWS after installing on a 64 bit system, below are the instructions that will avoid the “missing shortcut” error that you might encounter and allow you to run TWS as expected.

Install 32 bit Java. (remove any old java installations first)
Install TWS (followed by the API if you are using

Continue reading How to Install TWS on a 64 bit Windows 7 system.

How to retrieve live data for SPY futures in Twsdde.xls

The multiplier column in Twsdde.xls is not used by the code that constructs the links to retrieve data. Filling it in has no affect on the contract received. This creates an issue when attempting to retrieve data for Futures with more than one contract available with the same contract expiration month.

As an example, SPY futures

Continue reading How to retrieve live data for SPY futures in Twsdde.xls

Constant Volume Charts added

I have added the option of constant volumeĀ  bar charts (as alternative to time based) for the Excel/VBA based automated trading platform

The constant volume bar option, updates a new bar after a certain amount of volume has completed. This amount should be entered into D3 of the “Live” sheet. Checks are in place to prompt

Continue reading Constant Volume Charts added

Added new file for Live trading with Interactive Brokers

In addition to the free files located under “Instructions and Downloads”, there is now a new file under “Products and Services” for live trading via Interactive Brokers. This Excel VBA based file is an all in one solution for testing, trading and charting.

This is very similar to a version I have been using for my

Continue reading Added new file for Live trading with Interactive Brokers