Looking for some guidance on linking an excel sheet to Interactive Brokers for automated trading, is this possible? I have a scan with symbols and orders that I want executed if my price is met, I dont mind entering all symbols and bids/ offers manually into the spreadsheet as this isnt a high frequency strategy, would just be once a week. I just want something that I can enter all my orders (buy or sell price, then exit or stop out price) and it can run when I am away from my machine. Willing to hire if someone knows or could help me get this up and running. Thanks
Yes, IB offers an API, suitable for multiple software languages. One of them is for spreadsheets. Your starting point will be here: https://www.interactivebrokers.com/en/trading/ib-api.php
I don't have experience with the Excel API but I do know that MS Office was available in 32 and 64 bit versions. I have Office 2010 (32 bits) and the IB API requires a 64 bit version.
Maybe it was older versions (from IB docs): Beginning in API v975, a new DDE API is offered which connects to TWS via a DDE socket bridge that uses the open source Java - DDE interoperability library JDDE. The newer API has some advantages over the legacy DDE API: Compatibility with either 32 or 64 bit TWS (The legacy DDE API is only compatible with 32 bit TWS) Additional functionality matching other socket-based APIs, especially in regards to multiple account structures Full range of market data tick types The DDE socket bridge API is fully backwards compatible with spreadsheets created for the legacy DDE API.