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.
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 if the values are not entered and the constant volume is set to override the default time based bars.
Below is an example of Constant volume bar charting. You will notice that each bar contains roughly the same amount of volume.
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 personal trading for years. However this is a much improved version so I am pretty excited to have it completed and am in the process of converting my personal system over to this version. I hope that others find if useful.
The Youtube video below shows both live trading mode and backtesting mode.
As an example, the following Excel script can be used to post your automated trading system trades into twitter via API. This code can easily be changed to do whatever you want. But in this example it will just be for sending a trade.
Dim symbol As String
Dim Price As String
Dim xml, Username, Password, tweet
Set xml = CreateObject(“MSXML2.XMLHTTP”)
‘change this to your username in quotes
Username = “yourusername”
‘change this to your password in quotes
Password = “yourpassword”
‘let the symbol variable have the symbol name from your excel sheet
symbol = Workbooks(“yourworkbook.xls”).Worksheets(“yoursheetname”).Range(“a1 or your range”)
‘let the Price variable have the symbol name from your excel sheet
Price = Workbooks(“yourworkbook.xls”).Worksheets(“yoursheetname”).Range(“a2 or your range”)
‘contruct the “tweet” this would create “Just bought a gazillion shares of (whatever $SYMBOL you have in A1) @ (whatever price you have in A2)
tweet = “Just bought a gazillion shares of ” & “$” & symbol & ” @ ” & Price
‘post the tweet
xml.Open “POST”, “http://” & Username & “:” & Password & “@twitter.com/statuses/update.xml?status=” & tweet, False
xml.setRequestHeader “Content-Type”, “content=text/html; charset=iso-8859-1”
Set xml = Nothing
If added to an existing excel trading system it may be best to set this to run 20 seconds or so after your actual trade is sent to avoid any interference which can be done as follows
Application.Ontime Now() + timeserial(0, 0, 20), “TWITTER”