So for interest's sake, per stormin's suggestion, I am starting a new thread to update on my effort to develop an FX autotrader using Excel. Having said that, it can also be relatively easily adapted to trade anything on IB. This for me is a major undertaking given that this is the FIRST time I have ever tried programming.
The last error I discovered resulted in the order placing module under a certain condition to continue looping without ever exiting resulting in a potentially infinite number of new orders being sent. Catastrophically bad...!
I think I've isolated and fixed that, but we'll see.
Once I'm fully operational I hope to go into some detail on how I'm doing it (without disclosing the exact trading system). Due to a long discussion with wabbit today, I also hope to start learning MQL4 and learn to write EAs from scratch, as I recognise the cumbersome nature of this exercise.
Anyways, I have the relevant charts open in Metastock, and here is a pic of my trading spreadsheet. It's basically the IB sample sheet with a whole bunch of my own code and buttons added.
Theoretically, when it's running I don't need to do anything - but each of the buttons can be used for either manual trading (when auto off) or for overriding the auto if needed, though I've yet to add that functionality.
There actually seem to be quite a few people here who write their own autotrader's using C++/# or whatever. Would be good to hear from more about ins and outs, etc. Would probably really benefit us programming noobs.
EDIT: Yes, looping error has been fixed!!! Just did exactly what it was meant to!!!! It has now gone through several full cycles of ordering/modifying/closing/cancelling/etc successfuly.