Help needed for automated order entry

This is a discussion on Help needed for automated order entry within the Trading Software forums, part of the Commercial category; A collection of thoughts and a request for help. I'm trading futures manually using simple technical indicators on 30-min bars. ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Oct 17, 2017, 1:24pm   #1
Joined Jun 2011
Help needed for automated order entry

A collection of thoughts and a request for help.

I'm trading futures manually using simple technical indicators on 30-min bars. Once using more than a couple of securities, I'm struggling to keep orders orderly, and have experienced input errors, so the obvious solution is to automate order entry using the parameters that I have developed and backtested manually.

I'm using IB, and prefer to stay with the broker as pricing and execution seems good.

Auto-trading seems to be via the IB API, which requires coding in one of several languages including Java, C#, and Python. If possible I prefer not to use a third party API as it introduces another point of failure to the overall system. Python is widely recognised as being modern and relatively easy to learn, and would appear most appropriate for a new user.

I have a fair amount of experience using excel at advanced level, but virtually no coding/programming/development experience.

Searching around the subject brings confusion as after including downloading Python, one needs (variously) Pandas, Anacondas, IBPy, IBridgePy, and many other files, directories, libraries, etc to enable the programme to pass my instructions to IB. For a new user, this again seems to introduce opportunities for error and failure.

So my question is: Can anyone with actual experience help me to convert my excel-based trading instructions into automated orders in my IB account? Whilst grateful for tips and pointers, I am obviously happy to pay for time, advice, coding work outside of the forum.
sideways-sid is offline   Reply With Quote
Old Nov 2, 2017, 3:36pm   #2
 
3 Posts
Joined Nov 2017
Hi,

I can help you. I am a programmer and have experience of connecting Excel to various brokers, including automating Excel based strategies (via the IG Index API). I also have experience of FIX/Bloomberg and have just started looking at the IB API (for C#).

I would probably start by building a custom Excel add-in with various functions to connect to the IB API. This could then be run on either a local PC or Virtual Machine in the cloud.

Let me know if you want to discuss further how I can help you.

Andy
andysinclair is offline Software vendor   Reply With Quote
Old Nov 7, 2017, 11:28am   #3
Joined Jun 2011
sideways-sid started this thread Thank you for taking the time to reply.

I understand (from IB, among other sources) that using Excel as a basis for automated order entry can be problematic.
sideways-sid is offline   Reply With Quote
Old Nov 7, 2017, 6:10pm   #4
 
3 Posts
Joined Nov 2017
I agree, using Excel to automate a system can be problematic.

I suggest a custom piece of software running 24/7 with full monitoring/logging etc. Contact me via private message if you would like me to help you.
andysinclair is offline Software vendor   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
automated trailing stop on a pending order NOT market order francisfinley Spread Betting & CFDs 5 Oct 16, 2010 6:50pm
Trying to understand Hit/Take+ - Order Entry marchitect Trading Software 3 Dec 9, 2008 6:30pm
Excel and Order Entry grantx General Trading Chat 5 Apr 28, 2008 4:02pm
Speedpads for order entry Directional Techies Corner 0 Jan 27, 2006 4:01pm
FX Entry Order Question mik1973 Forex 8 Jul 27, 2004 9:02am

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)